Re: no DB handles

2007-10-25 Thread Doc. Caliban
Alan DeKok wrote: What does the full debug log say? Sadly, I've joined this mailing list to ask this question, and ultimately show what an armature I am. I just found out that mysql is only listening to localhost. That's all it's ever been used for. D'oh! (I did not know that was a def

Re: no DB handles

2007-10-25 Thread Alan DeKok
Doc. Caliban wrote: > When I try an authentication test, I receive the "no DB handles" error. What does the full debug log say? Odds are that the DB connection parameters are wrong, and the server cannot open the DB. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.

RE: no DB handles

2007-10-25 Thread Doc. Caliban
Hello, I have a clean install of FreeRadius 1.1.7 with MySQL support. I have a database on a separate machine that is used for almost nothing (no traffic). I would think sockets are not an issue. I set the radius database up based on the instructions on this page: http://wiki.freeradius.o

Re: no DB handles ,How to solve this ?

2006-12-21 Thread Pshem Kowalczyk
On 12/21/06, 梁增辉 <[EMAIL PROTECTED]> wrote: hi all hi, I've seen many of these messages in the radius.log (I am using freeradius 1.1.1 mysql version :5.1.11) There are no DB handles to use! skipped 0, tried to connect 0 There are no DB handle

RE: no DB handles

2005-06-16 Thread Lucas Aimaretto
> > > > Ok, but ... my sql server is a Pentium IV with 512MB of > > > > RAM. How can it be possible ?! > Are the attributes you are doing searches with indexed? Mmmm, interesting. I looked and there was no index created for those attributes. I created the index and reindexed the database and it

RE: no DB handles

2005-06-16 Thread Dustin Doris
On Thu, 16 Jun 2005, Lucas Aimaretto wrote: > > > Ok, but ... my sql server is a Pentium IV with 512MB of > > > RAM. How can it be possible ?! > > > > Go figure it out. I don't run your SQL server, so > > I don't know. > > I know you are not running my SQL server. I was just asking because so

RE: no DB handles

2005-06-16 Thread Lucas Aimaretto
> > Ok, but ... my sql server is a Pentium IV with 512MB of > > RAM. How can it be possible ?! > > Go figure it out. I don't run your SQL server, so > I don't know. I know you are not running my SQL server. I was just asking because some may have some idea of what to "touch" to improve the

Re: no DB handles

2005-06-16 Thread Alan DeKok
"Lucas Aimaretto" <[EMAIL PROTECTED]> wrote: > Ok, but ... my sql server is a Pentium IV with 512MB of RAM. How can it > be possible ?! Go figure it out. I don't run your SQL server, so I don't know. > I increased the number to socks to 15 ... but it seems it is not the > solution ... any hi

RE: no DB handles

2005-06-16 Thread Lucas Aimaretto
> > I only 9 seconds, 21 messages of this kind. And .. .do the > > "unresponsive child" have something to do ... ??? > > Yes. Your database is slow, and is not responding to > FreeRADIUS in time. Ok, but ... my sql server is a Pentium IV with 512MB of RAM. How can it be possible ?! Besides,

Re: no DB handles

2005-06-15 Thread Alan DeKok
"Lucas Aimaretto" <[EMAIL PROTECTED]> wrote: > I only 9 seconds, 21 messages of this kind. And .. .do the "unresponsive > child" have something to do ... ??? Yes. Your database is slow, and is not responding to FreeRADIUS in time. Alan DeKok. - List info/subscribe/unsubscribe? See http://ww

RE: no DB handles

2005-06-15 Thread 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 connectio

RE: no DB handles

2005-06-15 Thread 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

RE: no DB handles

2005-06-15 Thread Seferovic Edvin
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 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lucas Aimaretto Sent: Mittwoch,