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
[EMAIL PROTECTED]: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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
