Accounting to db, duplicate entries (again)
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.
More information about the Freeradius-Users