mysql accounting connect speeds

[Jeff]

ok heres what i have now  
 accounting_update_query = "UPDATE ${acct_table1} \
          SET FramedIPAddress = '%{Framed-IP-Address}', \
          AcctSessionTime = '%{Acct-Session-Time}', \
          AcctInputOctets = '%{Acct-Input-Octets}', \
          AcctOutputOctets = '%{Acct-Output-Octets}' \
          AscendDataRate = '%{Ascend-Data-Rate}', \
          USRConnectSpeed = '%{USR-Connect-Speed}' \
          WHERE AcctSessionId = '%{Acct-Session-Id}' \
          AND UserName = '%{SQL-User-Name}' \
          AND NASIPAddress= '%{NAS-IP-Address}'"  
   
   
an heres the new error  
   
Mon Jul 16 12:49:19 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 AcctSes' at line 1
Mon Jul 16 12:49:35 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 AcctSes' at line 1
Mon Jul 16 12:49:40 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 AcctSes' at line 1
Mon Jul 16 12:49:59 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 AcctSes' at line   
   
 
      _____  

  From: Dennis Skinner [mailto:dskinner at bluefrog.com]
To: FreeRadius users mailing list [mailto:freeradius-users at lists.freeradius.org]
Sent: Mon, 16 Jul 2007 11:59:34 -0400
Subject: Re: mysql accounting connect speeds

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 =
> '' WHERE AcctSess' at line 1

You need a comma between data items:

'AscendDataRate = '24000', USRConnectSpeed ='' WHERE AcctSess'
^^^

-- 
Dennis Skinner
Systems Administrator
BlueFrog Internet
http://www.bluefrog.com
- 
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/890f6836/attachment.html>