<div dir="ltr">yes i have setup mysql<div>apparently custom counters dont work. are you using fr3 for providing the download limits?</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Oct 15, 2014 at 7:36 PM, Russell Mike <span dir="ltr"><<a href="mailto:radius.sir@gmail.com" target="_blank">radius.sir@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><span style="font-family:georgia,serif">Abdullah, <br><br></span><span style="font-family:georgia,serif"><span style="font-family:georgia,serif">Did you say your counter does not work ? </span>Of course you need rlm_counter. Have you already done mysql setup ? Counter would not even help if you have not setup proper accounting MySQL etc...<br><br></span></div><span style="font-family:georgia,serif">Well, here is the counter i use. it is little way different your own, i use Max-All-MB CoovaChilli attributes to scale more than terabyte. if you need to follow step by step how to setup MAX-All-MB. follow my blog. i am already providing up to 100GB. <br></span><div><span style="font-family:georgia,serif"><br><a href="http://prabhpal.wordpress.com/2013/11/05/settings-data-limits-traffic-quota-volume-quota-download-limits-more-than-higher-than-4gb-for-users-using-freeradius-coovachilli/" target="_blank">http://prabhpal.wordpress.com/2013/11/05/settings-data-limits-traffic-quota-volume-quota-download-limits-more-than-higher-than-4gb-for-users-using-freeradius-coovachilli/</a><br><br><br><br>sqlcounter chillispot_max_all_mb {<br><br> counter-name = "Download-Limit-MB"<br> check-name = "Max-All-MB"<br> reply-name = "Session-Timeout"<br> reply-message = "You have reached your bandwidth limit"<br> sqlmod-inst = "sql"<br> key = "User-Name"<br> reset = "never"<br> cache-size = 5000<br> query = "SELECT SUM(AcctInputOctets) / (1024*1024) + SUM(AcctOutputOctets) / (1024*1024) FROM radacct WHERE UserName='%{%k}'"<br>}</span><br><br><span style="font-family:garamond,serif"><br></span></div><div><span style="font-family:garamond,serif">Thanks / RM--</span><br></div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Oct 15, 2014 at 2:14 PM, Abdullah <span dir="ltr"><<a href="mailto:b.hawks123@gmail.com" target="_blank">b.hawks123@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>i am usig coova chilli</div><div>so lets say i want to set 10GB</div><div>i set ChilliSpot-Max-Total-Octets=<span style="font-family:georgia,serif;font-size:13px">2147483648</span></div><div><span style="font-family:georgia,serif;font-size:13px">and Gigawords = 2</span></div><div><span style="font-family:georgia,serif;font-size:13px">but how will the user get disconnected at 10gb? do i need a counter or will it be done automaticallly?</span></div></div><div><div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Oct 15, 2014 at 6:57 PM, Russell Mike <span dir="ltr"><<a href="mailto:radius.sir@gmail.com" target="_blank">radius.sir@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><span style="font-family:georgia,serif">Hi<br><br>Which NAS are you using ? Use "gigaword" attribute to define the limits more than 4GB. it is easy, for example, if you want 10 Gb limit. <br><br><b>The Value Of 10GB In Bytes If Following</b> <br>10737418240<br><br><br><b>The Value of Octets_Attribute For Check Item</b><br>2147483648<br><b><br>The Value of Gigawords_Attribute For Check Item</b><br>2</span></div><div><span style="font-family:georgia,serif"><br></span></div><span style="font-family:georgia,serif">Use the following python script to calculate the values when ever you need. Change the value in VARIABLE "<b>GB_Value</b>" to the number you want. <br></span><div><br><font size="1"><span style="font-family:Arial;font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">#!/usr/bin/python</span><br>
<span style="font-family:Arial;font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">GB_Value = 10</span><br>
<span style="font-family:Arial;font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal"></span><br>
<span style="font-family:Arial;font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">Total_Bytes = GB_Value*(1024**3)</span><br>
<span style="font-family:Arial;font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">print 'The Value Of Given Number In Bytes If Following', '\n', Total_Bytes</span><br>
<span style="font-family:Arial;font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal"></span><br>
<span style="font-family:Arial;font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">Octets_Attribute = GB_Value*(1024**3) & ((2**32)-1);</span><br>
<span style="font-family:Arial;font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">Gigawords_Attribute = GB_Value*(1024**3) >> 32;</span><br>
<span style="font-family:Arial;font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal"></span><br>
<span style="font-family:Arial;font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">print '\n'</span><br>
<span style="font-family:Arial;font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">print 'The Value of Octets_Attribute is' '\n', Octets_Attribute</span><br>
<span style="font-family:Arial;font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">print 'The Value of Gigawords_Attribute is' '\n', Gigawords_Attribute</span><br>
<span style="font-family:Arial;font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal"></span><br>
<span style="font-family:Arial;font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">print '\n' 'Confirming Calculations & Giving Results:'</span><br>
<span style="font-family:Arial;font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal"></span><br>
<span style="font-family:Arial;font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">i = (Gigawords_Attribute<<32) + Octets_Attribute;</span><br>
<span style="font-family:Arial;font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">#i = (1<<32) + Octets_Attribute;</span><br>
<span style="font-family:Arial;font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">print 'This Number Must Equel To Bytes Of Given Number. Please Verify', i</span><br>
<span style="font-family:Arial;font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal"></span><br>
<span style="font-family:Arial;font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">j = GB_Value*(1024**3);</span><br>
<span style="font-family:Arial;font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">print 'Using Second Methos To Verify Output Number. Is This Orignal Number in Bytes ', j,'?'</span><br>
<span style="font-family:Arial;font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">print '\n'</span><br><span style="font-family:garamond,serif"><font size="4"><br><br></font></span></font></div><div><span style="font-family:garamond,serif"><font size="4">I trust this helps. <br></font></span></div><div><span style="font-family:garamond,serif"><font size="4">Thanks / RM--<br></font></span></div><div><br><br><br></div></div><div class="gmail_extra"><br><div class="gmail_quote"><span>On Wed, Oct 15, 2014 at 1:34 PM, johan firdianto <span dir="ltr"><<a href="mailto:johanfirdi@gmail.com" target="_blank">johanfirdi@gmail.com</a>></span> wrote:<br></span><div><div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><p dir="ltr">you should define integer64 for volume attribute in fr dictionary.<br>
</p>
<div class="gmail_quote"><div><div>On Oct 15, 2014 8:25 PM, "Abdullah" <<a href="mailto:b.hawks123@gmail.com" target="_blank">b.hawks123@gmail.com</a>> wrote:<br type="attribution"></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div dir="ltr">Hello<div>Fr disconects the user auto at 2gb, when i increase the ChilliSpot-Max-Total-Octets to anything more than 3.9GB, it never disconnects the user whereas any value under 3.9GB works fine and user gets disconnected when the limit is reached.</div><div><br></div><div>I need some help as to how volume greater than 4GB can be implemented. I have tried some older methods involving setting up counters but either they dont get called/executed from the same config files as in 2.x branch</div><div><br></div><div>So please guide me as to how can it be achieved</div><div><br></div><div>Regards,</div></div>
<br></div></div>-<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>-<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></div></div><br></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></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></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></div>