that doesnt help anything...
i raised it to 500, with now sense.
it reaches is limit beacause mysql blocks.
i dont think that exim needs more than 250 mysql conns....
greetings,
Florian
> -----Original Message-----
> From: Lists [mailto:sfulton-lists@esoteric.ca]
> Sent: Thursday, April 22, 2004 9:05 PM
> To: Florian Schicker [Nessus Office]
> Subject: Re: [Exim] Exim MySQL Problems
>
>
> Florian Schicker [Nessus Office] wrote:
>
> Increase your max_connections, implement some inbound restrictions
> within Exim and you should be fine.
>
> -- Steve
>
> > Hi there!
> >
> > I have a strange problem with exim 4.32 and mysql 4.0.18.
> > Im running exim as manualrouter only to send throu and
> filter (spam, av,
> > dnsbl) for some domains.
> > On one domain i get some more mail traffic (ap. 10
> mails/sec) once per day
> > for about 1hour.
> >
> > Everytime this happens, exim takes one mysql connection per
> incoming mail
> > (normally i only have 1 conn)
> > and doesnt disconnect them after the selects (they keep in
> "sleep state" at
> > SHOW PROCESSLIST).
> > so, after some minutes mysql gets max_connections (250 in
> my case) and
> > blocks new connections.
> > i have to restart mysql and exim to "kill" the sleeping processes.
> >
> > the aftereffect is fatal, exim reaches it's max_connections
> limit too and
> > fails after that:
> >
> > 2004-04-22 19:02:46 SMTP connection from [194.25.134.82]
> (TCP/IP connection
> > count = 98)
> > 2004-04-22 19:02:46 SMTP connection from [194.25.134.20]
> (TCP/IP connection
> > count = 99)
> > 2004-04-22 19:02:47 SMTP connection from [194.25.134.82]
> (TCP/IP connection
> > count = 100)
> > 2004-04-22 19:02:47 Connection from 194.25.134.80 refused: too many
> > connections
> > 2004-04-22 19:02:47 Connection from 141.35.1.23 refused: too many
> > connections
> > 2004-04-22 19:02:47 Connection from 194.25.134.19 refused: too many
> > connections
> >
> > and so on.
> >
> > my exim conf: (mysql stuff)
> >
> > hide mysql_servers = localhost/db/user/password
> >
> > BLOCKEDDOMAINS = ${lookup mysql{SELECT blockeddomains FROM exim}}
> > WHITEDOMAINS = ${lookup mysql{SELECT whitedomains FROM exim}}
> > RELAY_TO_DOMAINS = ${lookup mysql{SELECT relaydomain FROM
> exim_hub where
> > relaydomain='$domain'}{$value}}
> > RELAY_FROM_HOSTS = ${lookup mysql{SELECT relay_from_hosts
> FROM exim}}
> >
> > smart_route:
> > driver = manualroute
> > domains = +relay_to_domains
> > transport = remote_smtp
> > condition = ${lookup mysql {select relaydomain from exim_hub \
> > where relaydomain='$domain'}{$value}}
> > route_list = * "${lookup mysql {select smarthost from exim_hub \
> > where relaydomain='$domain'}{$value}}"
> >
> > ------ snap -------
> >
> >
> > greetings,
> >
> > Florian Schicker
> >
> >
> > --
> >
> > ## List details at
> http://www.exim.org/mailman/listinfo/exim-users Exim details
> at http://www.exim.org/ ##
> >
>
