I'm trying to get authentication working with multiple mysql databases,
where the primary database is shutdown.
In my configs ala the configuration_failover doc:
$INCLUDE ${confdir}/sql.conf
$INCLUDE ${confdir}/sql2.conf
authorize {
preprocess
suffix
redundant {
sql1
sql2
}
files
}
authenticate {
authtype SQL {
redundant {
sql1
sql2
}
}
}
accounting {
detail
sql1
radutmp
}
So there is no redundancy for accounting.
When running in debug mode I get:
rlm_sql: Trying to (re)connect an unconnected handle...
rlm_sql: Couldn't connect socket to MySQL server radius@sql:radius_data
rlm_sql: Mysql error 'Can't connect to MySQL server on 'sql' (111)'
rlm_sql: Failed to connect DB handle #4
rlm_sql: Ignoring unconnected handle
rlm_sql: Ignoring unconnected handle
rlm_sql: Ignoring unconnected handle
rlm_sql: Ignoring unconnected handle
rlm_sql: Ignoring unconnected handle
rlm_sql: There are no DB handles to use!
So it seems like it's not failing over to the secondary sql server. Does
the failover code work for when it can't connect to one of the databases, or
only if it doesn't get the correct response?
Note, if I comment out the sql1 lines, everything works, it authenticates
off of the secondary sql.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
