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