dovecot-sql.conf.ext

dovecot-sql.conf.ext (text/plain), 444 bytes, created by Lutz Schildt on 2012-05-13 01:16:21 UTC

driver = mysql

connect = host=/var/run/mysqld/mysqld.sock dbname=db_zzz user=user_xxx password=password_yyy

default_pass_scheme = CRYPT

password_query = \
  SELECT username AS user, password_enc AS password \
  FROM mail_users WHERE username = '%u' AND postfix = 'Y'

user_query = \
  SELECT CONCAT(homedir, maildir) AS home, CONCAT('maildir:', homedir, maildir) AS mail, uid, gid \
  FROM mail_users WHERE username = '%u' AND postfix = 'Y'