Solved ....make sure RadAcctId Extras is set to auto_increment must have got lost in the scheme of things Thanks, self >You bet!!!!! ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 11, 2003 4:13 PM Subject: Couldn't insert SQL accounting STOP record
> Can someone/anyone tell me my mistake > accounting stop and start packets log into sql database just once then all > the other attempts return errors > Fri Jul 11 15:51:55 2003 : Info: Listening on IP address 192.168.0.254, > ports 1812/udp and 1813/udp, with proxy on 1814/udp.Fri Jul 11 15:51:55 2003 : Info: Ready to process requests. > Fri Jul 11 15:54:50 2003 : Error: rlm_sql: Couldn't insert SQL accounting > STOP record - Duplicate entry '0' for key 1Fri Jul 11 15:54:52 2003 : Error: rlm_sql: Couldn't insert SQL accounting > STOP record - Duplicate entry '0' for key 1Fri Jul 11 15:54:54 2003 : Error: rlm_sql: Couldn't insert SQL accounting > STOP record - Duplicate entry '0' for key 1Fri Jul 11 15:54:56 2003 : Error: rlm_sql: Couldn't insert SQL accounting > STOP record - Duplicate entry '0' for key 1Fri Jul 11 15:58:04 2003 : Auth: Login OK: [kuban/prc4398] (from client > private port 16 cli 304XXXXXXX)Fri Jul 11 15:58:05 2003 : Error: rlm_sql (sql): Couldn't update SQL > accounting for START packet - Duplicate entry '0' for key 1 > > > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
