postfix virtual_domains query fails
"select_field" in install/tpl/mysql-virtual_domains.cf.master:
user = {mysql_server_ispconfig_user} password = {mysql_server_ispconfig_password} dbname = {mysql_server_database} table = mail_domain select_field = 'domain' where_field = domain additional_conditions = and server_id = {server_id}
should be "select_field = domain" instead of "select_field = 'domain'"
Otherwise the result of the query will always be 'domain'
SELECT 'domain' FROM mail_domain WHERE domain='test.com' and server_id = 1; +--------+ | domain | +--------+ | domain | +--------+
SELECT 'random-string' FROM mail_domain WHERE domain='test.com' and server_id = 1; +---------------+ | random-string | +---------------+ | random-string | +---------------+