sqlcounters for traffic

tnt at kalik.net tnt at kalik.net
Wed Sep 10 01:27:43 CEST 2008


reset parameter controls value of %b.

Ivan Kalik
Kalik Informatika ISP


Dana 9/9/2008, "Alexandre Chapellon" <alexandre.chapellon at mana.pf> piše:

>so what's the use of the reset parameter if th sql query is managing it
>all by its own?
>
>Alexandre Chapellon a écrit :
>>
>>
>> tnt at kalik.net a écrit :
>>>> 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?
>>>>
>>>>
>>>
>>>
>>>>        query = "SELECT SUM(acctinputoctets + acctoutputoctets) FROM
>>>> radacct WHERE UserName='%{%k}'"
>>>>
>>>
>>> You need to add to WHERE one of the statements using %b.
>>>
>>
>> Ouch i didn't saw that in the example queries... spank my ...!
>>> Ivan Kalik
>>> Kalik Informatika ISP
>>>
>>> -
>>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/usershtml
>>>
>>>
>> ------------------------------------------------------------------------
>>
>> -
>> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
>




More information about the Freeradius-Users mailing list