summaryrefslogtreecommitdiff
path: root/templates/virtual/database/mysql_virtual_alias_domain_mailbox_maps.cf.erb
blob: 9f16c20b7816026f45269bd1a50c6809c3bdf705 (plain)
1
2
3
4
5
user      = <%= scope.lookupvar('mail::virtual::database_user') %>
password  = <%= scope.lookupvar('mail::virtual::database_password') %>
hosts     = <%= scope.lookupvar('mail::virtual::database_host') %>
dbname    = <%= scope.lookupvar('mail::virtual::database_name') %>
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'