mysql accounting connect speeds

2007-07-16 Thread Jeff
I need to log connect speeds from users At any rate things working fine from our own carrier globalpops to capture these on the start packet but Yournetplus for some reason it doesn't work. I see this info in the update accounting packet so i thought I would modify the update query but

Re: mysql accounting connect speeds

2007-07-16 Thread tnt
And the errors are? Ivan Kalik Kalik Informatika ISP Dana 16/7/2007, "Jeff" <[EMAIL PROTECTED]> piše: >I need to log connect speeds from users > >At any rate things working fine from our own carrier globalpops to capture >these on the start packet > >but Yournetplus for some reason it doe

Re: mysql accounting connect speeds

2007-07-16 Thread Jeff
error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AscendDataRate = '19200' USRConnectSpeed = '' WHERE AcctSess' at line 1 _ From: [EMAIL PROTECTED] To: FreeRad

RE: mysql accounting connect speeds

2007-07-16 Thread Hugh Messenger
Jeff said: >  USRConnectSpeed = '%{USR-Connect-Speed}' \ Did you actually add a USRConnectSpeed column to the radacct table? There isn't one by default. -- hugh - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

RE: mysql accounting connect speeds

2007-07-16 Thread Jeff
he update query cause i see one or the other on in update packet, for ynp so then i would have what i need, but as i stated this errors out with the error i mentioned below trying to do this Jeff _ From: Hugh Messenger [mailto:[EMAIL PROTECTED] To: 'FreeRadius users

Re: mysql accounting connect speeds

2007-07-16 Thread Dennis Skinner
Jeff wrote: > Mon Jul 16 11:23:22 2007 : Error: rlm_sql (sql): Couldn't update SQL > accounting ALIVE record - You have an error in your SQL syntax; check > the manual that corresponds to your MySQL server version for the right > syntax to use near 'AscendDataRate = '24000' USRConnectSpee

Re: mysql accounting connect speeds

2007-07-16 Thread Jeff
2007 : Error: rlm_sql (sql): Couldn't update SQL accounting ALIVE record - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AscendDataRate = '19200', USRConnectSpeed = ''

Re: mysql accounting connect speeds

2007-07-16 Thread tnt
Yes. You are missing commas before AscendDataRate and USRConnectSpeed expressions that you have added to the update query. Ivan Kalik Kalik Informatika ISP Dana 16/7/2007, "Dennis Skinner" <[EMAIL PROTECTED]> piše: >Jeff wrote: >> Mon Jul 16 11:23:22 2007 : Error: rlm_sql (sql): Couldn't update

Re: mysql accounting connect speeds

2007-07-16 Thread Dennis Skinner
Jeff wrote: > AcctOutputOctets = '%{Acct-Output-Octets}' \ Need comma on live above. This is a MySQL issue, not a FR issue. Please read the MySQL docs if you don't understand how to create a valid query. -- Dennis Skinner Systems Administrator BlueFrog Internet http://www.bluefrog.com

Re: mysql accounting connect speeds

2007-07-16 Thread Jeff
-0400 Subject: Re: mysql accounting connect speeds Jeff wrote: > AcctOutputOctets = '%{Acct-Output-Octets}' \ Need comma on live above. This is a MySQL issue, not a FR issue. Please read the MySQL docs if you don't understand how to create a valid query. -- Dennis Skinner Sys