I've already used the proxymap solution. We ran into serious problems with the clustered mysql backend. I have 5 servers with smtd set to max 300.
I will get back to the proxymap solution. I have adjusted some settings in the mysql backend. But still - this annoys me. What is triggering postfix to make this behavior? Regards Peter ________________________________________ Fra: owner-postfix-us...@postfix.org [owner-postfix-us...@postfix.org] På vegne af Reindl Harald [h.rei...@thelounge.net] Sendt: 25. marts 2011 13:02 Til: postfix-users@postfix.org Emne: Re: SV: postfix restarts every five minute 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
