Code: ›
default_pass_scheme = CRYPT
password_query = SELECT email as user, password FROM server_users WHERE email = '%u'
user_query = SELECT home, uid, gid, CONCAT('*:bytes=', CAST(quota AS CHAR)) AS quota_rule FROM server_users WHERE email = '%u' AND access = 'Y'
# 1.2.11: /etc/dovecot/dovecot.conf
# OS: Linux 2.6.26-2-openvz-amd64 x86_64 Debian 5.0.4 simfs
base_dir: /var/run/dovecot/
log_timestamp: .%Y-%m-%d %H:%M:%S .
protocols: imap pop3
listen(default): *:143
listen(imap): *:143
listen(pop3): *:110
disable_plaintext_auth: no
login_dir: /var/run/dovecot/login
login_executable(default): /usr/lib/dovecot/imap-login
login_executable(imap): /usr/lib/dovecot/imap-login
login_executable(pop3): /usr/lib/dovecot/pop3-login
login_greeting: Dovecot server ready.
first_valid_uid: 1000
last_valid_uid: 1000
mail_access_groups: mail
mail_location: maildir:/home/mail%h
mail_debug: yes
mbox_write_locks: fcntl dotlock
mail_executable(default): /usr/lib/dovecot/imap
mail_executable(imap): /usr/lib/dovecot/imap
mail_executable(pop3): /usr/lib/dovecot/pop3
mail_plugins(default): quota imap_quota
mail_plugins(imap): quota imap_quota
mail_plugins(pop3): quota
mail_plugin_dir(default): /usr/lib/dovecot/modules/imap
mail_plugin_dir(imap): /usr/lib/dovecot/modules/imap
mail_plugin_dir(pop3): /usr/lib/dovecot/modules/pop3
lda:
postmaster_address:
postmaster@mydomain.com
sendmail_path: /usr/lib/sendmail
auth_socket_path: /var/run/dovecot/auth-master
auth default:
user: nobody
verbose: yes
debug: yes
debug_passwords: yes
passdb:
driver: sql
args: /etc/dovecot/dovecot-sql.conf
userdb:
driver: sql
args: /etc/dovecot/dovecot-sql.conf
socket:
type: listen
client:
path: /var/spool/postfix/private/auth
mode: 432
user: postfix
group: postfix
master:
path: /var/run/dovecot/auth-master
mode: 432
user: vmail
group: mail
plugin:
quota: dict:user::proxy::quotadict
dict:
quotadict: mysql:/etc/dovecot/dovecot-dict-sql.conf