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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html