Terminate dsl ppp sessions daily

[Volker Lieder]

Hi,
we try to calculate it via sql statement and other stuff, like this:

For Expiration: %{sql:select (TIMESTAMPADD(HOUR, 4, TIMESTAMPADD(DAY, 1, CURDATE())))}

For Session-Timeout direct: %{(exp:$(date +%s --date="next day 04:00:00") - $(date +%s)}

but dont find the right way, how to add this to specific users or as an attribute of a group.

If its so easy, why dont easily send back the solution?

And believe, i googled and read a lot ;-)


Am 15.10.2013 um 15:21 schrieb Michael Schwartzkopff:

> Am Dienstag, 15. Oktober 2013, 14:45:53 schrieb Volker Lieder:
> > Hi,
> > 
> > we tried this fix setting:
> > 
> > Expiration := October 15 2013 13:45:00
> > 
> > is working,
> > 
> > but we want to use an attribute/value in mysql, which calculates the session
> > timeout/expiration from login of the account until tomorrow, 04:00 am,
> > where tomorrow is a variable, too.
>  
> As already posted in this thread, use the expiration module. Calculate the expiration time dynamically from time NOW until 4:00 on the next morning.
>  
> FreeRADIUS can set attributes on the fly as the packed is authorized.
>  
> -- 
> Mit freundlichen Grüßen,
>  
> Michael Schwartzkopff
>  
> -- 
> [*] sys4 AG
>  
> http://sys4.de, +49 (89) 30 90 46 64, +49 (162) 165 0044
> Franziskanerstraße 15, 81669 München
>  
> Sitz der Gesellschaft: München, Amtsgericht München: HRB 199263
> Vorstand: Patrick Ben Koetter, Axel von der Ohe, Marc Schiffbauer
> Aufsichtsratsvorsitzender: Florian Kirstein
> -
> 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/20131015/1fc2e22e/attachment.html>