rlm_sql Error

Iliya Peregoudov iperegudov at cboss.ru
Tue Aug 14 14:11:59 CEST 2012


Hello Antonio,

rlm_sql does not wait for connection from connection pool to become 
available. If all connections are busy the module just return fail.

You can avoid these spurious failures if you set num_sql_socks equal to 
max_servers.

Antonio Modesto wrote:
> 
> Hi,
> 
> 
> Here in the ISP which I work we have a Freeradius 1.X in production, and 
> a 2.X that we're testing to replace the old one. On both Radius we get 
> the following error sometimes, What can be causing this? The SQL 
> Database is in the same server of freeradius 1.X, but the load is low, 
> we have about 2500 subscribers. I was thinking about increasing the 
> number of sql connections, which is set to 4, would it make any difference?
> 
> Database server load:
> load averages:  1.10,  1.05,  1.03
> 
> 
> Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried 
> to connect 0
> 
> 
> Thanks in advance.
> 
> 
> ------------------------------------------------------------------------
> 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html



More information about the Freeradius-Users mailing list