reset parameter controls value of %b. Ivan Kalik Kalik Informatika ISP Dana 9/9/2008, "Alexandre Chapellon" <alexandre.chapellon@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@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