It's possible create a failover for account? example: If user exist in first DB continue, but if don't exist, try to another DB?
I try use this, but not work. Any ideas?
authorize {
redundant {
sql1
sql2
}
}and too:
authorize {
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
}
}but not work...
debug with radiusd -X:
rlm_sql (sql1): sql_set_user escaped user --> 'teste'
radius_xlat: 'SELECT id,rtrim(Username),rtrim(Attribute),rtrim(value),op FROM radcheck WHERE Username = 'teste' ORDER BY id'rlm_sql (sql1): Reserving sql socket id: 4
query: SELECT id,rtrim(Username),rtrim(Attribute),rtrim(value),op FROM radcheck WHERE Username = 'teste' ORDER BY id
rlm_sql (sql1): User teste not found in radcheck
radius_xlat: ''
radius_xlat: ''
rlm_sql (sql1): Released sql socket id: 4
modcall[authorize]: module "sql1" returns ok
modcall: group redundant returns ok
modcall: group authorize returns ok
rad_check_password: Found Auth-Type Local
auth: type Local
auth: No password configured for the user
auth: Failed to validate the user.
Regards.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
