<!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>Yes, and the AscendDataRate too.</DIV>
<DIV>I get the inserts fine on the start packet and the data goes right in as suppose too.</DIV>
<DIV> </DIV>
<DIV>all works fine this way for our GlobalPOPS and all data shows up and into sql using this line in the start</DIV>
<DIV>---</DIV>
<DIV> accounting_start_query = "INSERT into ${acct_table1} (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AscendDataRate, USRConnectSpeed, AcctStopDelay) values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%S', '0', '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '%{Acct-Delay-Time}', '%{Ascend-Xmit-Rate}', '%{USR-Connect-Speed}', '0')"</DIV>
<DIV>---</DIV>
<DIV>data goes right into mysql tables</DIV>
<DIV> </DIV>
<DIV>But YNP for some reason most miss the start, so I thought maybe I could grab them on the update query cause i see one or the other on in update packet, for ynp so then i would have what i need, but as i stated this errors out with the error i mentioned below trying to do this</DIV>
<DIV> </DIV>
<DIV>Jeff</DIV>
<DIV> </DIV><BR>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<HR>
<B>From:</B> Hugh Messenger [mailto:hugh@alaweb.com]<BR><B>To:</B> 'FreeRadius users mailing list' [mailto:freeradius-users@lists.freeradius.org]<BR><B>Sent:</B> Mon, 16 Jul 2007 11:40:53 -0400<BR><B>Subject:</B> RE: mysql accounting connect speeds<BR><BR><BR>Jeff said:<BR>> USRConnectSpeed = '%{USR-Connect-Speed}' \<BR><BR>Did you actually add a USRConnectSpeed column to the radacct table? There<BR>isn't one by default.<BR><BR>-- hugh<BR><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>