RE: Sqlcounter Max-Octets doesn't reset

--===============1535433678==
Content-Type: text/plain; format=flowed

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@email.it>
>Reply-To: FreeRadius users mailing list
><freeradius-users@lists.freeradius.org>
>To: <freeradius-users@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?pro...isc=y&vers=910


--===============1535433678==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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