MySQL radacct not updating

Discussion in 'DD-WRT Firmware' started by seanbracken, Aug 24, 2005.

  1. seanbracken

    seanbracken Network Guru Member


    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
  2. snox135

    snox135 Network Guru Member

    I don't have any experience with FreeRadius, but I do have some experience with SQL servers. With that being said, it appears that your login query has been modified. I would go and check your queries.
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice