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


From: "Sigfrido" <[EMAIL PROTECTED]>
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 ?



 Email.it, the professional e-mail, gratis per te: http://www.email.it/f


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

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

Reply via email to