Accounting to db, duplicate entries (again)

Alan DeKok aland at ox.org
Tue Aug 2 23:10:45 CEST 2005


Roger Kristiansen <roger.kristiansen at cc.uit.no> wrote:
> I'm not at all experienced with databases, but I was thinking I could 
> lock the accounting table while inserting the Start message, so that the 
> query in pnt. 2 could not be performed until the Insert in pnt. 1 is 
> finished. Wouldn't this elminate the problem in pnt. 3?

  It would slow the server down considerably.

  If you're willing to wait for SQL updates, you can use "rlm_sql_log"
in the CVS head.  It avoids these issues by post-processing the logs,
and not running the SQL statements in a live server.

  Alan DeKok.




More information about the Freeradius-Users mailing list