Re: sqlcounters for traffic

9 Sep 2008


      tnt@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/users.html

Re: sqlcounters for traffic

Alexandre Chapellon