On Apr 12, 2018, at 11:15 AM, Dom Latter <freeradius-users@latter.org> wrote:
Ah, I made the rash assumption that anything mentioned then would by now be current - but I now understand that v4 is a big rewrite.
Yeah. Lots and lots and lots of things are changed. The good news is that the server is a lot more capable. The bad news is that it isn't done yet.
So the plan was to move to Perl; but if we did that and ran our mysql queries inside a perl script would we still have the performance issues?
It would be much better than forking a PHP script.
I am beginning to think that we can construct a (rather complicated) query that will return the VLAN that needs to be assigned, or 0 to indicate rejection, or a magic number that will indicate further processing required, and use unlang to act appropriately (and call either a PHP script or in due course a perl script).
That makes sense.
Although rather than a select statement I think it would be a stored procedure.
That's a common solution to this problem. Alan DeKok.