Hello, Im trying to use rlm_sqlcounter to make daily session limit,
I use Max-Daily-Session := 60 to end the session in 60 seconds and finish the
authentication for that day, but it dosent seems to work, it sets the Session-Timeout = 60 but the
user is able to authenticate again in
the same day. Also the Max-Monthly-Session dosent work but
Max-All-Session work fine. Here are logs of rlm_sqlcounter in debugg mode: rlm_sqlcounter: Entering module authorize code rlm_sqlcounter: Could not find Check item value pair modcall[authorize]: module "noresetcounter"
returns noop for request 0 rlm_sqlcounter: Entering module authorize code sqlcounter_expand: 'SELECT SUM(AcctSessionTime -
GREATEST((1137711600 - UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE
UserName='%{User-Name}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime
> '1137711600'' radius_xlat: 'SELECT SUM(AcctSessionTime -
GREATEST((1137711600 - UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE
UserName='florin' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime >
'1137711600'' sqlcounter_expand: '%{sqlcca3:SELECT
SUM(AcctSessionTime - GREATEST((1137711600 - UNIX_TIMESTAMP(AcctStartTime)),
0)) FROM radacct WHERE UserName='florin' AND UNIX_TIMESTAMP(AcctStartTime) +
AcctSessionTime > '1137711600'}' radius_xlat: '' rlm_sqlcounter: (Check item - counter) is greater than zero rlm_sqlcounter: Authorized user florin, check_item=60,
counter=0 rlm_sqlcounter: Sent Reply-Item for user florin,
Type=Session-Timeout, value=60 modcall[authorize]: module "dailycounter"
returns ok for request 0 rlm_sqlcounter: Entering module authorize code rlm_sqlcounter: Could not find Check item value pair Thanks |
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html