Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    Reauthenticate connected users every minute – sql implications?

    Scheduled Pinned Locked Moved Captive Portal
    2 Posts 2 Posters 1.6k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • I
      islandwifibill
      last edited by

      Hello all,

      I have "Reauthenticate connected users every minute" checked in my captive portal setup.  I do this so that when users' accounts expire they are kicked automatically.

      However, my sql database creates a new RadAcct entry for each of these reauthentications.  The obvious result is that if a user is logged on for say, an hour, I get sixty separate entries to deal with.  Here's an example:

      As you can see, the database is keeping track of what is a single session because the AcctSessionTime is accurately reflected.

      My question is, what sort of Accounting Updates should I be using to solve this little inconvenience?  I would prefer one RadAcct entry per session, while being able to retain the Reauthenticate every minute.

      1 Reply Last reply Reply Quote 0
      • N
        Nachtfalke
        last edited by

        Try to play with "acct_unique" on freeradius2 settings if you use freeradius2 package.
        Try to use interim-updates

        1 Reply Last reply Reply Quote 0
        • First post
          Last post
        Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.