I have freeradius 0.8.1 running against a MySQL database successfully. What is the easiest/best way to do a second check against a different SQL table?
For instance, I already have freeradius doing a query like: SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'matthew_simpson' ORDER BY id; to retrieve the Password now I want it to do a query like SELECT AccountStatus FROM masteraccounts WHERE Username = 'matthew_simpson'; and if AccountStatus is, say, 0, send a radius reject packet. Do I need to patch the sql handler to do this, or is there a way to do it with what I already have? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
