Sqlcounter Max-Octets doesn't reset

[Internet-Wifi Operador]

Hi, take a look to sqlcounter dailycounter.
I think, you need modify your query, to get that you want.



Fabián





>From: "Sigfrido" <sigfrido_to at email.it>
>Reply-To: FreeRadius users mailing list 
><freeradius-users at lists.freeradius.org>
>To: <freeradius-users at lists.freeradius.org>
>Subject: Sqlcounter Max-Octets doesn't reset
>Date: Mon, 2 Apr 2007 11:54:58 +0200
>
>Hi all,
>
>freeradius 1.1.0 on Ubuntu Dapper
>
>all's going but the counter below is not resetting:
>
>sqlcounter volumelimitcounter {
>                     counter-name = Total-Max-Octets
>                     check-name = Max-Octets
>                     reply-name = ChilliSpot-Max-Total-Octets
>                     sqlmod-inst = sql
>                     key = User-Name
>                     reset = daily
>                     query = "SELECT SUM(AcctOutputOctets) FROM radacct 
>where UserName ='%{%k}'"
>}
>
>
>I would like to reset, everyday at 00:00, the Max-Octets (in radcheck 
>table) to 0 but it seems not working. I tried also the "hourly" reset, with 
>same results.
>Any idea ? It's a bug or what ?
>
>TIA
>
>
>
>
>  --
>
>  Email.it, the professional e-mail, gratis per te: http://www.email.it/f
>
>
>
>  Sponsor:
>
>  Problemi di Liquiditÿ? Con Logos Finanziaria 30.000 ÿ in 24 ore a 
>dipendenti e lavoratori autonomi con rimborsi fino a 120 mesi clicca qui
>
>*
>
>  Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=2907&d=2-4
>


>-
>List info/subscribe/unsubscribe? See 
>http://www.freeradius.org/list/users.html

_________________________________________________________________
5.5%* 30 year fixed mortgage rate. Good credit refinance. Up to 5 free 
quotes - *Terms 
https://www2.nextag.com/goto.jsp?product=100000035&url=%2fst.jsp&tm=y&search=mortgage_text_links_88_h2a5d&s=4056&p=5117&disc=y&vers=910