<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style>
<!--
@font-face
{font-family:Calibri}
@font-face
{font-family:Tahoma}
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}
p.msochpdefault, li.msochpdefault, div.msochpdefault
{margin-right:0cm;
margin-left:0cm;
font-size:10.0pt;
font-family:"Times New Roman","serif"}
span.emailstyle17
{font-family:"Calibri","sans-serif";
color:windowtext}
span.emailstyle18
{font-family:"Calibri","sans-serif";
color:#1F497D}
span.EmailStyle20
{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"><span style="color:#1F497D">I have been looking in this more and I have another freeradius box with Ubuntu x64 12.04 LTS with freeradius 2.1.10 and this works fine so I upgraded mine to the same with no luck. Freeradius for the accounting
is working fine with 64bit counters so I am struggling to find an answer.</span></p>
<p class="MsoNormal"><span style="color:#1F497D"> </span></p>
<div>
<div style="border:none; border-top:solid #B5C4DF 1.0pt; padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt; font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt; font-family:"Tahoma","sans-serif""> freeradius-users-bounces+jonathan.bastin=peerpointinternet.co.uk@lists.freeradius.org
[mailto:freeradius-users-bounces+jonathan.bastin=peerpointinternet.co.uk@lists.freeradius.org]
<b>On Behalf Of </b>Jonathan Bastin<br>
<b>Sent:</b> 25 June 2012 11:43<br>
<b>To:</b> freeradius-users@lists.freeradius.org<br>
<b>Subject:</b> FW: SQLm_counter and 64 bit values</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<div>
<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>
</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>