this is the output of the debug mode...
rlm_sql_mysql: MYSQL check_error: 1062 received rlm_sql: Couldn't insert SQL accounting STOP record - Duplicate entry '2336002' for key 1 rlm_sql (sql): Released sql socket id: 3 modcall[accounting]: module "sql" returns fail modcall: group accounting returns failCC CC> Hi to all, CC> we use freeradius 0.9 running on a linux box. CC> After a system crash (the one with the mysql database) we have problem CC> with the accounting. When we start the raedius it connects on the CC> database but we have no record and in the log file we have always CC> these errors: CC> Error: rlm_sql (sql): Couldn't update SQL accounting for CC> START packet - Duplicate entry '2336002' CC> Error: rlm_sql: Couldn't insert SQL accounting STOP record - CC> Duplicate entry '2336002' for key 1 CC> Can someone help? CC> Costas A. Christonis CC> Networking & Communications Centre CC> Gallos Campus - University of Crete CC> email: [EMAIL PROTECTED] CC> http://www.ucnet.uoc.gr/ CC> - CC> List info/subscribe/unsubscribe? See CC> http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
