Navigation

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

    Freeradius sql acctsessiontime is wrong

    Captive Portal
    1
    2
    974
    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.
    • K
      Kababayan last edited by

      Hi all
      From time to time I got some wrong accounting in sql radius.radacct acctsessiontime. (stoptime - starttime) does not equal to sessiontime and the value is sooo big 2 bil. My Pfsense is a 32 bit. Here is the SS.

      For regular user without time limit this is okey but to users with time limit its really a problem. have to delete the entries then delete the counter db as well.

      Edit
      My setup is:
      Pfsense is in VM wtih reeradius 2.
      Sql is in the Host of the VM.

      1 Reply Last reply Reply Quote 0
      • K
        Kababayan last edited by

        NVM its fix as Jimp suggested from this post http://forum.pfsense.org/index.php/topic,57632.msg307926.html#msg307926. I think the Nas is sending wrong time. or its the device (an old nokia cell phone). here is a log when it happen.
        php: rc.prunecaptiveportal: Radius accounting debug: Start: 1386328206 Stop: 1386298766 Session time: -29440
        after fix adding + line in /usr/local/captiveportal/radius_accounting.inc
        **  $session_time = $stop_time - $start_time;

        • $session_time = ($session_time >= 0) ? intval($session_time) : 0;**
          setting it tp zero when unsigned acctsessiontime in sql no have zero. dont know if it is the same in db counters have to test it yet with account having time limit.
        1 Reply Last reply Reply Quote 0
        • First post
          Last post

        Products

        • Platform Overview
        • TNSR
        • pfSense
        • Appliances

        Services

        • Training
        • Professional Services

        Support

        • Subscription Plans
        • Contact Support
        • Product Lifecycle
        • Documentation

        News

        • Media Coverage
        • Press
        • Events

        Resources

        • Blog
        • FAQ
        • Find a Partner
        • Resource Library
        • Security Information

        Company

        • About Us
        • Careers
        • Partners
        • Contact Us
        • Legal
        Our Mission

        We provide leading-edge network security at a fair price - regardless of organizational size or network sophistication. We believe that an open-source security model offers disruptive pricing along with the agility required to quickly address emerging threats.

        Subscribe to our Newsletter

        Product information, software announcements, and special offers. See our newsletter archive to sign up for future newsletters and to read past announcements.

        © 2021 Rubicon Communications, LLC | Privacy Policy