sqlcounters for traffic

[Alexandre Chapellon]

tnt at kalik.net a écrit :
>> Good it's sent in the reply to the nas! Thx
>> But the sqlcounter i setup was supposed to reset every hours , but
>> apparently doesn't...
>> Where can i take a look to find out why?
>>     
>
> Check the sql query definition and value of reset in counter.conf.
>   

here is the counter definition:
sqlcounter bytesQuota {
        counter-name = traffic_quota
        check-name = Max-Traffic
        reply-name = Tmp-Integer-0
        sqlmod-inst = mysqldb
        key = User-Name
        reset = hourly
        query = "SELECT SUM(acctinputoctets + acctoutputoctets) FROM
radacct WHERE UserName='%{%k}'"
}

sounds good to me... what could be the reasn for noreset?

> Ivan Kalik
> Kalik Informatika ISP
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20080909/8537abda/attachment.html>