<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style>
<!--
@font-face
{font-family:Calibri}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif"}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
span.EmailStyle17
{font-family:"Calibri","sans-serif";
color:windowtext}
span.EmailStyle18
{font-family:"Calibri","sans-serif";
color:#1F497D}
.MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:72.0pt 72.0pt 72.0pt 72.0pt}
div.WordSection1
{}
-->
</style>
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">I am using Freeradius 2 on Ubuntu 64 bit machine. I am trying to add up the months’ worth of data the user has used and make sure they don’t go over capacity.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">So far I have counter.conf:</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">sqlcounter monthlydata {</p>
<p class="MsoNormal"> counter-name = Total-Octets-Monthly</p>
<p class="MsoNormal"> check-name = CS-Total-Octets-Monthly</p>
<p class="MsoNormal"> reply-name = menu</p>
<p class="MsoNormal"> sqlmod-inst = sql</p>
<p class="MsoNormal"> key = User-Name</p>
<p class="MsoNormal"> reset = never</p>
<p class="MsoNormal"> query = "SELECT SUM( AcctInputOctets + AcctOutputOctets) FROM radacct WHERE UserName='%{%k}' AND AcctStartTime > (DATE_SUB(CURDATE(),INTERVAL DAYOFMONTH(CURDATE())DAY))"
</p>
<p class="MsoNormal">}</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">And in the users I have a check value of CS-Total-Octets-Monthly := 107375000000</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">The issue I am having is that I get Debug: rlm_sqlcounter: (Check item - counter) is less than zero which I believe is because the sql query returns a value bigger than 32bit and the sql counter module isn’t 64 bit counter.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Is anybody able to offer me advise on where to go with this one. I did read this thread but no real fix came out of it
<a href="http://freeradius.1045715.n5.nabble.com/Problem-with-rml-sqlcounter-with-GigaByte-datavolume-td4455164.html">
http://freeradius.1045715.n5.nabble.com/Problem-with-rml-sqlcounter-with-GigaByte-datavolume-td4455164.html</a></p>
</div>
-------------------------------------------------------------------------------------------------------------------------- This email (including any attachments) is intended only for the recipient(s) named above. It may contain confidential or privileged information
and should not be read, copied or otherwise used by any other person. If you are not the named recipient please contact the sender and delete the email from your system. The author's incumbent expressions, views and thoughts are their own and not necessarily
representative of those of the Peer Point Internet Ltd or associated companies.
</body>
</html>