<!DOCTYPE html PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN'>
<html>
<head>
<meta http-equiv='Content-Type' content='text/html;charset=us-ascii'>
<style>BODY{font:10pt Tahoma, Verdana, sans-serif;}</style>
</head>
<body>
<DIV>ok heres what i have now</DIV>
<DIV> accounting_update_query = "UPDATE ${acct_table1} \<BR> SET FramedIPAddress = '%{Framed-IP-Address}', \<BR> AcctSessionTime = '%{Acct-Session-Time}', \<BR> AcctInputOctets = '%{Acct-Input-Octets}', \<BR> AcctOutputOctets = '%{Acct-Output-Octets}' \<BR> AscendDataRate = '%{Ascend-Data-Rate}', \<BR> USRConnectSpeed = '%{USR-Connect-Speed}' \<BR> WHERE AcctSessionId = '%{Acct-Session-Id}' \<BR> AND UserName = '%{SQL-User-Name}' \<BR> AND NASIPAddress= '%{NAS-IP-Address}'"</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>an heres the new error</DIV>
<DIV> </DIV>
<DIV>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<BR>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<BR>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<BR>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 </DIV>
<DIV> </DIV>
<DIV> </DIV><BR>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<HR>
<B>From:</B> Dennis Skinner [mailto:dskinner@bluefrog.com]<BR><B>To:</B> FreeRadius users mailing list [mailto:freeradius-users@lists.freeradius.org]<BR><B>Sent:</B> Mon, 16 Jul 2007 11:59:34 -0400<BR><B>Subject:</B> Re: mysql accounting connect speeds<BR><BR>Jeff wrote:<BR>> Mon Jul 16 11:23:22 2007 : Error: rlm_sql (sql): Couldn't update SQL<BR>> accounting ALIVE record - You have an error in your SQL syntax; check<BR>> the manual that corresponds to your MySQL server version for the right<BR>> syntax to use near 'AscendDataRate = '24000' USRConnectSpeed =<BR>> '' WHERE AcctSess' at line 1<BR><BR>You need a comma between data items:<BR><BR>'AscendDataRate = '24000', USRConnectSpeed ='' WHERE AcctSess'<BR>^^^<BR><BR>-- <BR>Dennis Skinner<BR>Systems Administrator<BR>BlueFrog Internet<BR><A href="http://www.bluefrog.com/" target=_blank>http://www.bluefrog.com</A><BR>- <BR>List info/subscribe/unsubscribe? See <A href="http://www.freeradius.org/list/users.html" target=_blank>http://www.freeradius.org/list/users.html</A><BR></BLOCKQUOTE>
<STYLE>
</STYLE>
<DIV> </DIV>
<DIV> </DIV></body></html>