MySQL radacct not updated

[sean]

 Hi,

 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 
                                 Quote:
  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.0.0.0', '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', '', '', '', '192.168.182.2', '', '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 = '0.0.0.0'; 
                                    


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


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

Regards from Ireland. 

Sean Bracken