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 doesn't

Re: mysql accounting connect speeds

2007-07-16 Thread Jeff
to use near 'AscendDataRate = '19200' USRConnectSpeed = '' WHERE AcctSess' at line 1 _ From: [EMAIL PROTECTED] To: FreeRadius users mailing list [mailto:[EMAIL PROTECTED] Sent: Mon, 16 Jul 2007 11:06:28 -0400 Subject: Re: mysql accounting connect speeds

RE: mysql accounting connect speeds

2007-07-16 Thread Jeff
PROTECTED] To: 'FreeRadius users mailing list' [mailto:[EMAIL PROTECTED] Sent: Mon, 16 Jul 2007 11:40:53 -0400 Subject: RE: mysql accounting connect speeds Jeff said: USRConnectSpeed = '%{USR-Connect-Speed}' \ Did you actually add a USRConnectSpeed column to the radacct table? There isn't

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' USRConnectSpeed =

Re: mysql accounting connect speeds

2007-07-16 Thread Jeff
near 'AscendDataRate = '19200', USRConnectSpeed = '' WHERE AcctSes' at line _ From: Dennis Skinner [mailto:[EMAIL PROTECTED] To: FreeRadius users mailing list [mailto:[EMAIL PROTECTED] Sent: Mon, 16 Jul 2007 11:59:34 -0400 Subject: Re: mysql accounting

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 SQL

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 Systems Administrator