mysql-virtual-alias-maps.cf 541 B

123456789101112
  1. user = mailuser
  2. password = mailuserpass
  3. hosts = 127.0.0.1
  4. dbname = mailserver
  5. query = SELECT CONCAT(`virtual_users`.`username`, '@', `virtual_domains`.`name`) as destination
  6. FROM `mailserver`.`virtual_aliases`
  7. INNER JOIN `mailserver`.`virtual_users`
  8. ON `virtual_users`.`id` = `virtual_aliases`.`user_id`
  9. INNER JOIN `mailserver`.`virtual_domains`
  10. ON `virtual_domains`.`id` = `virtual_users`.`domain_id`
  11. AND `virtual_domains`.`name` = SUBSTRING_INDEX('%s', '@', -1)
  12. WHERE `virtual_aliases`.`alias` = SUBSTRING_INDEX('%s', '@', 1);