FR 3.0.x Head + coova chilli + mysql Volume Limit

Wed Oct 15 19:40:32 CEST 2014

working fine till 4GB
using the link you provided when i add the counter name to default file, i
get this error
* "/usr/local/etc/raddb/sites-enabled/default[358]: Failed to find
"count_in_mb" in the "modules" section."*
have things changed in fr3? How do i add it?

On Wed, Oct 15, 2014 at 9:35 PM, Russell Mike <radius.sir at gmail.com> wrote:

> no v2.2 but would not be difference. setup your 2GB limits working before
> jumping to above 4GB.
>
> On Wed, Oct 15, 2014 at 2:40 PM, Abdullah <b.hawks123 at gmail.com> wrote:
>
>> yes i have setup mysql
>> apparently custom counters dont work. are you using fr3 for providing the
>> download limits?
>>
>> On Wed, Oct 15, 2014 at 7:36 PM, Russell Mike <radius.sir at gmail.com>
>> wrote:
>>
>>> Abdullah,
>>>
>>> Did you say your counter does not work ? 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...
>>>
>>> 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.
>>>
>>>
>>> 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/
>>>
>>>
>>>
>>> sqlcounter chillispot_max_all_mb {
>>>
>>>             counter-name = "Download-Limit-MB"
>>>             check-name = "Max-All-MB"
>>>             reply-name = "Session-Timeout"
>>>             reply-message = "You have reached your bandwidth limit"
>>>             sqlmod-inst = "sql"
>>>             key = "User-Name"
>>>             reset = "never"
>>>             cache-size = 5000
>>>             query = "SELECT SUM(AcctInputOctets) / (1024*1024) +
>>> SUM(AcctOutputOctets) / (1024*1024) FROM radacct WHERE UserName='%{%k}'"
>>> }
>>>
>>>
>>> Thanks / RM--
>>>
>>> On Wed, Oct 15, 2014 at 2:14 PM, Abdullah <b.hawks123 at gmail.com> wrote:
>>>
>>>> i am usig coova chilli
>>>> so lets say i want to set 10GB
>>>> i set ChilliSpot-Max-Total-Octets=2147483648
>>>> and Gigawords = 2
>>>> but how will the user get disconnected at 10gb? do i need a counter or
>>>> will it be done automaticallly?
>>>>
>>>> On Wed, Oct 15, 2014 at 6:57 PM, Russell Mike <radius.sir at gmail.com>
>>>> wrote:
>>>>
>>>>> Hi
>>>>>
>>>>> 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.
>>>>>
>>>>> *The Value Of 10GB In Bytes If Following*
>>>>> 10737418240
>>>>>
>>>>>
>>>>> *The Value of Octets_Attribute For Check Item*
>>>>> 2147483648
>>>>>
>>>>> *The Value of Gigawords_Attribute For Check Item*
>>>>> 2
>>>>>
>>>>> Use the following python script to calculate the values when ever you
>>>>> need. Change the value in VARIABLE "*GB_Value*" to the number you
>>>>> want.
>>>>>
>>>>> #!/usr/bin/python
>>>>> GB_Value = 10
>>>>>
>>>>> Total_Bytes = GB_Value*(1024**3)
>>>>> print 'The Value Of Given Number In Bytes If Following', '\n',
>>>>> Total_Bytes
>>>>>
>>>>> Octets_Attribute = GB_Value*(1024**3) & ((2**32)-1);
>>>>> Gigawords_Attribute = GB_Value*(1024**3) >> 32;
>>>>>
>>>>> print '\n'
>>>>> print 'The Value of Octets_Attribute is' '\n', Octets_Attribute
>>>>> print 'The Value of Gigawords_Attribute is' '\n', Gigawords_Attribute
>>>>>
>>>>> print '\n' 'Confirming Calculations & Giving Results:'
>>>>>
>>>>> i = (Gigawords_Attribute<<32) + Octets_Attribute;
>>>>> #i = (1<<32) + Octets_Attribute;
>>>>> print 'This Number Must Equel To Bytes Of Given Number. Please
>>>>> Verify', i
>>>>>
>>>>> j = GB_Value*(1024**3);
>>>>> print 'Using Second Methos To Verify Output Number. Is This Orignal
>>>>> Number in Bytes ', j,'?'
>>>>> print '\n'
>>>>>
>>>>>
>>>>> I trust this helps.
>>>>> Thanks / RM--
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> On Wed, Oct 15, 2014 at 1:34 PM, johan firdianto <johanfirdi at gmail.com
>>>>> > wrote:
>>>>>
>>>>>> you should define integer64 for volume attribute in fr dictionary.
>>>>>>  On Oct 15, 2014 8:25 PM, "Abdullah" <b.hawks123 at gmail.com> wrote:
>>>>>>
>>>>>>> Hello
>>>>>>> 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.
>>>>>>>
>>>>>>> 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
>>>>>>>
>>>>>>> So please guide me as to how can it be achieved
>>>>>>>
>>>>>>> Regards,
>>>>>>>
>>>>>>> -
>>>>>>> List info/subscribe/unsubscribe? See
>>>>>>> http://www.freeradius.org/list/users.html
>>>>>>>
>>>>>>
>>>>>> -
>>>>>> List info/subscribe/unsubscribe? See
>>>>>> http://www.freeradius.org/list/users.html
>>>>>>
>>>>>
>>>>>
>>>>> -
>>>>> List info/subscribe/unsubscribe? See
>>>>> http://www.freeradius.org/list/users.html
>>>>>
>>>>
>>>>
>>>> -
>>>> List info/subscribe/unsubscribe? See
>>>> http://www.freeradius.org/list/users.html
>>>>
>>>
>>>
>>> -
>>> List info/subscribe/unsubscribe? See
>>> http://www.freeradius.org/list/users.html
>>>
>>
>>
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>>
>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20141015/4e9f2ae6/attachment.html>