Redundant waits for minutes to failover

Stefan A. a.freeradius at premit.de
Mon Aug 11 02:02:40 CEST 2008


All,

I'm using 'redundant' to failover from SQL to Filebased Authentication

At the time, my MySQL Server is gone, FR is waiting for minutes to go on to
the next step...

++- entering policy redundant
        expand: %{User-Name} -> fred
rlm_sql (sql_access-1): sql_set_user escaped user --> fred
rlm_sql (sql_access-1): Reserving sql socket id: 4
        expand: SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE
UserName = '%{SQL-User-Name}' and VolumeBucket = '%{VolumeBucket}' ORDER BY
id -> SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE UserName =
'fred' ORDER BY id
rlm_sql_mysql: query:  SELECT id,UserName,Attribute,Value,op FROM radcheck
WHERE UserName = 'fred' ORDER BY id
rlm_sql_mysql: MYSQL check_error: 2006, returning SQL_DOWN
rlm_sql (sql_access-1): Attempting to connect rlm_sql_mysql #4
rlm_sql_mysql: Starting connect to MySQL server for #4
rlm_sql_mysql: Couldn't connect socket to MySQL server
radiususer at db-access-1:acctopus_te
rlm_sql_mysql: Mysql error 'Can't connect to MySQL server on 'db-access-1'
(146)'
rlm_sql (sql_access-1): Failed to connect DB handle #4
rlm_sql (sql_access-1): reconnect failed, database down?
rlm_sql_getvpdata: database query error
rlm_sql (sql_access-1): SQL query error; rejecting user
rlm_sql (sql_access-1): Released sql socket id: 4
+++[sql_access-1] returns fail
        expand: %{User-Name} -> fred
rlm_sql (sql_access-2): sql_set_user escaped user --> 'fred'
rlm_sql (sql_access-2): Trying to (re)connect unconnected handle 4..
rlm_sql (sql_access-2): Attempting to connect rlm_sql_mysql #4
rlm_sql_mysql: Starting connect to MySQL server for #4


'db-acceees-1' is the hostname from hosts file, it is the machine itselv
'db-acceees-2' is the hostname from hosts file, it is the other machine,
containing a replik... If up


Accounting went throug the redeundant directly into the file... Without
waisting time.


I have configured:
For access:

	redundant { 
		sql_access-1
		sql_access-2
		ok 
	} 
	files


For Accounting:

	redundant {
		sql_accounting
		detail
	}

Are there any reconnect options beside
	connect_failure_retry_delay = 60
?






Thaks Stefan





More information about the Freeradius-Users mailing list