Removing stale expired accounts from SQL

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

2013/6/4 Ethan Hayon <ehayon at>:
> 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?


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:

                "%{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