Terminate dsl ppp sessions daily

[Volker Lieder]

Hi,
we solved it with this sql query:

mysql> select attribute,op,value from radgroupreply where groupname = '_4Uhr-Trennung' ;
+-----------------+----+------------------------------------------------------------------------------------------------------------------+
| attribute       | op | value                                                                                                            |
+-----------------+----+------------------------------------------------------------------------------------------------------------------+
| Session-Timeout | := | `%{sql:select (UNIX_TIMESTAMP(TIMESTAMPADD(HOUR, 4, TIMESTAMPADD(DAY, 1, CURDATE())))) - UNIX_TIMESTAMP(NOW())}` |
| Fall-Through    | := | YES                                                                                                              |
+-----------------+----+------------------------------------------------------------------------------------------------------------------+

If you have any other solutions, please let us know ;-)

Regards,
Volker

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/0c8442d1/attachment.html>