driver = mysql
connect = host=127.0.0.1 dbname=mail user=mail password=mypass
default_pass_scheme = CRAM-MD5
password_query = SELECT username AS user, password, CONCAT('/var/mail/vhosts/',SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1)) AS userdb_home, '5000' AS userdb_uid, '5000' AS userdb_gid FROM users WHERE username = '%u'
user_query = SELECT username AS user, password, CONCAT('/var/mail/vhosts/',SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1)) AS home, '5000' AS uid, '5000' AS gid FROM users WHERE username = '%u'