To to change the following :
Try to change the following in your sqlcounter dailycounter and
montlycounter.
sqlmod-inst = sqlcca3 ----> sqlmod-inst = sql
----- Original Message -----
From: "Juan Pablo Fava" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 20, 2004 10:18 PM
Subject: Re: sqlcounter: count=0 ?????
> Here it is.
>
> Thanks!
>
> apellido dijo:
> > 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
> >
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
