9 Sep
2008
9 Sep
'08
6:02 p.m.
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