Sqlcounter Max-Octets doesn't reset
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
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?product=100000035&url=%2fst.jsp&tm=y&search...
Fabián wrote:
Hi, take a look to sqlcounter dailycounter. I think, you need modify your query, to get that you want.
Hi and thanks for answering. Properly speaking I'm not a mysql geek, so I'm afraid I'd not be able to setup a dailycounter-like query :-(. What could be the right syntax for a query like this, to setup the Max-Total-Octets reset everyday at same hour ? Could you please give an example that could help me ? :-) -- Email.it, the professional e-mail, gratis per te: http://www.email.it/f Sponsor: Vuoi essere in grado di saper scrivere un Business Plan vincente? Impara subito seguendo questo videocorso multimediale Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6198&d=3-4
participants (2)
-
Internet-Wifi Operador -
Sigfrido