Hi everybody, I have FreeRADIUS 2.1.10 in Debian 6. 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". 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 ( ... 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? Thanks in advance. Best regards, Antonio.
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.
Thanks for your reply Alan. When you say "fix the database" you want to say that I have to execute repair table? I have defined some indexes to increase the performance of the database and works fine. Can you help me please? Thanks in advance. Best regards, Antonio.
Antonio Fernández Pérez wrote:
Thanks for your reply Alan.
When you say "fix the database" you want to say that I have to execute repair table? I have defined some indexes to increase the performance of the database and works fine. Can you help me please?
It's a database problem. I'm not a database person. Alan DeKok.
participants (2)
-
Alan DeKok -
Antonio Fernández Pérez