Sqlcounter Max-Octets doesn't reset

["Sigfrido" <sigfrido_to@email.it>]

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:clicca qui

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