Am 25.03.2011 12:19, schrieb Wietse Venema: > Peter S?rensen: >> I am fully aware that postfix supports mysql. The reason is actually a >> performance issue >> concerning the mysql backend so you might see this as a temporary workaround >> for >> the mysql problems. > > Use proxymap. > > Replace "mysql:/file/name" by "proxy:mysql:/file/name". > > http://www.postfix.org/proxymap.8.html
interesting!
is there anything that speaks gainst using proxy:mysql for all
mysql-configurations like below, seems to work on my local workstation
as expected but better a question too much instead hit a pitfall
AFAIK this could reduce mysql-connections and should not degrase performance
nor fetch outdated results if i understand the docs correct
___________________________________
proxy_read_maps = proxy:mysql:/etc/postfix/mysql-mynetworks.cf
proxy:mysql:/etc/postfix/mysql-spamfilter.cf
proxy:mysql:/etc/postfix/mysql-mydestination.cf
proxy:mysql:/etc/postfix/mysql-recipients.cf
proxy:mysql:/etc/postfix/mysql-rewritedomains.cf
proxy:mysql:/etc/postfix/mysql-rewritesenders.cf
proxy:mysql:/etc/postfix/mysql-transport.cf
proxy:mysql:/etc/postfix/mysql-sender_relay_hosts.cf
proxy:mysql:/etc/postfix/mysql-sender_relay_hosts_auth.cf
proxy:mysql:/etc/postfix/mysql-aliases.cf
proxy:mysql:/etc/postfix/mysql-senderaccess.cf
mynetworks = 127.0.0.0/8,
proxy:mysql:/etc/postfix/mysql-mynetworks.cf
mydestination =
proxy:mysql:/etc/postfix/mysql-mydestination.cf
local_recipient_maps = proxy:mysql:/etc/postfix/mysql-recipients.cf
recipient_canonical_maps =
proxy:mysql:/etc/postfix/mysql-rewritedomains.cf
sender_canonical_maps =
proxy:mysql:/etc/postfix/mysql-rewritesenders.cf
transport_maps = proxy:mysql:/etc/postfix/mysql-transport.cf
sender_dependent_relayhost_maps =
proxy:mysql:/etc/postfix/mysql-sender_relay_hosts.cf
smtp_sasl_password_maps =
proxy:mysql:/etc/postfix/mysql-sender_relay_hosts_auth.cf
alias_maps = proxy:mysql:/etc/postfix/mysql-aliases.cf
smtpd_sender_login_maps = proxy:mysql:/etc/postfix/mysql-senderaccess.cf
smtpd_recipient_restrictions = permit_mynetworks
reject_non_fqdn_recipient
reject_non_fqdn_sender
reject_unlisted_sender
reject_authenticated_sender_login_mismatch
permit_sasl_authenticated
reject_unknown_sender_domain
reject_unknown_recipient_domain
reject_unauth_destination
reject_invalid_hostname
reject_unauth_pipelining
check_recipient_access
proxy:mysql:/etc/postfix/mysql-spamfilter.cf
signature.asc
Description: OpenPGP digital signature
