Active/Inactive record in MySQL

[Bob Franklin]

On Tue, 23 Mar 2010, Alan DeKok wrote:

>> Is there somewhere in the mysql database (default schema)  record 
>> saying that your account is active or inactive which freeradius will 
>> understand?
>
>  No.  But you can always extend the schema.

FWIW, our [postgresql] backend serves the standard schema as a view, which 
only includes rows for users which are active.

[We also implement different services being active as being a member of a 
group in the 'usergroup' view.]

   - Bob


-- 
  Bob Franklin <rcf34 at cam.ac.uk>              +44 1223 748479
  Network Division, University of Cambridge Computing Service