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@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@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@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@gmail.com> wrote:

you should define integer64 for volume attribute in fr dictionary.

On Oct 15, 2014 8:25 PM, "Abdullah" <b.hawks123@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