Removing stale expired accounts from SQL

[Ethan Hayon]

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?

expiration {

#

# The Reply-Message which will be sent back in case the

# account has expired. Dynamic substitution is supported

#

reply-message = "Password Has Expired\r\n"

 # ****** DELETE THE RADREPLY ENTRIES **********


 #reply-message = "Your account has expired, %{User-Name}\r\n"

}


On Tue, Jun 4, 2013 at 4:06 PM, Rôney Eduardo
<roneyeduardosantos at gmail.com>wrote:

> 2013/6/4 Ethan Hayon <ehayon at gmail.com>:
> >
> > Should I be doing this with unlang? I was thinking of using unlang to
> delete
> > all of the associated radreply entries in modules/expiration.
> >
> > Has anyone experienced this problem before, and what solution do you
> think
> > is best?
> >
>
> You can do with unlang. Put the following in the authorize section,
> before "sql":
>
>         if(User-Name){
>                 "%{sql:UPDATE radreply SET zzzz  WHERE yyyy}"
>         }
>
> --
> Roney Eduardo
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20130604/fc026a9f/attachment.html>