Antonio Fernández Pérez wrote:
I contact with you because we are checking log file of FreeRADIUS and we are encountering a lot of messages of "Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0".
Fix your database.
I have read in the forum and it is caused because database is broken but, are there any option to adjust in FreeRADIUS server to optimize db handlers? We have 12 sockets configured, we have adjust max_request to 3072 ( ...
No. Fix the database so that it responds to queries. There's nothing you can do to FreeRADIUS to make the DB run faster.
In our environment we are creating a lots of users in radcheck table. Could help us to execute an OPTIMIZE over radcheck table? (It's not common but in some cases users are removed)
Any suggestion?
Fix the database. Check indexes, get rid of unused rows, etc. Alan DeKok.