У поштовій системі використовується зв'язка postfix+dovecot+mysql для зручності адміністрування PosfixAdmin.
Dovecot
password_query = SELECT username as user, password FROM mailbox AS t1 LEFT JOIN \ alias_domain AS t2 ON alias_domain='%d' AND t2.active='1' \ WHERE local_part = '%n' AND (t1.domain="%d" OR t1.domain=t2.target_domain) \ AND t1.active='1'
user_query =
SELECT concat('/home/vmail/',maildir) AS home, \
concat('/home/vmail/',maildir,'dovecot.sieve') AS sieve, \
5000 AS uid, 5000 AS gid, concat('*:bytes=',floor(quota)) AS quota_rule \
FROM mailbox AS t1 LEFT JOIN alias_domain AS t2 ON alias_domain='%d' AND t2.active='1' \
WHERE local_part = '%n' AND (t1.domain="%d" OR t1.domain=t2.target_domain) \
AND t1.active='1'
