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