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