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