<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.3059" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi all,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>freeradius 1.1.0 on Ubuntu Dapper</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>all's going but the counter below is not
resetting:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>sqlcounter volumelimitcounter {</FONT></DIV>
<DIV><FONT face=Arial size=2>
counter-name =
Total-Max-Octets</FONT></DIV>
<DIV><FONT face=Arial size=2>
check-name =
Max-Octets</FONT></DIV>
<DIV><FONT face=Arial size=2>
reply-name =
ChilliSpot-Max-Total-Octets</FONT></DIV>
<DIV><FONT face=Arial size=2>
sqlmod-inst =
sql</FONT></DIV>
<DIV><FONT face=Arial size=2>
key =
User-Name</FONT></DIV>
<DIV><FONT face=Arial size=2>
reset =
daily</FONT></DIV>
<DIV><FONT face=Arial size=2>
query = "SELECT
SUM(AcctOutputOctets) FROM radacct where UserName ='%{%k}'"</FONT></DIV>
<DIV><FONT face=Arial size=2>}</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2>Any idea ? It's a bug or what ?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>TIA</FONT></DIV>
<br><br>
<br><p><font face="Verdana,Arial" size=2>----<br>
Email.it, the professional e-mail, gratis per te:<a href=http://www.email.it/cgi-bin/start?sid=3 target=_blank>clicca qui</a><br>
<br>
Sponsor:<br>
Problemi di Liquidità? Con Logos Finanziaria 30.000 ÿ in 24 ore a dipendenti e lavoratori autonomi con rimborsi fino a 120 mesi clicca qui<br><br>
<a href=http://adv.email.it/cgi-bin/foclick.cgi?mid=2907&d=2-4 target=_blank>Clicca qui</a></font><br>
<br></BODY></HTML>