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