This is a log exerp from a server using freeradius 0.7 authenticating
against mysql .. does anyone have a pointer for where I should start digging?
It seems to happen when the database is doing a hot-backup and is
unresponsive/slow for a few (10-15) minutes.
The 'useful' options from sql.conf should be:
connect_failure_retry_delay = 15
num_sql_socks = 18
sqltrace = yes
sqltracefile = ${logdir}/sqltrace.sql
sql_user_name = "%{Stripped-User-Name:-%{User-Name:-none}}"
# Uncomment simul_count_query to enable simultaneous use checking
simul_count_query = "SELECT COUNT(*) FROM ${acct_table1} WHERE UserName=...
simul_verify_query = "SELECT RadAcctId, AcctSessionId, UserName, NASIPAd...
simul_zap_query = "DELETE FROM ${acct_table1} WHERE RadAcctId = '%s'"
Mon Aug 19 00:16:15 2002 : Error: WARNING: Unresponsive child (id 55299) for
request 4861
Mon Aug 19 00:16:18 2002 : Error: WARNING: Unresponsive child (id 53252) for
request 4862
Mon Aug 19 00:16:18 2002 : Error: WARNING: Unresponsive child (id 54274) for
request 4863
Mon Aug 19 00:16:21 2002 : Error: WARNING: Unresponsive child (id 56325) for
request 4864
Mon Aug 19 00:16:21 2002 : Error: WARNING: Unresponsive child (id 57350) for
request 4865
Mon Aug 19 00:16:41 2002 : Error: WARNING: Unresponsive child (id 59400) for
request 4867
Mon Aug 19 00:16:41 2002 : Error: WARNING: Unresponsive child (id 60425) for
request 4868
Mon Aug 19 00:16:41 2002 : Error: WARNING: Unresponsive child (id 61450) for
request 4869
Mon Aug 19 00:16:41 2002 : Error: WARNING: Unresponsive child (id 62475) for
request 4870
Mon Aug 19 00:16:41 2002 : Error: WARNING: Unresponsive child (id 63500) for
request 4871
Mon Aug 19 00:16:41 2002 : Error: WARNING: Unresponsive child (id 58375) for
request 4866
Mon Aug 19 00:16:44 2002 : Error: rlm_sql: There are no DB handles to use!
Mon Aug 19 00:16:44 2002 : Error: WARNING: Unresponsive child (id 64525) for
request 4872
Mon Aug 19 00:16:47 2002 : Error: WARNING: Unresponsive child (id 65550) for
request 4873
Mon Aug 19 00:16:47 2002 : Error: rlm_sql: There are no DB handles to use!
Mon Aug 19 00:17:37 2002 : Error: CHILD: exit on signal (11)
Mon Aug 19 06:38:43 2002 : Info: rlm_sql: Driver rlm_sql_mysql loaded and
linked
Mon Aug 19 06:38:43 2002 : Info: rlm_sql: Attempting to connect to
<dbuser>@<dbserver>:/<db>
Mon Aug 19 06:38:43 2002 : Info: rlm_sql: Starting connect to MySQL server
for #0
--
Todd Fries .. [EMAIL PROTECTED]
Monte R. Lee and Company
Work 405-842-2405
Fax 405-848-8018
Web www.mrleng.com
$ToddFries: signature.w,v 1.5 2002/05/23 19:48:19 todd Exp $
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
