123456789101112 |
- user = mailuser
- password = mailuserpass
- hosts = 127.0.0.1
- dbname = mailserver
- query = SELECT CONCAT(`virtual_users`.`username`, '@', `virtual_domains`.`name`) as destination
- FROM `mailserver`.`virtual_aliases`
- INNER JOIN `mailserver`.`virtual_users`
- ON `virtual_users`.`id` = `virtual_aliases`.`user_id`
- INNER JOIN `mailserver`.`virtual_domains`
- ON `virtual_domains`.`id` = `virtual_users`.`domain_id`
- AND `virtual_domains`.`name` = SUBSTRING_INDEX('%s', '@', -1)
- WHERE `virtual_aliases`.`alias` = SUBSTRING_INDEX('%s', '@', 1);
|