RE: manually updating AcctStopTime
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
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
RE: manually updating AcctStopTime
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
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