rlm_sql_log. accounting and locking

Alan DeKok aland at deployingradius.com
Fri Dec 7 17:24:16 CET 2007


Phil Mayers wrote:
> The rlm_sql_log module only logs a single query; unlike the main sql
> module which (for accounting) will do an update or insert if not found.

  It's difficult to do that without interacting directly with the DB.

  Using the 'detail" file and radrelay functionality may be safer.

> How, if at all, are people merging the rows? Triggers? Post-processing?
> 
> Also, I doubt it will be an issue, but just wanted to check; is the
> flock() of the file likely to cause any contention issues? Is there an
> easy way of hashing the NAS-IP-Address to writing to 26 files named
> "sql-log-[a-z]" and asking radsqlrelay to replay them all?

  No idea...

  Alan DeKok.



More information about the Freeradius-Users mailing list