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