ROUTE_QUERY = SELECT '"<+ ' || array_to_string(ARRAY(SELECT address FROM routedata WHERE enabled='t' AND name='${quote_pgsql:$domain}'),' + ') || '"' as a
SMTP_NONRAND_DOMAINS = pgsql;SELECT name FROM mtasettings WHERE name='${quote_pgsql:$domain}' \
AND delivery_mode=2 AND protocol=1;
SMTP_RAND_DOMAINS = pgsql;SELECT name FROM mtasettings WHERE name='${quote_pgsql:$domain}' \
AND delivery_mode=1 AND protocol=1;
LMTP_NONRAND_DOMAINS = pgsql;SELECT name FROM mtasettings WHERE name='${quote_pgsql:$domain}' \
AND protocol=2 AND delivery_mode=2;
LMTP_RAND_DOMAINS = pgsql;SELECT name FROM mtasettings WHERE name='${quote_pgsql:$domain}' \
AND protocol=2 AND delivery_mode=1;
SMTP_SQL_DOMAINS = pgsql;SELECT name FROM mtasettings WHERE name='${quote_pgsql:$domain}' \
AND protocol=1;
LMTP_SQL_DOMAINS = pgsql;SELECT name FROM mtasettings WHERE name='${quote_pgsql:$domain}' \
AND protocol=2;
LDAP_DOMAINS = pgsql;SELECT name FROM mtasettings WHERE name='${quote_pgsql:$domain}' \
AND ldap_callout='t';
SMTP_CALLBACK_DOMAINS = pgsql;SELECT name FROM mtasettings where name='${quote_pgsql:$domain}' \
AND smtp_callout='t';
RELAY_SQL_DOMAINS = pgsql;SELECT name FROM relaydomains WHERE name='${quote_pgsql:$domain}';
WHITELISTED_DOMAINS = pgsql;SELECT from_address FROM lists WHERE to_address='any' AND list_type=1 AND from_address='${quote_pgsql:$sender_address_domain}';
BLACKLISTED_DOMAINS = pgsql;SELECT from_address FROM lists WHERE to_address='any' AND list_type=2 AND from_address='${quote_pgsql:$sender_address_domain}';
WHITELISTED_ADDRESS = pgsql;SELECT from_address FROM lists WHERE to_address='any' AND list_type=1 AND from_address='${quote_pgsql:$sender_address}';
BLACKLISTED_ADDRESS = pgsql;SELECT from_address from lists WHERE to_address='any' AND list_type=2 AND from_address='${quote_pgsql:$sender_address}';
WHITELISTED_HOSTS = pgsql;SELECT from_address FROM lists WHERE to_address='any' AND list_type=1 AND from_address='${quote_pgsql:$sender_host_address}';
BLACKLISTED_HOSTS = pgsql;SELECT from_address FROM lists WHERE to_address='any' AND list_type=2 AND from_address='${quote_pgsql:$sender_host_address}';
RELAY_SQL_HOSTS = pgsql;SELECT address FROM relaysettings WHERE enabled='t' AND address='${quote_pgsql:$sender_host_address}';
PGSQL_SERVERS = (/tmp/.s.PGSQL.5432)/baruwa/baruwa/password
SPF_MSG = Please see http://www.openspf.org/Why?scope=${if def:sender_address_domain {mfrom}{helo}};identity=${if def:sender_address_domain {$sender_address}{$sender_helo_name}};ip=$sender_host_address
LDAP_LOOKUP = ${lookup pgsql {SELECT url FROM ldaplookup, ldapmaps WHERE ldaplookup.name=ldapmaps.parent AND ldapmaps.name='${quote_pgsql:$domain}'}}
DELIVERY_QUERY = ${lookup pgsql {INSERT INTO messagestatus (messageid, hostname, ipaddress, port, confirmation) \
VALUES('${quote_pgsql:$message_exim_id}', '${quote_pgsql:$tpda_delivery_fqdn}', '${quote_pgsql:$tpda_delivery_ip}', \
${quote_pgsql:$tpda_delivery_port}, '${quote_pgsql:$tpda_delivery_confirmation}')}}
DEFER_QUERY = ${lookup pgsql {INSERT INTO messagestatus (messageid, hostname, ipaddress, port, confirmation, errorno, errorstr) \
VALUES('${quote_pgsql:$message_exim_id}', '${quote_pgsql:$tpda_delivery_fqdn}', '${quote_pgsql:$tpda_delivery_ip}', \
${quote_pgsql:$tpda_delivery_port}, '${quote_pgsql:$tpda_delivery_confirmation}', ${quote_pgsql:$tpda_defer_errno}, \
'${quote_pgsql:$tpda_defer_errstr}')}}
DKIM_STATUS = ${lookup pgsql {SELECT name FROM maildomains,dkim_keys WHERE maildomains.id = dkim_keys.domain_id AND dkim_keys.enabled='t'}{yes}}
PASSWD_CHECK_LOGIN = SELECT password FROM users WHERE username='${quote_pgsql:$auth1}'
PASSWD_CHECK_PLAIN = SELECT password FROM users WHERE username='${quote_pgsql:$auth2}'
ORG_CHECK_LOGIN = SELECT password FROM relaysettings WHERE username='${quote_pgsql:$auth1}'
ORG_CHECK_PLAIN = SELECT password FROM relaysettings WHERE username='${quote_pgsql:$auth2}'
OPENSSL_CIPHERS = NONE:+VERS-TLS-ALL:+ARCFOUR-128:+RSA:+SHA256:+SHA1:+COMP-NULL
GNUTLS_CIPHERS = TLSv1.2+HIGH : TLSv1+HIGH : !SSLv2 : RC4+MEDIUM : !aNULL : !eNULL : !3DES : !MD5 : !PSK : !KRB5 : @STRENGTH
