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

[Russell Mike]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20141015/0600fe87/attachment-0001.html>