sqlcounters for traffic

tnt at kalik.net tnt at kalik.net
Wed Sep 10 00:02:01 CEST 2008


>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.

Ivan Kalik
Kalik Informatika ISP




More information about the Freeradius-Users mailing list