rlm_sqlcounter question

[Hekuran Doli]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20060121/e7d79650/attachment.html>