[EMAIL PROTECTED] 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/users.html
>
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
