Empty MySQL radacct table with FreeRadius3 PFSense 2.5
-
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. -
@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 :
You've set :
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. -
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. -
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.
