Source

iredmail / iRedMail / samples / postfix / mysql / domain_alias_maps.cf

Full commit
1
2
3
4
5
6
user        = vmail
password    = NSep2RRC7vzN9k6dW5bnc07fTLDEW7
hosts       = 127.0.0.1
port        = 3306
dbname      = vmail
query       = SELECT alias.goto FROM alias,alias_domain,domain WHERE alias_domain.alias_domain='%d' AND alias.address=CONCAT('%u', '@', alias_domain.target_domain) AND alias_domain.target_domain=domain.domain AND alias.active=1 AND alias_domain.active=1 AND domain.backupmx=0