I think the error msg mean, there are too many acct request that can be served by your server at that instance of time.
if the sql socket is gone or disconnect, you shall see other error msg. eg: "Ignoring unconnected handle" or if it happen to rotate to the end of socket list and fail to get a free socket: "There are no DB handles to use!" May be can try to increase num_sql_socks. I am looking at ways to further fine tuning the operation of the mysql portion. Does anyone do any large scale deploy which store accounting at mysql? Can share out your configuration? On Sat, 10 Aug 2002, Aleksandr Kuzminsky wrote: > Date: Sat, 10 Aug 2002 18:29:37 +0300 (EEST) > From: Aleksandr Kuzminsky <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Subject: Re: Error: rlm_sql: All sockets are being used! Stupid? > > On Wed, 7 Aug 2002, Alan DeKok wrote: > > > Date: Wed, 07 Aug 2002 11:42:44 -0400 > > From: Alan DeKok <[EMAIL PROTECTED]> > > Reply-To: [EMAIL PROTECTED] > > To: [EMAIL PROTECTED] > > Subject: Re: Error: rlm_sql: All sockets are being used! Stupid? > > > > [EMAIL PROTECTED] wrote: > > > We have a Problem with using the MySQL Socket: > > > > > > num_sql_socks = 25 > > > is set in sql.conf > > > > > > and radius.log contains several messages like: > > > Error: rlm_sql: All sockets are being used! Please increase the maximum > > > number of sockets! > > > > This is probably because the SQL queries are taking a long time to > > return. See the list archives for details. > > Also it happens when mysql disconnects some sockets due to wait_timeout. > > --- > Aleksandr Kuzminsky, AK476-RIPE > System Administrator, AK16-UANIC > ISP NBI. > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > -- Cheers, CM. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
