max-daily-session

Pierluigi Di Lorenzo lists at eprometeus.com
Fri Mar 9 01:59:27 CET 2007


Hi all,
I am using Freeradius + Chillispot + Mysql in a hotel wifi and it's
working very fine.
I have set per user Max-Daily-Session with sql_counter and it works.
Now they ask me another situation:
the hotel has various workstations that everybody can use.
I need to set a low Max-Daily-Session (1 hour) when a user log trough
these workstation, and set Max-Daily-Session = 24 hours when user use
it's own notepad.
so:
can I override per user Max-Daily-Session when request come from a
certain CallingStationId?
what I tried is to use query on sql_counter but it seems there is no
variables with CallingStationId, something like:
query = "SELECT (SUM(AcctSessionTime) + ((WORKSTATIONID =
$CallingStationId) * 82800) FROM radacct WHERE UserName='%{%k}' AND
AcctStartTime > FROM_UNIXTIME('%b')"

Any idea?
Thank's in advance.
-- 
Pierluigi Di Lorenzo
ePrometeus s.r.l



More information about the Freeradius-Users mailing list