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
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
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: dialup_admin: log_badlogins problem
I had to download dialup-admin from the cvs snapshot to allow "[EMAIL PROTECTED]". > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Kostas > Kalevras > Sent: Monday, October 20, 2003 8:57 AM > To: [EMAIL PROTECTED] > Subject: RE: dialup_admin: log_badlogins problem > > > On Fri, 17 Oct 2003, Kenny Olano wrote: > > > I fixed that issue. I had to run it as perl log_badlogins > > /path/to/radius.log. But now when it logs the bad logins, The > username is > > just a "-". > > That probable has to do with the form of your usernames. > log_badlogins will only > log usernames matching the regex [EMAIL PROTECTED] for now. > > > > > > -Original Message- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] Behalf Of Kostas > > > Kalevras > > > Sent: Friday, October 17, 2003 9:25 AM > > > To: Freeradius-Users > > > Subject: Re: dialup_admin: log_badlogins problem > > > > > > > > > On Fri, 17 Oct 2003, Kenny Olano wrote: > > > > > > > I'm trying to run log_badlogin but I keep getting the following > > > error "sh: > > > > /usr/local/mysql/bin/mysql: No such file or directory" I am > pointing the > > > > $mysql variable to right path "/usr/bin/mysql" Why does it > > > still try to > > > > use "/usr/local/mysql/bin/mysql" ? I even tried commenting out > > > the insert > > > > command but I still get this error. Any help will be appreciated. > > > > > > As long as you have something like: > > > > > > $mysql='/usr/bin/mysql'; > > > > > > in your log_badlogins it should work just fine... > > > > > > > > > > > Kenny Olano > > > > Web Programmer > > > > Practical Solutions > > > > > > > > > > > > - > > > > 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: dialup_admin: log_badlogins problem
I fixed that issue. I had to run it as perl log_badlogins /path/to/radius.log. But now when it logs the bad logins, The username is just a "-". > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Kostas > Kalevras > Sent: Friday, October 17, 2003 9:25 AM > To: Freeradius-Users > Subject: Re: dialup_admin: log_badlogins problem > > > On Fri, 17 Oct 2003, Kenny Olano wrote: > > > I'm trying to run log_badlogin but I keep getting the following > error "sh: > > /usr/local/mysql/bin/mysql: No such file or directory" I am pointing the > > $mysql variable to right path "/usr/bin/mysql" Why does it > still try to > > use "/usr/local/mysql/bin/mysql" ? I even tried commenting out > the insert > > command but I still get this error. Any help will be appreciated. > > As long as you have something like: > > $mysql='/usr/bin/mysql'; > > in your log_badlogins it should work just fine... > > > > > Kenny Olano > > Web Programmer > > Practical Solutions > > > > > > - > > 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
dialup_admin: log_badlogins problem
I'm trying to run log_badlogin but I keep getting the following error "sh: /usr/local/mysql/bin/mysql: No such file or directory" I am pointing the $mysql variable to right path "/usr/bin/mysql" Why does it still try to use "/usr/local/mysql/bin/mysql" ? I even tried commenting out the insert command but I still get this error. Any help will be appreciated. Kenny Olano Web Programmer Practical Solutions - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html