"Kevin W. Brown" <[EMAIL PROTECTED]> wrote:
> We're running FreeRADIUS 1.0.1 on a Solaris 9 x86 machine with MySQL  
> 3.23.55.  We've been trying to track down an issue we've been having 
> with slow auth responses, and we came across the following in our logs:
> 
> Tue Dec 28 12:56:14 2004 : Info: rlm_sql (sql): received Acct On/Off packet
> Tue Dec 28 12:56:28 2004 : Error: WARNING: Unresponsive child (id 137) 
> for request 4517

  Yup, that's a problem.

> Tue Dec 28 12:57:02 2004 : Info: rlm_sql (sql): There are no DB handles 
> to use! skipped 0, tried to connect 0

  The SQL server is slow.

  And since the SQL server is slow, all of the FreeRADIUS threads are
busy waiting for SQL to do it's job, and they therefore can't process
authentication requests.

> We are only using SQL to store accounting records.  FreeRADIUS is not 
> doing any lookups via MySQL.  Can anyone shed some light on what's 
> causing these errors?

  Your SQL tables are large, or not indexed.

  Alan DeKok.


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to