Hi,
I am using freeradius-0.5 and mysql 3.23.49.
I tried to setup 2 accounting server for a radius server, ie:
radius server A will always write accounting to mysql server B.
when mysql server B down, radius server A should send accounting to its
local mysql server.
In my radiusd.conf :
accounting {
acct_unique
attr_rewrite
detail
sql1 {
fail = 1
notfound = 2
noop = return
ok = return
updated = return
reject = return
userlock = return
invalid = return
handled = return
}
sql2 {
fail = 1
notfound = 2
noop = return
ok = return
updated = return
reject = return
userlock = return
invalid = return
handled = return
}
}
I defined my sql1 and sql2 in the sql.conf as:
sql1 => mysql server B
sql2 => mysql server running at localhost.
However, the failover didn't work when mysql server B down. Radius server
didn't send accounting to the local mysql server.
below is the error mesg I see when running the radius server in debug
mode:
rlm_sql: Reserving sql socket id: 4
rlm_sql: Couldn't update SQL accounting for START packet - Lost connection
to MySQL server during query
rlm_sql: Couldn't update SQLaccounting START record - MySQL server has
gone away
rlm_sql: Released sql socket id: 4
It failed even I use the redundant{} block in the radiusd.conf
Can anyone kindly enlighten me?
thx.
--
Cheers,
CM.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
