Hello I put in mysql whitelist recipient domain. smtpd_recipient_restrictions = ... #whitelist recipient domain. check_recipient_access mysql:/etc/postfix/mysql_whitelist_recipient.cf ...
db: +------------------+-------+----------+ | domain | type | plugin | +------------------+-------+----------+ | domain.ltd | OK | NULL | +------------------+-------+----------+ query=SELECT type FROM spp_domain WHERE domain ='%s' I tested via postmap: "postmap -q domain.ltd mysql:/etc/postfix/mysql_whitelist_recipient.cf" and I get "OK" I check and i get info from log: "Dec 2 13:51:09 mail4 postfix/smtpd[21777]: warning: connect to mysql server 127.0.0.1: Too many connections Dec 2 13:51:09 mail4 postfix/smtpd[21777]: warning: mysql:/etc/postfix/mysql_whitelist_recipient.cf: table lookup problem" In database is 1086 records Problem is "Too many connections" to my local mysql I thinking about use memcache for test like: ---- backup = mysql:/etc/postfix/mysql_whitelist_recipient.cf ttl = 600 key_format = "vip:%s" ---- Is this solutions is ok ? I thinking about tunning extra mysql --
