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