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