mysql accounting connect speeds

[Jeff]

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 = ''           WHERE AcctSess' at line 1
Mon Jul 16 11:23:24 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 = ''           WHERE AcctSess' at line 1
Mon Jul 16 11:23:37 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 = ''           WHERE AcctSess' at line 1
Mon Jul 16 11:23:42 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 = ''           WHERE AcctSess' at line 1
      _____  

  From: tnt at kalik.co.yu
To: FreeRadius users mailing list [mailto:freeradius-users at lists.freeradius.org]
Sent: Mon, 16 Jul 2007 11:06:28 -0400
Subject: Re: mysql accounting connect speeds

And the errors are?

Ivan Kalik
Kalik Informatika ISP


Dana 16/7/2007, "Jeff" <jeffa at jahelpdesk.com> 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 work. 
>
>I see this info in the update accounting packet so i thought I would modify the update query but It gives errors 
>
>anyone know why this is wrong.. it stops right at the AscendDataRate ='26400' for example then nothing after 
>
>Trying to gather the Ascend-Data-Rate and USR-Connect-Speed 
>
> accounting_update_query = "UPDATE ${acct_table1} \
> SET FramedIPAddress = '%{Framed-IP-Address}', \
> AcctSessionTime = '%{Acct-Session-Time}', \
> AcctInputOctets = '%{Acct-Input-Octets}', \
> AcctOutputOctets = '%{Acct-Output-Octets}' \
> AscenDataRate = '%{Ascend-Xmit-Rate}' \
> USRConnectSpeed = '%{USR-Connect-Speed}' \
> WHERE AcctSessionId = '%{Acct-Session-Id}' \
> AND UserName = '%{SQL-User-Name}' \
> AND NASIPAddress= '%{NAS-IP-Address}'"
>

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
      
   
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20070716/6b6b3819/attachment.html>