1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL radacct not updating

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

  1. seanbracken

    seanbracken Network Guru Member

    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

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

Share This Page