FR 3.0.x Head + coova chilli + mysql Volume Limit
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,
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
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
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
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-... 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
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-...
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
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@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@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-...
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
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@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@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@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-...
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
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
ok the counter works great and user gets disconnected with the value set but when the user logins next time, he is able to login again and use the same amount of data again the count_in_mb counter gets the value 4080 instead of 6144 anything wrong with the query? On Wed, Oct 15, 2014 at 9:35 PM, Russell Mike <radius.sir@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@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@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-...
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
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi Abdullah 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. Have you done this ? 4.) Adding Max-All-MB in dictionary file “/usr/share/freeradius/dictionary.chilli” --> nano /usr/share/freeradius/dictionary.chilli A TTRIBUTE Max-All-MB 3080 integer 5.) Specify Check Attributes (check-itmes) Max-All-MB := 6144 Thanks On Wed, Oct 15, 2014 at 6:58 PM, Abdullah <b.hawks123@gmail.com> wrote:
ok the counter works great and user gets disconnected with the value set but when the user logins next time, he is able to login again and use the same amount of data again the count_in_mb counter gets the value 4080 instead of 6144 anything wrong with the query?
On Wed, Oct 15, 2014 at 9:35 PM, Russell Mike <radius.sir@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@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@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-...
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
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
yes have done both those steps cant really see what am i missing? :/ users gets disconnected alrighjt but doesnt prvent relogin On Thu, Oct 16, 2014 at 12:11 PM, Russell Mike <radius.sir@gmail.com> wrote:
Hi Abdullah
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.
Have you done this ?
4.) Adding Max-All-MB in dictionary file “/usr/share/freeradius/dictionary.chilli” --> nano /usr/share/freeradius/dictionary.chilli A TTRIBUTE Max-All-MB 3080 integer
5.) Specify Check Attributes (check-itmes) Max-All-MB := 6144
Thanks
On Wed, Oct 15, 2014 at 6:58 PM, Abdullah <b.hawks123@gmail.com> wrote:
ok the counter works great and user gets disconnected with the value set but when the user logins next time, he is able to login again and use the same amount of data again the count_in_mb counter gets the value 4080 instead of 6144 anything wrong with the query?
On Wed, Oct 15, 2014 at 9:35 PM, Russell Mike <radius.sir@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@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@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-...
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
- 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
it is due to check item, check item that deny on re login. it is something very little. *Cross Check: * 1.) Write down your data limit as one 64 bit number. Or use python script to generate upper / lower number(s) 2.) Put lower 32bit number in *Octets attribute* and Uper 32bit number in *Gigawords attribute* as reply items. - Reply Item Used For Disconnection- *Already Working !!!!!!!* 3.) Create Max-All-MB RLM_SQL counter 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 WH$ } 4.) Add Max-All-MB attributes in dictionary file nano /usr/share/freeradius/dictionary.chilli ATTRIBUTE Max-All-MB 3008 integer (if 3008 is already occupied use 3009 4009 etc..) 5.) Specify check item as "Max-All-MB" attributes - for example 6GB = 6144MB Check-Item Prevent Re Login *Not Working !!!!!!* 6.) User should be part of this Freeraidus Group (Profile), where you have added those check and reply attributes attached *I suspect the problem in step 7. * 7.) Add "chillispot_max_all_mb" in /etc/freeradius/radiusd.conf under instantiate section instantiate { chillispot_max_all_mb more entries.. 7a.) Add "chillispot_max_all_mb" /etc/freeradius/sites-available/default in authorize section authorize { chillispot_max_all_mb more entries.. Keep on trying Would work. Thanks RM-- On Thu, Oct 16, 2014 at 1:12 PM, Abdullah <b.hawks123@gmail.com> wrote:
yes have done both those steps cant really see what am i missing? :/ users gets disconnected alrighjt but doesnt prvent relogin
On Thu, Oct 16, 2014 at 12:11 PM, Russell Mike <radius.sir@gmail.com> wrote:
Hi Abdullah
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.
Have you done this ?
4.) Adding Max-All-MB in dictionary file “/usr/share/freeradius/dictionary.chilli” --> nano /usr/share/freeradius/dictionary.chilli A TTRIBUTE Max-All-MB 3080 integer
5.) Specify Check Attributes (check-itmes) Max-All-MB := 6144
Thanks
On Wed, Oct 15, 2014 at 6:58 PM, Abdullah <b.hawks123@gmail.com> wrote:
ok the counter works great and user gets disconnected with the value set but when the user logins next time, he is able to login again and use the same amount of data again the count_in_mb counter gets the value 4080 instead of 6144 anything wrong with the query?
On Wed, Oct 15, 2014 at 9:35 PM, Russell Mike <radius.sir@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@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@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-...
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
- 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
had to add the counter name to to authorize section works flawlessly Thanks for your help :) On Thu, Oct 16, 2014 at 9:55 PM, Russell Mike <radius.sir@gmail.com> wrote:
it is due to check item, check item that deny on re login. it is something very little.
*Cross Check: *
1.) Write down your data limit as one 64 bit number. Or use python script to generate upper / lower number(s)
2.) Put lower 32bit number in *Octets attribute* and Uper 32bit number in *Gigawords attribute* as reply items. - Reply Item Used For Disconnection- *Already Working !!!!!!!*
3.) Create Max-All-MB RLM_SQL counter
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 WH$ }
4.) Add Max-All-MB attributes in dictionary file
nano /usr/share/freeradius/dictionary.chilli ATTRIBUTE Max-All-MB 3008 integer (if 3008 is already occupied use 3009 4009 etc..)
5.) Specify check item as "Max-All-MB" attributes - for example 6GB = 6144MB Check-Item Prevent Re Login *Not Working !!!!!!* 6.) User should be part of this Freeraidus Group (Profile), where you have added those check and reply attributes attached
*I suspect the problem in step 7. *
7.)
Add "chillispot_max_all_mb" in /etc/freeradius/radiusd.conf under instantiate section
instantiate { chillispot_max_all_mb more entries..
7a.) Add "chillispot_max_all_mb" /etc/freeradius/sites-available/default in authorize section
authorize { chillispot_max_all_mb more entries..
Keep on trying Would work.
Thanks RM--
On Thu, Oct 16, 2014 at 1:12 PM, Abdullah <b.hawks123@gmail.com> wrote:
yes have done both those steps cant really see what am i missing? :/ users gets disconnected alrighjt but doesnt prvent relogin
On Thu, Oct 16, 2014 at 12:11 PM, Russell Mike <radius.sir@gmail.com> wrote:
Hi Abdullah
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.
Have you done this ?
4.) Adding Max-All-MB in dictionary file “/usr/share/freeradius/dictionary.chilli” --> nano /usr/share/freeradius/dictionary.chilli A TTRIBUTE Max-All-MB 3080 integer
5.) Specify Check Attributes (check-itmes) Max-All-MB := 6144
Thanks
On Wed, Oct 15, 2014 at 6:58 PM, Abdullah <b.hawks123@gmail.com> wrote:
ok the counter works great and user gets disconnected with the value set but when the user logins next time, he is able to login again and use the same amount of data again the count_in_mb counter gets the value 4080 instead of 6144 anything wrong with the query?
On Wed, Oct 15, 2014 at 9:35 PM, Russell Mike <radius.sir@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@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@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-... > > > > 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
- 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
Never Mind, Glad That worked for You. *Thanks / Prabhpal Singh* On Tue, Oct 21, 2014 at 1:10 PM, Abdullah <b.hawks123@gmail.com> wrote:
had to add the counter name to to authorize section works flawlessly Thanks for your help :)
On Thu, Oct 16, 2014 at 9:55 PM, Russell Mike <radius.sir@gmail.com> wrote:
it is due to check item, check item that deny on re login. it is something very little.
*Cross Check: *
1.) Write down your data limit as one 64 bit number. Or use python script to generate upper / lower number(s)
2.) Put lower 32bit number in *Octets attribute* and Uper 32bit number in *Gigawords attribute* as reply items. - Reply Item Used For Disconnection- *Already Working !!!!!!!*
3.) Create Max-All-MB RLM_SQL counter
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 WH$ }
4.) Add Max-All-MB attributes in dictionary file
nano /usr/share/freeradius/dictionary.chilli ATTRIBUTE Max-All-MB 3008 integer (if 3008 is already occupied use 3009 4009 etc..)
5.) Specify check item as "Max-All-MB" attributes - for example 6GB = 6144MB Check-Item Prevent Re Login *Not Working !!!!!!* 6.) User should be part of this Freeraidus Group (Profile), where you have added those check and reply attributes attached
*I suspect the problem in step 7. *
7.)
Add "chillispot_max_all_mb" in /etc/freeradius/radiusd.conf under instantiate section
instantiate { chillispot_max_all_mb more entries..
7a.) Add "chillispot_max_all_mb" /etc/freeradius/sites-available/default in authorize section
authorize { chillispot_max_all_mb more entries..
Keep on trying Would work.
Thanks RM--
On Thu, Oct 16, 2014 at 1:12 PM, Abdullah <b.hawks123@gmail.com> wrote:
yes have done both those steps cant really see what am i missing? :/ users gets disconnected alrighjt but doesnt prvent relogin
On Thu, Oct 16, 2014 at 12:11 PM, Russell Mike <radius.sir@gmail.com> wrote:
Hi Abdullah
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.
Have you done this ?
4.) Adding Max-All-MB in dictionary file “/usr/share/freeradius/dictionary.chilli” --> nano /usr/share/freeradius/dictionary.chilli A TTRIBUTE Max-All-MB 3080 integer
5.) Specify Check Attributes (check-itmes) Max-All-MB := 6144
Thanks
On Wed, Oct 15, 2014 at 6:58 PM, Abdullah <b.hawks123@gmail.com> wrote:
ok the counter works great and user gets disconnected with the value set but when the user logins next time, he is able to login again and use the same amount of data again the count_in_mb counter gets the value 4080 instead of 6144 anything wrong with the query?
On Wed, Oct 15, 2014 at 9:35 PM, Russell Mike <radius.sir@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@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@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-... >> >> >> >> 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 >
- 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
sorry to bother again, there is another issue i just noticed Setting up qouta of lets say 5GB A user downloads 2 GB and disconnects When he logins again, he should disconnect after 3GB but he doesnt get disconnected rather he gets disconnected after 5Gb I checked accounting and for every login a new session is saved and it does not checks past downloaded volume. How can i solve this problem? Thanks On Wed, Oct 22, 2014 at 2:44 PM, Russell Mike <radius.sir@gmail.com> wrote:
Never Mind, Glad That worked for You. *Thanks / Prabhpal Singh*
On Tue, Oct 21, 2014 at 1:10 PM, Abdullah <b.hawks123@gmail.com> wrote:
had to add the counter name to to authorize section works flawlessly Thanks for your help :)
On Thu, Oct 16, 2014 at 9:55 PM, Russell Mike <radius.sir@gmail.com> wrote:
it is due to check item, check item that deny on re login. it is something very little.
*Cross Check: *
1.) Write down your data limit as one 64 bit number. Or use python script to generate upper / lower number(s)
2.) Put lower 32bit number in *Octets attribute* and Uper 32bit number in *Gigawords attribute* as reply items. - Reply Item Used For Disconnection- *Already Working !!!!!!!*
3.) Create Max-All-MB RLM_SQL counter
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 WH$ }
4.) Add Max-All-MB attributes in dictionary file
nano /usr/share/freeradius/dictionary.chilli ATTRIBUTE Max-All-MB 3008 integer (if 3008 is already occupied use 3009 4009 etc..)
5.) Specify check item as "Max-All-MB" attributes - for example 6GB = 6144MB Check-Item Prevent Re Login *Not Working !!!!!!* 6.) User should be part of this Freeraidus Group (Profile), where you have added those check and reply attributes attached
*I suspect the problem in step 7. *
7.)
Add "chillispot_max_all_mb" in /etc/freeradius/radiusd.conf under instantiate section
instantiate { chillispot_max_all_mb more entries..
7a.) Add "chillispot_max_all_mb" /etc/freeradius/sites-available/default in authorize section
authorize { chillispot_max_all_mb more entries..
Keep on trying Would work.
Thanks RM--
On Thu, Oct 16, 2014 at 1:12 PM, Abdullah <b.hawks123@gmail.com> wrote:
yes have done both those steps cant really see what am i missing? :/ users gets disconnected alrighjt but doesnt prvent relogin
On Thu, Oct 16, 2014 at 12:11 PM, Russell Mike <radius.sir@gmail.com> wrote:
Hi Abdullah
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.
Have you done this ?
4.) Adding Max-All-MB in dictionary file “/usr/share/freeradius/dictionary.chilli” --> nano /usr/share/freeradius/dictionary.chilli A TTRIBUTE Max-All-MB 3080 integer
5.) Specify Check Attributes (check-itmes) Max-All-MB := 6144
Thanks
On Wed, Oct 15, 2014 at 6:58 PM, Abdullah <b.hawks123@gmail.com> wrote:
ok the counter works great and user gets disconnected with the value set but when the user logins next time, he is able to login again and use the same amount of data again the count_in_mb counter gets the value 4080 instead of 6144 anything wrong with the query?
On Wed, Oct 15, 2014 at 9:35 PM, Russell Mike <radius.sir@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@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@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-... >>> >>> >>> >>> 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 >> > > > - > 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
Abdullah wrote:
sorry to bother again, there is another issue i just noticed Setting up qouta of lets say 5GB A user downloads 2 GB and disconnects When he logins again, he should disconnect after 3GB but he doesnt get disconnected rather he gets disconnected after 5Gb
There are a few reasons why this happens. 1) you're always setting a 5G quota, and not checking the used quota 2) the used quota never gets updated
I checked accounting and for every login a new session is saved and it does not checks past downloaded volume. How can i solve this problem?
The sqlcounter module *should* check for past downloaded volume. However, this requires the NAS to send Accounting-Request packets, so that FreeRADIUS knows the user has downloaded data. As always, run the server in debugging mode to see what's happening. There are a lot of pieces involved, and they all need to work. We can't debug things remotely if you just say "it doesn't work". We need the debug output to know more. Alan DeKok.
Yes, please check as Alan advised. On Mon, Oct 27, 2014 at 2:32 PM, Alan DeKok <aland@deployingradius.com> wrote:
Abdullah wrote:
sorry to bother again, there is another issue i just noticed Setting up qouta of lets say 5GB A user downloads 2 GB and disconnects When he logins again, he should disconnect after 3GB but he doesnt get disconnected rather he gets disconnected after 5Gb
There are a few reasons why this happens.
1) you're always setting a 5G quota, and not checking the used quota
2) the used quota never gets updated
I checked accounting and for every login a new session is saved and it does not checks past downloaded volume. How can i solve this problem?
The sqlcounter module *should* check for past downloaded volume. However, this requires the NAS to send Accounting-Request packets, so that FreeRADIUS knows the user has downloaded data.
As always, run the server in debugging mode to see what's happening. There are a lot of pieces involved, and they all need to work.
We can't debug things remotely if you just say "it doesn't work". We need the debug output to know more.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
already did in coova dictionary the counter doest even work for 2GB in that case On Wed, Oct 15, 2014 at 6: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
participants (4)
-
Abdullah -
Alan DeKok -
johan firdianto -
Russell Mike