<!DOCTYPE html PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN'>
<html>
<head>
<meta http-equiv='Content-Type' content='text/html;charset=UTF-8'>
<style>BODY{font:10pt Tahoma, Verdana, sans-serif;}</style>
</head>
<body>
<DIV>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<BR>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<BR>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<BR>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</DIV><BR>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<HR>
<B>From:</B> tnt@kalik.co.yu<BR><B>To:</B> FreeRadius users mailing list [mailto:freeradius-users@lists.freeradius.org]<BR><B>Sent:</B> Mon, 16 Jul 2007 11:06:28 -0400<BR><B>Subject:</B> Re: mysql accounting connect speeds<BR><BR>And the errors are?<BR><BR>Ivan Kalik<BR>Kalik Informatika ISP<BR><BR><BR>Dana 16/7/2007, "Jeff" <<A href="mailto:jeffa@jahelpdesk.com">jeffa@jahelpdesk.com</A>> piše:<BR><BR>>I need to log connect speeds from users <BR>><BR>>At any rate things working fine from our own carrier globalpops to capture these on the start packet <BR>><BR>>but Yournetplus for some reason it doesn't work. <BR>><BR>>I see this info in the update accounting packet so i thought I would modify the update query but It gives errors <BR>><BR>>anyone know why this is wrong.. it stops right at the AscendDataRate ='26400' for example then nothing after <BR>><BR>>Trying to gather the Ascend-Data-Rate and USR-Connect-Speed <BR>><BR>> 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>> AscenDataRate = '%{Ascend-Xmit-Rate}' \<BR>> USRConnectSpeed = '%{USR-Connect-Speed}' \<BR>> WHERE AcctSessionId = '%{Acct-Session-Id}' \<BR>> AND UserName = '%{SQL-User-Name}' \<BR>> AND NASIPAddress= '%{NAS-IP-Address}'"<BR>><BR><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>