MySQL radacct not updated

sean sean at
Tue Aug 23 19:16:52 CEST 2005


 I have a strange problem with MySQL and FreeRadius. 
The system had been performing perfectly but it is no longer updating
radacct. The result is that when users login the counter on their login
page counts down their remaining time. But when they logout and then
login again the counter is reset back to its origional value. This means
that user names and passwords last forever. 

The sql log file used to show 
  SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='bebbik6'; 
   INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm,
   NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime,
  AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop,
 AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId,
   AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress,
       AcctStartDelay, AcctStopDelay) values('42e4494400000000',
 '3f1c519e5a66e2fe', 'bebbik6', '', '', '0', 'Wireless-802.11',
  '2005-07-26 06:04:07', '0', '0', '', '', '', '0', '0', '00-12-17-B7-
  A1-70', '00-C0-49-5C-40-48', '', '', '', '', '', '0'); 
UPDATE radacct SET AcctStopTime = '2005-07-26 06:04:13', AcctSessionTime
      = '6', AcctInputOctets = '1403', AcctOutputOctets = '5179',
        AcctTerminateCause = 'User-Request', AcctStopDelay = '',
   ConnectInfo_stop = '' WHERE AcctSessionId = '42e4494400000000' AND
          UserName = 'bebbik6' AND NASIPAddress = ''; 

But now it only shows 
   SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='bebbik6';

I'd really appreciate any help to solve this problem. 

Regards from Ireland. 

Sean Bracken

More information about the Freeradius-Users mailing list