can we take a look at your sqlcounter.conf?
----- Original Message -----
From: "Juan Pablo Fava" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 20, 2004 10:12 AM
Subject: sqlcounter: count=0 ?????
> 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
>
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
