Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [got][/usr/local/etc/postfix]# cat mysql_virtual_mailboxes_maps.cf
- user = postfix
- password = postfix
- dbname = postfix
- hosts = localhost
- query = SELECT maildir FROM mailbox WHERE username='%s' AND active = 1
- [got][/usr/local/etc/postfix]# cat mysql_virtual_mailbox_limit_maps.cf
- user = postfix
- password = postfix
- hosts = localhost
- dbname = postfix
- query = SELECT quota FROM mailbox WHERE username='%s' AND active = '1'
- [got][/usr/local/etc/postfix]# cat mysql_virtual_domains_maps.cf
- user = postfix
- password = postfix
- dbname = postfix
- hosts = localhost
- query = SELECT domain FROM domain WHERE domain='%s'
- [got][/usr/local/etc/postfix]# cat mysql_virtual_alias_maps.cf
- user = postfix
- password = postfix
- hosts = localhost
- dbname = postfix
- query = SELECT goto FROM alias WHERE address='%s' AND active = 1
- [got][/usr/local/etc/postfix]# cat mysql_virtual_alias_domain_maps.cf
- user = postfix
- password = postfix
- hosts = localhost
- dbname = postfix
- query = SELECT goto FROM alias,alias_domain WHERE alias_domain.alias_domain = '%d' and alias.address = CONCAT('%u', '@', alias_domain.target_domain) AND alias.active = 1 AND alias_domain.active='1'
- [got][/usr/local/etc/postfix]# cat mysql_virtual_alias_domain_mailboxes_maps.cf
- user = postfix
- password = postfix
- hosts = localhost
- dbname = postfix
- query = SELECT maildir FROM mailbox,alias_domain WHERE alias_domain.alias_domain = '%d' and mailbox.username = CONCAT('%u', '@', alias_domain.target_domain) AND mailbox.active = 1 AND alias_domain.active='1'
- [got][/usr/local/etc/postfix]# cat mysql_virtual_alias_domain_catchall_maps.cf
- # handles catch-all settings of target-domain
- user = postfix
- password = postfix
- hosts = localhost
- dbname = postfix
- query = SELECT goto FROM alias,alias_domain WHERE alias_domain.alias_domain = '%d' and alias.address = CONCAT('@', alias_domain.target_domain) AND alias.active = 1 AND alias_domain.active='1'
- [got][/usr/local/etc/postfix]#
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement