driver = mysql
connect = host=127.0.0.1 dbname=mailer user=mailer password=***reducted***
default_pass_scheme = PLAIN-MD5

user_query = SELECT '/home/vmail/%d/%n' as home, 'vmail' as uid, 'vmail' as gid, mailbox as mail, 'tcps:mx1.example.com:12345' as mail_replica FROM virtual_users LEFT JOIN virtual_domains ON virtual_users.domain_id = virtual_domains.id WHERE virtual_users.user='%n' AND virtual_domains.name='%d';

password_query = SELECT password FROM virtual_users LEFT JOIN virtual_domains ON virtual_users.domain_id = virtual_domains.id WHERE virtual_users.user='%n' AND virtual_domains.name='%d';

iterate_query = SELECT CONCAT(u.user, '@', d.name) AS user FROM virtual_users as u LEFT JOIN virtual_domains AS d on u.domain_id = d.id;