v3 and rlm_sql_log/radsqlrelay
Artis Caune
artis.caune at gmail.com
Tue Sep 3 01:46:41 CEST 2019
Looking at replacing sql_log from v1
Module has been removed in v3 but 3.0.19 still ships with radsqlrelay.
radsqlreplay(8) still refers to rlm_sql_log
I tried this and it works:
sql sql_auth_log {
driver = "rlm_sql_null"
post-auth {
logfile = "${logdir}/auth_log.sql"
query = "INSERT INTO authlog ..."
}
}
and: radsqlrelay -x -d mysql ... /var/log/freeradius/auth_log.sql
Just wondering if there are better ways of doing this as looks like
radsqlrelay might not be supported anymore ?
Inserting during auth is not an option as it slows down server and master
might not be available for regional nodes.
Another option might be to proxy auth logs as radius packets (buffered) to
central radius server which will insert all requests whenever db is ready.
Thanks,
Artis
More information about the Freeradius-Users
mailing list