too many connections

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

too many connections

natan
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

--

Reply | Threaded
Open this post in threaded view
|

Re: too many connections

Gerald Galster
> 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


Best regards
Gerald