i need help
table radgroupcheck:
mysql> select * from radgroupcheck where
GroupName='35Horas';
+----+-----------+---------------------+----+--------+ | id | GroupName | Attribute | op | Value | +----+-----------+---------------------+----+--------+ | 15 | 35horas | Max-Monthly-Session | := | 126000 | +----+-----------+---------------------+----+--------+ 1 row in set (0.00 sec) mysql> SELECT SUM(AcctSessionTime - GREATEST((1038708000 -
UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='santos' AND
UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime >
'1038708000';
+----------------------------------------------------------------------------------+ | SUM(AcctSessionTime - GREATEST((1038708000 - UNIX_TIMESTAMP(AcctStartTime)), 0)) | +----------------------------------------------------------------------------------+ | 232305 | +----------------------------------------------------------------------------------+ 1 row in set (0.00 sec) radius -X
rlm_sqlcounter: Entering module authorize
code
rlm_sqlcounter: Could not find Check item value pair modcall[authorize]: module "noresetcounter" returns noop rlm_sqlcounter: Entering module authorize code rlm_sqlcounter: Could not find Check item value pair modcall[authorize]: module "dailycounter" returns noop rlm_sqlcounter: Entering module authorize code sqlcounter_expand: 'SELECT
SUM(AcctSessionTime - GREATEST((1038708000 - UNIX_TIMESTAMP(AcctStartTime)), 0))
FROM radacct WHERE UserName='%{User-Name}' AND UNIX_TIMESTAMP(AcctStartTime) +
AcctSessionTime > '1038708000''
radius_xlat: 'SELECT SUM(AcctSessionTime - GREATEST((1038708000 - UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='santos' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '1038708000'' sqlcounter_expand: '%{sqlcca3:SELECT
SUM(AcctSessionTime - GREATEST((1038708000 - UNIX_TIMESTAMP(AcctStartTime)), 0))
FROM radacct WHERE UserName='santos' AND UNIX_TIMESTAMP(AcctStartTime) +
AcctSessionTime > '1038708000'}'
WARNING: Attempt to use unknown xlat function or
attribute in string %{sqlcca3:SELECT SUM(AcctSessionTime - GREATEST((1038708000
- UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='santos' AND
UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime >
'1038708000'}
radius_xlat: '' rlm_sqlcounter: (Check item - counter) is greater
than zero
rlm_sqlcounter: Authorized user santos, check_item=126000, counter=0 rlm_sqlcounter: Sent Reply-Item for user santos, Type=Session-Timeout,
value=126000
modcall[authorize]: module "monthlycounter" returns ok modcall: group authorize returns ok
Why not work ?
|