On Sat, 2011-03-26 at 15:01 -0500, Marc Phillips wrote:
I'm using freeradius with coova-chilli. Works fine and dandy, but I'm trying to enforce some policy which I can do with some scripts, but it would be much cleaner to do with radius (IMHO).
What I want to happen is when user session timeout or bandwidth restriction has been hit, update a database field. right now on session timeout accounting_update_query appears to be run. I would like to run an additional query as well, to disable the account (I've added a "disabled" field to the radcheck and updated my auth query to check that).
Is this something that can be configured, or is there some better way to accomplish what I'm trying to do?
Why not define a trigger in the database to run the additional query or a function that can perform the necessary checks and the execute a query.