user = __DB_RO_USER__ password = __DB_RO_PASS__ hosts = __DB_HOST__:__DB_PORT__ dbname = __DB_NAME__ # Identity expansion for real mailboxes so Postfix does not fall through to # @domain catch-all aliases (which would rewrite every address to postmaster). query = SELECT CONCAT(a.local_part,'@',d.name) FROM accounts a JOIN domains d ON a.domain_id=d.id WHERE CONCAT(a.local_part,'@',d.name)='%s' AND a.is_active=1 AND d.is_active=1