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.
> -----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
