I have had configurable failover working since freeradius5.0.
We recently upgraded to 8.0. Sadly I never tested failing over with 8.0.
Of course our primary sql server died, and free radius was no longer able to
authenticate.
I have upgraded to 8.1 in my development environment. 8.1 seems to have
partially fixed the problem. I can now authenticate after taking down the
primary sql server, but only for a shortwhile. I start getting:
Error: rlm_sql (sql1): There are no DB handles to use!
errors in the logs after a couple minutes and am no longer able to
authenticate.
When running in debug mode, I get lots of these errors:
rlm_sql (sql1): Ignoring unconnected handle
Here are a partial listing of my configs.
sql1.conf and sql2.conf have:
num_sql_socks = 20
connect_failure_retry_delay = 30
And radiusd.conf is setup as follows:
authorize {
preprocess
suffix
group {
sql1 {
fail = 1
notfound = return
noop = 2
ok = return
updated = 3
reject = return
userlock = 4
invalid = 5
handled = 6
}
sql2 {
fail = 1
notfound = return
noop = 2
ok = return
updated = 3
reject = return
userlock = 4
invalid = 5
handled = 6
}
}
dailycounter
monthlycounter
files
mschap
}
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
