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

    Empty MySQL radacct table with FreeRadius3 PFSense 2.5

    Scheduled Pinned Locked Moved Captive Portal
    4 Posts 2 Posters 965 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.
    • G
      giovannio
      last edited by giovannio

      I did a new installation of PFSense, with version 2.5, where I installed FreeRadius 3 that works together with MySQL for Captive Portal.
      Since version 2.4, the MySQL radacct table is empty.
      I can see the logs in /var/log/radacct/{IP}, but what I need is for them to be registered in the MySQL table.
      I've done a lot of research and I couldn't find a solution.
      I request your help and thank you very much in advance.

      GertjanG 1 Reply Last reply Reply Quote 0
      • GertjanG
        Gertjan @giovannio
        last edited by

        @giovannio said in Empty MySQL radacct table with FreeRadius3 PFSense 2.5:

        I can see the logs in /var/log/radacct/{IP}, but what I need is for them to be registered in the MySQL table.

        I have the same daily log files in /var/log/radacct/{IP} - these are is what I call the transactions logs of radius.

        My MySQL radacct table is used as the 'scratchpad' for the accounting.
        It's contains thousands of lines, and I purge it a couple of time per year.

        Example :

        1529abd4-ee64-4607-b7f3-2ec4a7263646-image.png

        You've set :

        ece2096e-b02a-4083-a8dc-262521e2afa6-image.png

        Btw : keep in mind : freeradius is installed as a package and service.
        But : the pfSense Freeradius package - the GUI part - offers just a small part of all the freeradius capabilities / settings.

        No "help me" PM's please. Use the forum, the community will thank you.
        Edit : and where are the logs ??

        1 Reply Last reply Reply Quote 0
        • G
          giovannio
          last edited by

          Hello Gertjan,

          Thanks for the answer.
          I am developing a system that manages Captive Portal accounts via MySQL and the radacct table is very important to map the state of the accounts.
          The system works well, except that the radacct table is not registering anything. Curious that in versions prior to 2.4 of PFSense it worked correctly.
          If you have any solution to activate the operation of that table I would be grateful.

          1 Reply Last reply Reply Quote 0
          • G
            giovannio
            last edited by

            It's solved! I noticed that some columns were missing from the radacct table. I copied a new MySQL schema radacct table and it already works.

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