no DB handles

[Lucas Aimaretto]

> > > 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