> > I gave you hint's on this very list two days ago ... > > Best regards > Gerald > > Yes but I have proxy_read_maps in main.cf:
proxy_read_maps = $canonical_maps $lmtp_generic_maps $local_recipient_maps $mydestination $mynetworks $recipient_bcc_maps $recipient_canonical_maps $relay_domains $relay_recipient_maps $relocated_maps $sender_bcc_maps $sender_canonical_maps $smtp_generic_maps $smtpd_sender_login_maps $transport_maps $virtual_alias_domains $virtual_alias_maps $virtual_mailbox_domains $virtual_mailbox_maps $smtpd_sender_restrictions $sender_dependent_relayhost_maps And use: virtual_mailbox_domains = proxy:mysql:/etc/postfix/map.sql In http://postfix.1071664.n5.nabble.com/postfix-with-mysql-too-many-connections-td81836.html Mr Wietse say: "> As workaround I used now proxymap and the problems are solved: This is not a workaround. Sharing connections is the recommended configuration. > But I think it would be a better way, if postfix could close the mysql > connections immediately after receiving the data and not hold opened > until the mail is fully delivered. Doing a connect+close for every query would reduce performance on a high-volume server." In my postfix proxymap may not be working very well: warning: virtual_mailbox_domains: proxy:mysql:/etc/postfix/map.sql: table lookup problem warning: memcache:/etc/postfix/memcache_recipient_whitelist_cache.cf: table lookup problem because in mysql i see many hanging processes >> check_recipient_access mysql:/etc/postfix/mysql_whitelist_recipient.cf >> ... >> "Dec 2 13:51:09 mail4 postfix/smtpd[21777]: warning: connect to mysql >> server 127.0.0.1: Too many connections > > try http://www.postfix.org/proxymap.8.html > > check_recipient_access > proxy:mysql:/etc/postfix/mysql_whitelist_recipient.cf > > proxy_read_maps = ... > proxy:mysql:/etc/postfix/mysql_whitelist_recipient.cf --
