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