<span style="font-size: 11pt; color: black;" lang="EN-US">check_item=0 , See why </span> Max-Input-Octets is returned as 0 .<br><br><div class="gmail_quote">On Wed, Sep 14, 2011 at 12:55 PM, nfourel <span dir="ltr"><<a href="mailto:nicolas.fourel@adipsys.com">nicolas.fourel@adipsys.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">Hi,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">Here is the result of the SQL Query :<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size: 11pt;" lang="EN-US">SELECT SUM(AcctInputOctets) FROM radacct WHERE <a href="http://user/SendEmail.jtp?type=node&node=4801856&i=0" rel="nofollow" link="external" target="_blank">[hidden email]</a>';<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size: 11pt; color: black;" lang="EN-US">SUM(AcctInputOctets)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: black;" lang="EN-US">68882<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">And freeradius log for the counter section :<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: black;" lang="EN-US">Wed Sep 14 09:17:45 2011 : Debug: rlm_sqlcounter: Entering module authorize code<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size: 11pt; color: black;" lang="EN-US">Wed Sep 14 09:17:45 2011 : Debug: WARNING: Please replace '%k' with '${key}'<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: black;" lang="EN-US">Wed Sep 14 09:17:45 2011 : Debug: sqlcounter_expand: 'SELECT SUM(AcctInputOctets) FROM radacct WHERE UserName='%{User-Name}''<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: black;" lang="EN-US">Wed Sep 14 09:17:45 2011 : Info: (0) totalinputoctets : expand: SELECT SUM(AcctInputOctets) FROM radacct WHERE UserName='%{User-Name}' -> SELECT SUM(AcctInputOctets) FROM radacct WHERE <a href="http://user/SendEmail.jtp?type=node&node=4801856&i=1" rel="nofollow" link="external" target="_blank">[hidden email]</a>'<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: black;" lang="EN-US">Wed Sep 14 09:17:45 2011 : Debug: WARNING: Please replace '%S' with '${sqlmod-inst}'<u></u><u></u></span></p><p class="MsoNormal">
<span style="font-size: 11pt; color: black;" lang="EN-US">Wed Sep 14 09:17:45 2011 : Debug: sqlcounter_expand: '%{sql:SELECT SUM(AcctInputOctets) FROM radacct WHERE <a href="http://user/SendEmail.jtp?type=node&node=4801856&i=2" rel="nofollow" link="external" target="_blank">[hidden email]</a>'}'<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: black;" lang="EN-US">Wed Sep 14 09:17:45 2011 : Info: (0) totalinputoctets : sql_xlat<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size: 11pt; color: black;" lang="EN-US">Wed Sep 14 09:17:45 2011 : Info: (0) totalinputoctets : expand: %{User-Name} -> <a href="http://user/SendEmail.jtp?type=node&node=4801856&i=3" rel="nofollow" link="external" target="_blank">[hidden email]</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: black;" lang="EN-US">Wed Sep 14 09:17:45 2011 : Info: (0) totalinputoctets : sql_set_user escaped user --> '<a href="http://user/SendEmail.jtp?type=node&node=4801856&i=4" rel="nofollow" link="external" target="_blank">[hidden email]</a>'<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: black;" lang="EN-US">Wed Sep 14 09:17:45 2011 : Info: (0) totalinputoctets : expand: SELECT SUM(AcctInputOctets) FROM radacct WHERE <a href="http://user/SendEmail.jtp?type=node&node=4801856&i=5" rel="nofollow" link="external" target="_blank">[hidden email]</a>' -> SELECT SUM(AcctInputOctets) FROM radacct WHERE <a href="http://user/SendEmail.jtp?type=node&node=4801856&i=6" rel="nofollow" link="external" target="_blank">[hidden email]</a>'<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: black;" lang="EN-US">Wed Sep 14 09:17:45 2011 : Info: (0) totalinputoctets: expand: /usr/local/var/log/radius/sqltrace.sql -> /usr/local/var/log/radius/sqltrace.sql<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: black;" lang="EN-US">Wed Sep 14 09:17:45 2011 : Debug: rlm_sql (sql): Reserving sql socket id: 0<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size: 11pt; color: black;" lang="EN-US">Wed Sep 14 09:17:45 2011 : Debug: rlm_sql_mysql: query: SELECT SUM(AcctInputOctets) FROM radacct WHERE <a href="http://user/SendEmail.jtp?type=node&node=4801856&i=7" rel="nofollow" link="external" target="_blank">[hidden email]</a>'<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: black;" lang="EN-US">Wed Sep 14 09:17:45 2011 : Info: (0) totalinputoctets: sql_xlat finished<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size: 11pt; color: black;" lang="EN-US">Wed Sep 14 09:17:45 2011 : Debug: rlm_sql (sql): Released sql socket id: 0<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: black;" lang="EN-US">Wed Sep 14 09:17:45 2011 : Info: (0) totalinputoctets : expand: %{sql:SELECT SUM(AcctInputOctets) FROM radacct WHERE <a href="http://user/SendEmail.jtp?type=node&node=4801856&i=8" rel="nofollow" link="external" target="_blank">[hidden email]</a>'} -> 68882<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: black;" lang="EN-US">Wed Sep 14 09:17:45 2011 : Debug: rlm_sqlcounter: (Check item - counter) is less than zero<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size: 11pt; color: black;" lang="EN-US">Wed Sep 14 09:17:45 2011 : Debug: rlm_sqlcounter: Rejected user <a href="http://user/SendEmail.jtp?type=node&node=4801856&i=9" rel="nofollow" link="external" target="_blank">[hidden email]</a>, check_item=0, counter=68882<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">Any idea ?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">Thanks for your help<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">Nicolas<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"><u></u> <u></u></span></p><div style="border-width: 1pt medium medium; border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; padding: 3pt 0cm 0cm;">
<p class="MsoNormal"><b><span style="font-size: 10pt;" lang="EN-US">De :</span></b><span style="font-size: 10pt;" lang="EN-US"> Suman Dash [via FreeRadius] [mailto:<a href="http://user/SendEmail.jtp?type=node&node=4801856&i=10" rel="nofollow" link="external" target="_blank">[hidden email]</a>] <br>
<b>Envoyé :</b> mardi 13 septembre 2011 19:44<br><b>À :</b> nfourel<div class="im"><br><b>Objet :</b> Re: Problem with rml_sqlcounter with GigaByte datavolume<u></u><u></u></div></span></p></div><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal" style="margin-bottom: 12pt;">SELECT SUM(AcctInputOctets) FROM radacct WHERE UserName='username'</p><div class="im"><br><br>Run the above query in mysql and post the result<br><br>then post the freeradius log specific to this section.<u></u><u></u></div>
<div><div class="im"><p class="MsoNormal">On Tue, Sep 13, 2011 at 10:00 PM, Nicolas FOUREL <<a href="http://user/SendEmail.jtp?type=node&node=4799383&i=0" rel="nofollow" link="external" target="_blank">[hidden email]</a>> wrote:<u></u><u></u></p>
</div><p class="MsoNormal"></p><div class="im">Hi Arran,<br><br>I have get version 3.0.0 with 64 bit counters support from Git and installed<br>it. Unfortunatly, I still have the same problem with my sql counter which<br>
has always "check_item=0" when I put a value bigger than 2^32. On<br>Access-Request in debug mode, I have the following lines :<br><br>Tue Sep 13 18:20:47 2011 : Debug: rlm_sqlcounter: (Check item - counter) is<br>
less than zero<br></div>Tue Sep 13 18:20:47 2011 : Debug: rlm_sqlcounter: Rejected user <a href="http://user/SendEmail.jtp?type=node&node=4799383&i=1" rel="nofollow" link="external" target="_blank">[hidden email]</a>,<div class="im">
<br>check_item=0, counter=68882<br><br>Here is my counter definition :<br>sqlcounter totalinputoctets {<br> counter-name = Total-Max-Input-Octets<br> check-name = Max-Input-Octets<br> reply-name = ChilliSpot-Max-Input-Octets<br>
sqlmod-inst = sql<br> key = User-Name<br> reset = never<br> query = "SELECT SUM(AcctInputOctets) FROM radacct WHERE<br>UserName='%{%k}'"<br>}<br><br>I have added "Max-Input-Octets" in the dictionary file like that :<br>
ATTRIBUTE Max-Input-Octets 3001 integer64<br><br>In radcheck table:<br></div><a href="http://user/SendEmail.jtp?type=node&node=4799383&i=2" rel="nofollow" link="external" target="_blank">[hidden email]</a> Max-Input-Octets :=<div class="im">
<br>107374182400<br><br><br>Did I miss a thing ?<br><br>Many thanks<br><br>Nicolas<br><br>-----Message d'origine-----<br>De :<br></div>freeradius-users-bounces+nicolas.fourel=<a href="http://user/SendEmail.jtp?type=node&node=4799383&i=3" rel="nofollow" link="external" target="_blank">[hidden email]</a><br>
[mailto:<a href="http://user/SendEmail.jtp?type=node&node=4799383&i=4" rel="nofollow" link="external" target="_blank">[hidden email]</a>=<a href="http://user/SendEmail.jtp?type=node&node=4799383&i=5" rel="nofollow" link="external" target="_blank">[hidden email]</a><div class="im">
<br>.org] De la part de Arran Cudbard-Bell<br>Envoyé : lundi 12 septembre 2011 11:46<br>À : FreeRadius users mailing list<br>Objet : Re: Problem with rml_sqlcounter with GigaByte datavolume<u></u><u></u></div><div><div><p class="MsoNormal">
</p><div class="im"><br><br>On 12 Sep 2011, at 10:20, nfourel wrote:<br><br>> Thanks for your reply but I can't find any version 3.x.x of freeRADIUS.<br>Where<br>> can I find it ?<br>><br><br></div><a rel="nofollow" link="external">click here</a>. <u></u><u></u></div>
</div>
<br><hr align="left" width="300">
View this message in context: <a href="http://freeradius.1045715.n5.nabble.com/Problem-with-rml-sqlcounter-with-GigaByte-datavolume-tp4455164p4801856.html" target="_blank">RE: Problem with rml_sqlcounter with GigaByte datavolume</a><div class="im">
<br>
Sent from the <a href="http://freeradius.1045715.n5.nabble.com/FreeRadius-User-f2740693.html" target="_blank">FreeRadius - User mailing list archive</a> at Nabble.com.<br></div></div></div><br>-<br>
List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html" target="_blank">http://www.freeradius.org/list/users.html</a><br></blockquote></div><br>