Sqlcounter Max-Octets doesn't reset

Sigfrido sigfrido_to at email.it
Mon Apr 2 11:54:58 CEST 2007

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20070402/8d8e3db1/attachment.html>

More information about the Freeradius-Users mailing list