Removing stale expired accounts from SQL

Rôney Eduardo roneyeduardosantos at gmail.com
Tue Jun 4 23:41:41 CEST 2013


2013/6/4 Ethan Hayon <ehayon at gmail.com>:
> Hi, Thanks for the response.
>
> I only want to run the SQL query if the user's account is already expired.
> Wouldn't I need to put it in here?
>

No,

You can adapt the instruction I gave you to delete the entries based
on the attributes you want to check for a "stale expired account".

You could do, for instance:

        if(User-Name){
                "%{sql:DELETE FROM radreply WHERE
username='%{User-Name}' AND attribute='%{WhatEverYouUse} AND
value='%{Calling-Station-Id}' }"
        }

--
Roney Eduardo


More information about the Freeradius-Users mailing list