PF, FreeRadius and SQL
-
Hi Guys
I'm using PF to run Freeradius and serve two Omada controllers. Works and absolute treat, no issues at all besides a few older Apple devices that I'm not worried about.
The next stage is to automate credential generation and write a nice management UI for it all. For this I need mysql so I can easily get to the Radius users and groups. New Debian VM spun up, Maria installed tested, Freeradius on PF connected to it and then its all gone wrong.
Accounting information IS written to the Database, I can see good/bad logins but Freeradius is using its internal user database over querying the mysql database. Doing a TCPDump all I see is the logging being put into the Database, it never queries the users or groups. The connection is obviously good. The debugging logs also backup that no query is ever run to get the user data.
My only thought is that is this happening because there are local users still? All options for using SQL are enabled. Table names exist. Using a name that isn't local doesn't result in a lookup. I'm going to remove the users in the local table in a bit to see if this helps but its a bit of a shot in the dark.
Any ideas?