reset parameter controls value of %b. Ivan Kalik Kalik Informatika ISP
Dana 9/9/2008, "Alexandre Chapellon" <[EMAIL PROTECTED]> 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 : >> >> >> [EMAIL PROTECTED] 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 > > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html