<div dir="ltr"><div><span style="font-family:georgia,serif">Never Mind, Glad That worked for You. <br></span></div><b><span style="font-family:georgia,serif">Thanks / Prabhpal Singh</span></b> <br></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Oct 21, 2014 at 1:10 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">had to add the counter name to to authorize section<div>works flawlessly</div><div>Thanks for your help :)</div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Oct 16, 2014 at 9:55 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><font><br></font><div><font><span style="font-family:garamond,serif">it is due to check item, check item that deny on re login. it is something very little. <br><br></span></font></div><div><font><span style="font-family:garamond,serif"><br></span></font></div><font><span style="font-family:garamond,serif"><b>Cross Check: </b><br><span style="font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal"></span><br>
<span style="font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">1.) Write down your data limit as one 64 bit number</span>. Or use python script to generate upper / lower number(s)<br>
<span style="font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal"></span><br>
<span style="font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">2.) Put lower 32bit number in <span style="background-color:rgb(255,0,0)"><b>Octets attribute</b></span> and Uper 32bit number in <span style="background-color:rgb(255,0,0)"><b>Gigawords attribute</b></span> as <span style="color:rgb(255,0,0)">reply items</span>.</span> </span><span style="font-family:garamond,serif"><span style="font-family:Garamond;font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">- Reply Item Used For Disconnection- <b>Already Working !!!!!!!</b></span><b>
<span style="font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal"></span></b><br><br>
<span style="font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">3.) Create Max-All-MB RLM_SQL counter</span><span><br><br>sqlcounter <span style="color:rgb(255,0,0)"><b>chillispot_max_all_mb </b></span>{<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></span> query = "SELECT SUM(AcctInputOctets) / (1024*1024) + SUM(AcctOutputOctets) / (1024*1024) FROM radacct WH$<br>}<br>
<span style="font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal"></span><br>
<span style="font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">4.) Add Max-All-MB attributes in dictionary file </span><br><br><span style="font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">nano /usr/share/freeradius/dictionary.chilli</span><br>
<span style="font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">ATTRIBUTE Max-All-MB 3008 integer</span> (if 3008 is already occupied use 3009 4009 etc..)<br>
<span style="font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal"></span><br>
<span style="font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">5.) Specify check item as "Max-All-MB" attributes</span> - for example 6GB = 6144MB
<span style="font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal"></span> </span><span style="font-family:garamond,serif"><span style="font-family:Garamond;font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">Check-Item Prevent Re Login <b>Not Working !!!!!!</b></span><b>
</b><br>
<span style="font-style:normal;font-variant:normal;font-weight:normal;line-height:normal;font-size-adjust:none;font-stretch:normal">6.) User should be part of this Freeraidus Group (Profile), where you have added those check and reply attributes attached</span><br><br><br></span></font></div><div><font><span style="font-family:garamond,serif"><b>I suspect the problem in step 7. </b><br></span></font></div><div><font><span style="font-family:garamond,serif"><br>7.) <br></span><br><span style="font-family:garamond,serif"><span style="font-family:garamond,serif">Add </span></span><span style="font-family:garamond,serif"><span style="font-family:garamond,serif"><span style="font-family:garamond,serif">"chillispot_max_all_mb</span>" in </span></span></font><font><span style="font-family:garamond,serif"><span style="font-family:garamond,serif"><font><span style="font-family:garamond,serif"> /etc/freeradius/radiusd.conf under </span></font></span></span></font><font><span style="font-family:garamond,serif"><span style="font-family:garamond,serif"><font><span style="font-family:garamond,serif"><font><span style="font-family:garamond,serif">instantiate </span></font>section <br></span></font><br></span>instantiate {<br>chillispot_max_all_mb<br></span></font><div><font><span style="font-family:garamond,serif">more entries..<br></span></font></div><div><font><span style="font-family:garamond,serif"><br></span></font></div><font><span style="font-family:garamond,serif">7a.) Add "</span><span style="font-family:garamond,serif"><span style="font-family:garamond,serif">chillispot_max_all_mb</span>" /etc/freeradius/sites-available/default in authorize section <br><br>authorize {<br>chillispot_max_all_mb<br>
more entries..
</span></font></div><div><div><font><span style="font-family:garamond,serif"><br>Keep on trying Would work. <br><br></span></font></div><div><font><span style="font-family:garamond,serif">Thanks RM--<br></span></font></div><div><font><span style="font-family:garamond,serif"></span><br></font></div></div><div><div><div class="gmail_extra"><font><br></font><div class="gmail_quote"><font>On Thu, Oct 16, 2014 at 1:12 PM, Abdullah <span dir="ltr"><<a href="mailto:b.hawks123@gmail.com" target="_blank">b.hawks123@gmail.com</a>></span> wrote:<br></font><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><font>yes have done both those steps </font><div><font>cant really see what am i missing? :/</font></div><div><font>users gets disconnected alrighjt but doesnt prvent relogin</font></div></div><div><div><div class="gmail_extra"><font><br></font><div class="gmail_quote"><font>On Thu, Oct 16, 2014 at 12:11 PM, Russell Mike <span dir="ltr"><<a href="mailto:radius.sir@gmail.com" target="_blank">radius.sir@gmail.com</a>></span> wrote:<br></font><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><font><span style="font-family:georgia,serif">Hi Abdullah<br></span></font><div><font><span style="font-family:georgia,serif"><br>This is not a bug rather problem, you can fix it. You are almost there. Please understand the setup and fix it, else you cannot troubleshoot it as needed. i am sure there is problem with the counter which perform check item test. or there is no gigaword check-item defined. today i am in full day meeting cannot help further. list down the steps you feel you need to check and see. <br><br><br></span></font></div><div><font><span style="font-family:georgia,serif">Have you done this ?<br><br><br></span></font><p><font><span style="font-family:georgia,serif">4.) Adding Max-All-MB in dictionary file “/usr/share/freeradius/dictionary.chilli” --> nano /usr/share/freeradius/dictionary.chilli<br>
A TTRIBUTE Max-All-MB 3080 integer</span></font></p><font><span style="font-family:georgia,serif">
</span></font><p><font><span style="font-family:georgia,serif">5.) Specify Check Attributes (check-itmes) Max-All-MB := 6144</span></font></p>
<font><br></font></div><div><font><span style="font-family:georgia,serif">Thanks</span><br></font></div><div><font><br><br></font></div></div><div><div><div class="gmail_extra"><font><br></font><div class="gmail_quote"><font>On Wed, Oct 15, 2014 at 6:58 PM, Abdullah <span dir="ltr"><<a href="mailto:b.hawks123@gmail.com" target="_blank">b.hawks123@gmail.com</a>></span> wrote:<br></font><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><font>ok the counter works great and user gets disconnected with the value set </font><div><font>but when the user logins next time, he is able to login again and use the same amount of data again</font></div><div><font>the count_in_mb counter gets the value 4080 instead of 6144 </font></div><div><font>anything wrong with the query?</font></div></div><div><div><div class="gmail_extra"><font><br></font><div class="gmail_quote"><font>On Wed, Oct 15, 2014 at 9:35 PM, Russell Mike <span dir="ltr"><<a href="mailto:radius.sir@gmail.com" target="_blank">radius.sir@gmail.com</a>></span> wrote:<br></font><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><font>no v2.2 but would not be difference. setup your 2GB limits working before jumping to above 4GB. <br></font></div><div><div><div class="gmail_extra"><font><br></font><div class="gmail_quote"><font>On Wed, Oct 15, 2014 at 2:40 PM, Abdullah <span dir="ltr"><<a href="mailto:b.hawks123@gmail.com" target="_blank">b.hawks123@gmail.com</a>></span> wrote:<br></font><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><font>yes i have setup mysql</font><div><font>apparently custom counters dont work. are you using fr3 for providing the download limits?</font></div></div><div><div><div class="gmail_extra"><font><br></font><div class="gmail_quote"><font>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></font><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><font><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></font></div><font><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></font><div><font><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></font></div><div><font><span style="font-family:garamond,serif">Thanks / RM--</span><br></font></div></div><div><div><div class="gmail_extra"><font><br></font><div class="gmail_quote"><font>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></font><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><font>i am usig coova chilli</font></div><div><font>so lets say i want to set 10GB</font></div><div><font>i set ChilliSpot-Max-Total-Octets=<span style="font-family:georgia,serif">2147483648</span></font></div><div><font><span style="font-family:georgia,serif">and Gigawords = 2</span></font></div><div><font><span style="font-family:georgia,serif">but how will the user get disconnected at 10gb? do i need a counter or will it be done automaticallly?</span></font></div></div><div><div><div class="gmail_extra"><font><br></font><div class="gmail_quote"><font>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></font><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><font><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></font></div><div><font><span style="font-family:georgia,serif"><br></span></font></div><font><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></font><div><font><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">#!/usr/bin/python</span><br></font>
<font><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></font>
<font><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></font>
<font><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></font>
<font><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></font>
<font><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></font>
<font><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></font>
<font><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></font>
<font><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></font>
<font><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></font>
<font><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></font>
<font><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></font>
<font><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></font>
<font><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></font>
<font><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></font>
<font><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></font>
<font><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></font>
<font><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></font>
<font><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></font>
<font><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></font>
<font><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></font>
<font><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"><br><br></span></font></div><div><font><span style="font-family:garamond,serif">I trust this helps. <br></span></font></div><div><font><span style="font-family:garamond,serif">Thanks / RM--<br></span></font></div><div><font><br><br><br></font></div></div><div class="gmail_extra"><font><br></font><div class="gmail_quote"><font><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></font><div><div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><p dir="ltr"><font>you should define integer64 for volume attribute in fr dictionary.<br></font>
</p>
<div class="gmail_quote"><div><div><font>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"></font></div></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div><div dir="ltr"><font>Hello</font><div><font>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.</font></div><div><font><br></font></div><div><font>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</font></div><div><font><br></font></div><div><font>So please guide me as to how can it be achieved</font></div><div><font><br></font></div><div><font>Regards,</font></div></div>
<font><br></font></div></div><font>-<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></font></blockquote></div>
<font><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></font></blockquote></div></div></div><font><br></font></div>
<font><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></font></blockquote></div><font><br></font></div>
</div></div><font><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></font></blockquote></div><font><br></font></div>
</div></div><font><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></font></blockquote></div><font><br></font></div>
</div></div><font><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></font></blockquote></div><font><br></font></div>
</div></div><font><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></font></blockquote></div><font><br></font></div>
</div></div><font><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></font></blockquote></div><font><br></font></div>
</div></div><font><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></font></blockquote></div><font><br></font></div>
</div></div><font><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></font></blockquote></div><font><br></font></div></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>