Files
mail-hosting/etc_clearnet_proxy/postfix/sql/mysql_tls_policy_out.cf

6 lines
343 B
CFEngine3

user = postfix_readonly
password = YOUR_PASSWORD
hosts = 127.0.0.1
dbname = postfix
query = SELECT IF(EXISTS(SELECT 'encrypt' FROM mailbox WHERE username=CONCAT('%u', '@', COALESCE((SELECT target_domain FROM alias_domain WHERE alias_domain = '%d' AND active='1'), '%d')) AND active = 1 AND enforce_tls_out = 1), 'smtp_enforced_tls:', 'smtp:')