debian6_dovecot-sql.conf.master

# http://wiki.dovecot.org/AuthDatabase/SQL
#
# CREATE TABLE users (
#     userid VARCHAR(128) NOT NULL,
#     password VARCHAR(64) NOT NULL,
#     home VARCHAR(255) NOT NULL,
#     uid INTEGER NOT NULL,
#     gid INTEGER NOT NULL,
#     active CHAR(1) DEFAULT 'Y' NOT NULL
# );

driver = mysql
connect = host={mysql_server_host} dbname={mysql_server_database} user={mysql_server_ispconfig_user} password={mysql_server_ispconfig_password}
default_pass_scheme = CRYPT

password_query = SELECT password FROM mail_user \
	WHERE login = '%u' AND disable%Ls = 'n'

# Old user query quota part
#	CONCAT('*:storage=', quota , 'B') AS quota_rule
# Old user query with email instead of login
#	WHERE email = '%u' AND disable%Ls = 'n'

user_query = SELECT email as user, \
	maildir as home, \
	CONCAT('maildir:', maildir, '/Maildir') as mail, \
	uid, \
	gid, \
	CONCAT('*:storage=', floor(quota/1024), 'B') AS quota_rule, \
	CONCAT(maildir, '/.sieve') as sieve \
	FROM mail_user \
	WHERE email = '%u' AND disable%Ls = 'n'