rlm_sqlcounter question
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
participants (1)
-
Hekuran Doli