Search Again: Usage Problem From: William Potter Date: Tuesday, June 3, 2003 Time: 7:44:09 am Shawn: 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)),((((AcctInputO ctets+AcctOutputOctets)/1024)/1024)),FramedIPAddress,CalledStationId,Cal lingStationId,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. Please help. William Potter NetBurner Internet 316 10th St. Paintsville, KY. 41240 (606) 789-7161 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.483 / Virus Database: 279 - Release Date: 5/19/2003

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