DB hundler, a big problem to me
aland at deployingradius.com
Tue Jul 30 17:29:01 CEST 2013
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.
More information about the Freeradius-Users