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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html