DB hundler, a big problem to me

[Alan DeKok]

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.