Thanks for your help Kostas. > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Kostas > Kalevras > Sent: Monday, October 20, 2003 10:40 AM > To: [EMAIL PROTECTED] > Subject: RE: manually updating AcctStopTime > > > 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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html