mysql-virtual-mailbox-maps.cf 353 B

123456789
  1. user = mailuser
  2. password = mailuserpass
  3. hosts = 127.0.0.1
  4. dbname = mailserver
  5. query = SELECT 1 FROM `mailserver`.`virtual_users`
  6. INNER JOIN `mailserver`.`virtual_domains`
  7. ON `virtual_domains`.`id` = `virtual_users`.`id`
  8. AND `virtual_domains`.`name` = SUBSTRING_INDEX('%s', '@', -1)
  9. WHERE `virtual_users`.`username` = SUBSTRING_INDEX('%s', '@', 1)