Menu

radacct table was flushed because of something

Help
Mr.Zenith
2014-06-10
2014-06-11
  • Mr.Zenith

    Mr.Zenith - 2014-06-10

    Hello,

    I'm using RD with the latest SVN. I found an issue that the rows in radacct table were deleted as time passed, after user logged in for a while and those rows were deleted. I don't know which part of RD that delete this, I need to maintain radacct rows for future reference, so I don't want these rows to be deleted automatically.

    Please help...

     
    • Mfawa Alfred Onen

      You can check the cron scripts and see if there is anything that
      deletes the entries. But I believe it was more of a design
      consideration than a bug because overtime, your database will grow
      large and might eventually slow things down for you.

      Regards!

       
      • Mr.Zenith

        Mr.Zenith - 2014-06-11

        I set my voucher to be valid until 1 day from first login. If these entries are missing, then the validity period limitation won't work any more, because user still can repeatedly use these vouchers.

         
  • Dirk van der Walt

    Hi,

    This is not suppose to happen. What captive portal do you use? (CoovaChilli or Mikrotik)

    There is a cron job that is used to remove duplicates that Mikrotik somehow mange to generate:

    Every two minutes; you ma want to increase it on bigger deployments

    /2 * * * www-data /var/www/cake2/rd_cake/Console/cake -app /var/www/cake2/rd_cake Removeduplicates >> /dev/null 2>&1

    Comment that out of the cron (/etc/cron.d) file and see if it solved your problem

     
    • Mr.Zenith

      Mr.Zenith - 2014-06-11

      Hi Dirk,

      I'm using Mikrotik. In which case that the cronjob suppose to remove those duplicate records? Will it cause any problem if I comment that line out?

       
  • Dirk van der Walt

    Remove it and do check your account entries to see if there are any doubles....
    it will not brake anything it may report wrong usage

     
    • Mr.Zenith

      Mr.Zenith - 2014-06-11

      Comment it out and accounting entries no longer removed. :)
      /////////////////

      One more thing, i'm not sure if anyone facing the same thing as me or not.
      If I create a voucher with expiry date in the first place, then I edit the voucher to be 'Never expire', but after editing, the expiry date attribute still there...

       

      Last edit: Mr.Zenith 2014-06-11

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.