Amir Tal wrote: > Adding unique key to the database results in the following being > returned from rlm_sql, > > What happen to accounting data when a duplicate entry is encountered?
It SHOULD run the normal query, followed by the "alt" query. > In addition, currently there is no scheduled clearing of the data in > radacct table, wont this increase in occurrence? Yes. Accounting is about storing data. If you want to delete data, it's one line of SQL. > [sql] Couldn't insert SQL accounting STOP record - Duplicate entry > 'c6d3d253355b3dcf' for key 2 > rlm_sql_mysql: MYSQL check_error: 1062 received > rlm_sql_mysql: Cannot store result > rlm_sql_mysql: MySQL error 'Duplicate entry 'c6d3d253355b3dcf' for key 2' OK... it SHOULD run the "alt" query here, to UPDATE the record. > WARNING: Child is hung for request 5763411 in component <core> module > <queue>. > WARNING: Child is hung for request 5763412 in component <core> module > <queue>. And that's a problem. Your SQL database is slow. Fix it. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html