Hi, the problem is that my instalation of sqlcounter doesn`t work, i think
because the counter returns ZERO!!
and i don`t know why, because if i execute sql code by hand, i doesn`t get
zero:
radcheck is ok:
mysql> select * from radcheck where username='troll';
+----+----------+---------------------+----+-------+
| id | UserName | Attribute | op | Value |
+----+----------+---------------------+----+-------+
| 3 | troll | User-Password | == | troll |
| 5 | troll | Max-Monthly-Session | := | 3600 |
+----+----------+---------------------+----+-------+
2 rows in set (0.11 sec)
mysql> SELECT SUM(AcctSessionTime - GREATEST((1078110000 -
UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='troll'
AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '1078110000';
+----------------------------------------------------------------------------------+
| SUM(AcctSessionTime - GREATEST((1078110000 -
UNIX_TIMESTAMP(AcctStartTime)), 0)) |
+----------------------------------------------------------------------------------+
|
376200 |
+----------------------------------------------------------------------------------+
1 row in set (0.00 sec)
Now, lets see radiusd output:
rlm_sqlcounter: Entering module authorize code
sqlcounter_expand: 'SELECT SUM(AcctSessionTime - GREATEST((1078110000 -
UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE
UserName='%{User-Name}' AND UNIX_TIMESTAMP(AcctStartTime) +
AcctSessionTime > '1078110000''
radius_xlat: 'SELECT SUM(AcctSessionTime - GREATEST((1078110000 -
UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='troll'
AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '1078110000''
sqlcounter_expand: '%{sqlcca3:SELECT SUM(AcctSessionTime -
GREATEST((1078110000 - UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct
WHERE UserName='troll' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime
> '1078110000'}'
WARNING: Attempt to use unknown xlat function or attribute in string
%{sqlcca3:SELECT SUM(AcctSessionTime - GREATEST((1078110000 -
UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='troll'
AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '1078110000'}
radius_xlat: ''
rlm_sqlcounter: (Check item - counter) is greater than zero
rlm_sqlcounter: Authorized user troll, check_item=3600, counter=0
<================= HERE !!
rlm_sqlcounter: Sent Reply-Item for user troll, Type=Session-Timeout,
value=3600
modcall[authorize]: module "monthlycounter" returns ok for request 5
<==== NO, IT`S NOT OK!!!! USER CAN`T LOGIN!! :P
Some one have an idea about what`s going on here?
I doesn`t understand the Warning above...
Thanks in advance, and excuse my english.
--
Juan Pablo Fava
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
