Sqlcounter Max-Octets doesn't reset
This is a discussion on Sqlcounter Max-Octets doesn't reset within the FreeRADIUS Users forums, part of the Networking and Network Related category; This is a multi-part message in MIME format. --===============1179242495== Content-Type: multipart/alternative; boundary="----=_NextPart_000_00B7_01C7751D.BCC6E040" This ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-02-2007
|
|||
|
|||
Sqlcounter Max-Octets doesn't reset
This is a multi-part message in MIME format.
--===============1179242495== Content-Type: multipart/alternative; boundary="----=_NextPart_000_00B7_01C7751D.BCC6E040" This is a multi-part message in MIME format. ------=_NextPart_000_00B7_01C7751D.BCC6E040 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, freeradius 1.1.0 on Ubuntu Dapper all's going but the counter below is not resetting: sqlcounter volumelimitcounter { counter-name =3D Total-Max-Octets check-name =3D Max-Octets reply-name =3D ChilliSpot-Max-Total-Octets sqlmod-inst =3D sql key =3D User-Name reset =3D daily query =3D "SELECT SUM(AcctOutputOctets) FROM radacct = where UserName =3D'%{%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 =0D=0A =0D=0A --=0D=0A Email.it, the professional e-mail, gratis per te: http://www.email.it/f=0D= =0A =0D=0A Sponsor:=0D=0A Problemi di Liquidit=FF? Con Logos Finanziaria 30.000 =FF in 24 ore a dipenden= ti e lavoratori autonomi con rimborsi fino a 120 mesi clicca qui=0D=0A * =0D=0A Clicca qui: http://adv.email.it/cgi-bin/foclick....&d=3D2-4=0D=0A ------=_NextPart_000_00B7_01C7751D.BCC6E040 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.3059" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi all,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>freeradius 1.1.0 on Ubuntu = Dapper</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>all's going but the counter below is = not=20 resetting:</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>sqlcounter volumelimitcounter = {</FONT></DIV> <DIV><FONT face=3DArial size=3D2> =20 counter-name = =3D=20 Total-Max-Octets</FONT></DIV> <DIV><FONT face=3DArial size=3D2> =20 check-name =3D=20 Max-Octets</FONT></DIV> <DIV><FONT face=3DArial size=3D2> =20 reply-name =3D=20 ChilliSpot-Max-Total-Octets</FONT></DIV> <DIV><FONT face=3DArial size=3D2> =20 sqlmod-inst =3D = sql</FONT></DIV> <DIV><FONT face=3DArial size=3D2> =20 key =3D=20 User-Name</FONT></DIV> <DIV><FONT face=3DArial size=3D2> =20 reset =3D=20 daily</FONT></DIV> <DIV><FONT face=3DArial size=3D2> =20 query =3D = "SELECT=20 SUM(AcctOutputOctets) FROM radacct where UserName = =3D'%{%k}'"</FONT></DIV> <DIV><FONT face=3DArial size=3D2>}</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I would like to reset, everyday at = 00:00, the=20 Max-Octets (in radcheck table) to 0 but it seems not working. I tried = also the=20 "hourly" reset, with same results.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Any idea ? It's a bug or what = ?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>TIA</FONT></DIV> <br>= <br>=0D=0A <br><p><font face=3D"Verdana,Arial" size=3D2>----<br>=0D=0A Email.it, the professional e-mail, gratis per te:<a href=3Dhttp://www.email.i= t/cgi-bin/start?sid=3D3 target=3D_blank>clicca qui</a><br>=0D=0A <br>=0D=0A Sponsor:<br>=0D=0A Problemi di Liquidità? Con Logos Finanziaria 30.000 =FF in 24 ore a di= pendenti e lavoratori autonomi con rimborsi fino a 120 mesi clicca qui<br><b= r>=0D=0A <a href=3Dhttp://adv.email.it/cgi-bin/foclick.cgi?mid=3D2907&d=3D2-4 target=3D_blan= k>Clicca qui</a></font><br>=0D=0A =0D=0A <br>= </BODY></HTML> ------=_NextPart_000_00B7_01C7751D.BCC6E040-- --===============1179242495== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html --===============1179242495==-- 
|
 |
«
Previous Thread
|
Next Thread
»
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT +1. The time now is 01:57 PM.
