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