Search Again: Re: Usage Problem From: Shawn Hogan Date: Tuesday, June 3, 2003 Time: 10:26:50 am William Potter wrote: > We setup icradius and mysql to report usage. Everything went fine the month of > May. > > We have an auto user doing nightly imports of the usage. That works. > > The thing I can not figure out, why the call details stopped working when the > month went to June. > > The sql statement did not change and it works fine if I use it directly on the > Mysql server. > > > > SELECT > AcctStopTime,'',AcctSessionTime+(60-(AcctSessionTime%60)),((((AcctInputOctets+ > AcctOutputOctets)/1024)/1024)),FramedIPAddress,CalledStationId,CallingStationI > d,NASIPAddress FROM radacct WHERE UserName='<Login>' ORDER BY AcctStopTime > desc limit 100 > > > > This worked on all workstations on Friday May 30. > > It did not work on any workstations on Monday June 2. Not sure... try running it with the debugger on (you can turn it on under the server events). - Shawn ---------------------------------- Shawn D. Hogan President, Digital Point Solutions http://www.digitalpoint.com (858) 452-3696 --------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.optigold.com/lists/isp.html ---------------------------------------------------

Messages In This Thread: Usage Problem by William Potter on Jun 3, 2003 at 7:44:09 am Re: Usage Problem by Shawn Hogan on Jun 3, 2003 at 10:26:50 am