help-gnu-radius
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Help-gnu-radius] Problem with too many SQL connections


From: Norman Schmidt Jr
Subject: [Help-gnu-radius] Problem with too many SQL connections
Date: Wed, 18 Jun 2003 15:18:27 -0300
User-agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; pt-BR; rv:1.0.1) Gecko/20020823 Netscape/7.0

Hello!
I'm using 0.96.3 and getting plenty of "too many SQL connections open" errors on radius.log. I'm using MySQL 3.23.51, and I have already raised some MySQL parameters (max_connections to 500 and max_delayed_threads to 100) trying to get rid of this, but with no success, the errors are still ocurring. Any tips on this? Slow hardware? The setup is running in a Dell Poweredge 600, Celeron Coppermine 1.1 Ghz with 512Mb RAM. This machine runs only GNURadius 0.96.3 and MySQL 3.23.51. Only Radius accounting is going to MySQL, authentication is still done from Linux password file. There's about 3200 accounts in the password file, and this machine authenticates about 4000-7000 logins a day.
Following is a snip of the radius.log.
Regards,
Norman

Jun 18 14:27:00: Acct.crit: can't create new ACCT SQL connection: too many connections open Jun 18 14:28:28: Main.crit: can't create new ACCT SQL connection: too many connections open Jun 18 14:28:28: Acct.crit: can't create new ACCT SQL connection: too many connections open Jun 18 14:28:32: Main.crit: can't create new ACCT SQL connection: too many connections open Jun 18 14:28:32: Acct.crit: can't create new ACCT SQL connection: too many connections open






reply via email to

[Prev in Thread] Current Thread [Next in Thread]