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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
