On Mon, 20 Oct 2003, Kenny Olano wrote: > I guess I should of read the sql.conf file before I posted this. Sorry about > that. Would there be any damage caused if I remove "accstoptime = 0" from > the sql clause? By damage I mean any time of database corruption or the > wrong records being updated.
Probably not as long as the acct-session-id (and probably acct-unique-id) fields are unique... > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf Of Kostas > > Kalevras > > Sent: Monday, October 20, 2003 10:27 AM > > To: Freeradius-Users > > Subject: Re: manually updating AcctStopTime > > > > > > On Mon, 20 Oct 2003, Kenny Olano wrote: > > > > > Hello > > > I am using freeradius 07.1 with mysql. I am working on > > script that will > > > update the AcctStopTime manually, But I have noticed that when > > that is done > > > and the radius server receives the accounting stop packets it > > doesn't update > > > the record but inserts an entire new record. Any way of stopping this? > > > > Have you read the sql.conf file? > > > > the accounting-stop query will do an 'update where acctstoptime = 0' > > If acctstoptime has been changed then the query will fail and the > > server will > > fall back to an insert > > > > > > > > Kenny Olano > > > Web Programmer > > > Practical Solutions > > > 1561 Virginia Avenue Suite 207A > > > College Park, GA 30337 > > > 404-762-5600 x103 > > > > > > > > > - > > > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > > > > -- > Kostas Kalevras Network Operations Center > [EMAIL PROTECTED] National Technical University of Athens, Greece > Work Phone: +30 210 7721861 > 'Go back to the shadow' Gandalf > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > -- Kostas Kalevras Network Operations Center [EMAIL PROTECTED] National Technical University of Athens, Greece Work Phone: +30 210 7721861 'Go back to the shadow' Gandalf - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
