rlm_sql Error

[alan buxey]

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

load is > 1.0 which actually means the server is busy. its 'above normal' - certainly
not 'low'.


In the first instance , I would suggest that you increase number of connections to the 
SQL to at least 10.  secondly, add some indexes to the tables - find what your queries
are and then use 'explain' to check that those queries are using nice index values
and not having to trawl through all records for each query. finally update the database engine
to InnoDB rather than the defauly MyISAM. 

that will improve things

alan