driver = mysql
connect = host=127.0.0.1 dbname=postfixadmin user=postfix password=yourpassword
default_pass_scheme = MD5-CRYPT

user_query = SELECT '/var/vmail/%d/%u' as home,'maildir:/var/vmail/%d/%u'as mail, 1001 AS uid, 
1001 AS gid FROM mailbox WHERE username = '%u' AND active = '1'

password_query = SELECT username as user, password, '/var/vmail/%d/%u' AS userdb_home, 
'maildir:/var/vmail/%d/%u' as userdb_mail, 1001 as userdb_uid, 1001 as userdb_gid FROM mailbox 
WHERE username = '%u' AND active = '1'