<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Marcel<br>
<br>
I don't know if i'm right, or if it's related to your problem, but if
you check the source of rlm_sqlcounter (rlm_sqlcounter.c), you may see
that this module seems really time based (Alan will correct me if i'm
wrong). Indeed the module contains a function that make it possible for
a user to start using its next month's quota, if the integer returned
by the check-name is greater than the number of seconds untill the
reset time. In your case this would suggest you compare bytes your with
seconds, and mso maybe you allow sometime user to use their quota twice
a month, or something like this.<br>
<br>
Once again what I say here needs to be checked, but i'm almost sure
sqlcounter mechanism are time related.<br>
<br>
<br>
<br>
Marcel Grandemange a écrit :
<blockquote cite="mid:011401c923ce$a5326bf0$ef9743d0$@za.net"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="Section1">
<p class="MsoNormal">I have a working FreeRadius installation used
for PPPOE
clients using a Mikrotik NAS (Essentialy Linux)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I am using Freeradius to limit data a user can
send/receive
within a month and automatically reset it every month.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I used an example from chilliuspot hotspot for
this.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">However what im noticing is sometimes a customer
gets denied
access because he has exceeded he’s monthly allowance, however when I
check
the<o:p></o:p></p>
<p class="MsoNormal">Db this is not the case cause it’s the beginning
of
month.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">This only happens sometimes so im lost!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I use sqlcounter.conf for the counter part of
things and
INCLUDE this from radius.conf.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">sqlcounter monthlytraffic {<o:p></o:p></p>
<p class="MsoNormal">
counter-name = Monthly-Traffic<o:p></o:p></p>
<p class="MsoNormal">
check-name = Max-Monthly-Traffic<o:p></o:p></p>
<p class="MsoNormal">
reply-name = Mikrotik-Xmit-Limit-Gigawords<o:p></o:p></p>
<p class="MsoNormal">
sqlmod-inst = sql<o:p></o:p></p>
<p class="MsoNormal">
key = User-Name<o:p></o:p></p>
<p class="MsoNormal">
reset = monthly<o:p></o:p></p>
<p class="MsoNormal">query = "SELECT SUM(AcctInputOctets -
GREATEST((%b -
UNIX_TIMESTAMP(AcctStartTime)), 0))+ SUM(AcctOutputOctets -GREATEST((%b
-
UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}'
AND UNIX_TIMESTAMP(AcctStartTime)
+ AcctSessionTime > '%b'"<o:p></o:p></p>
<p class="MsoNormal">}<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Anybody for input? I would greately appreciate
help here! A
Work around is to simply increase he’s allowance till he is allowed to
connect!<o:p></o:p></p>
</div>
<pre wrap="">
<hr size="4" width="90%">
-
List info/subscribe/unsubscribe? See <a class="moz-txt-link-freetext" href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a></pre>
</blockquote>
</body>
</html>