reset sql counter every time user logged in

mohamed almeshal mohammed.almeshal at
Sun Dec 11 19:49:08 UTC 2022

dear Savers
I'm in middle of missy code , I need to expire the session every time the user is logged in , I do all my best but I found that best
way is to set max-all-session for the session and that will exipre the session every time and regenerate new session id ,
now my question is how to reset the sql counter every time the user is logged in

sqlcounter sql_session_timeout_never {
      sql_module_instance = sql

      counter_name = Max-All-Session-Time
      check_name = Max-All-Session
      reply_name = Session-Timeout
      key = User-Name
      reset = never

      query = "\
            SELECT IFNULL(SUM(AcctSessionTime),0) \
            FROM radacct \
            WHERE UserName='%{${key}}'"

I must set reset = ?

thanks , all

More information about the Freeradius-Users mailing list