driver = mysql
connect = host=localhost dbname=mailserver user=mail_admin password=.....

# The new name for MD5 is MD5-CRYPT so you might need to change this depending on version
#default_pass_scheme = MD5
default_pass_scheme = PLAIN

# Get the mailbox
user_query = SELECT '/home/vmail/%d/%n' AS home, 'maildir:/home/vmail/%d/%n' AS mail, 5000 AS uid, 5000 AS gid, CONCAT('dirsize:storage=', quota) AS quota FROM users WHERE email = '%u'

# Get the password
password_query = SELECT email AS user, password, '/home/vmail/%d/%n' AS userdb_home, 'maildir:/home/vmail/%d/%n' AS userdb_mail, 5000 AS userdb_uid, 5000 AS userdb_gid FROM users WHERE email = '%u'