> > > I've seen many of these messages in the radius.log ... > > > > > > Wed Jun 15 15:10:23 2005 : Info: rlm_sql (sql): There are no > > > DB handles to use! skipped 0, tried to connect 0 > > > > > > > > > What does it mean ? How to solve this ? > > > Hi, > > > > increase the number of connections to the mysql db in your > sql.conf ! > > > > # number of sql connections to make to server > > num_sql_socks = 15 > > > > Regards, > > > > Edvin Seferovic > > Hi Edvin, > > Thanx ... that seems to be fine. I increased the number of > scokets to 10 ( not 15 as suggested, I'll be checking ... ), > but I had no more of those messages by now ...
Well ... you know that it did not change that much. I saw some messages again. So I increased to 15 socks but I also got that messages in the radius.log The rare thing is that I have lots of them ... look ... Wed Jun 15 17:37:45 2005 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Wed Jun 15 17:37:45 2005 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Wed Jun 15 17:37:47 2005 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Wed Jun 15 17:37:48 2005 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Wed Jun 15 17:37:49 2005 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Wed Jun 15 17:37:49 2005 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Wed Jun 15 17:37:49 2005 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Wed Jun 15 17:37:49 2005 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Wed Jun 15 17:37:50 2005 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Wed Jun 15 17:37:50 2005 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Wed Jun 15 17:37:52 2005 : Error: WARNING: Unresponsive child (id 2051) for request 2 Wed Jun 15 17:37:52 2005 : Error: WARNING: Unresponsive child (id 5126) for request 0 Wed Jun 15 17:37:52 2005 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Wed Jun 15 17:37:52 2005 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Wed Jun 15 17:37:52 2005 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Wed Jun 15 17:37:53 2005 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Wed Jun 15 17:37:54 2005 : Error: WARNING: Unresponsive child (id 9226) for request 17 Wed Jun 15 17:37:54 2005 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Wed Jun 15 17:37:54 2005 : Error: WARNING: Unresponsive child (id 10251) for request 18 Wed Jun 15 17:37:54 2005 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Wed Jun 15 17:37:54 2005 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Wed Jun 15 17:37:54 2005 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Wed Jun 15 17:37:54 2005 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Wed Jun 15 17:37:54 2005 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Wed Jun 15 17:37:54 2005 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 I only 9 seconds, 21 messages of this kind. And .. .do the "unresponsive child" have something to do ... ??? Any hint ? I have same radius on other PC with pretty much the same conf and I have not got this errors ... I thought about the sql server ( MSSQL Server ) but the cpu usage has nice level ( 10% most of time, with rare peaks of 80% ). I have not a clue ... Any help or idea or expreience would be really apreciated. Best regards, Lucas -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.3/15 - Release Date: 14/06/2005 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
