[Chilli] higher data volume support

Russell Mike radius.sir at gmail.com
Mon Oct 21 08:58:30 UTC 2013


Dear Chilli List

After working for many weeks, still unable to use gigawords attributes to
control more than 4GB, moreover, i am unable to understand the problem.
here is what i did, someone please help to detect the error.

*Current Status:* it is woking setup up to 3.9GB
*Problem:* Counter Rolls on 4GB, need higher data volume support


*1.) COUNTERS:*

sqlcounter    lower32_bitcounter {
              counter-name = Total-Max-Octets
              check-name = ChilliSpot-Max-Total-Octets
              reply-name = ChilliSpot-Max-Total-Octets
              sqlmod-inst = sql
              key = User-Name
              reset = never
              cache-size = 5000
              query = "SELECT (SUM(AcctInputOctets) +
SUM(AcctOutputOctets)) FROM radacct WHERE UserName='%{%k}'"


sqlcounter    uper32_bitcounter {
              counter-name = Total-Max-Octets
              check-name = ChilliSpot-Max-Total-Gigawords
              reply-name = ChilliSpot-Max-Total-Gigawords
              sqlmod-inst = sql
              key = User-Name
              reset = never
              cache-size = 5000
              query = "SELECT (SUM(AcctInputOctets) +
SUM(AcctOutputOctets)) FROM radacct WHERE UserName='%{%k}'"



*2.)  AcctInputOctects & AcctOutputOctects colons are "bigint" (64bit)*


mysql> desc radacct;
+----------------------+-------------+------+-----+---------------------+----------------+
| Field                | Type        | Null | Key | Default             |
Extra          |
+----------------------+-------------+------+-----+---------------------+----------------+

| AcctInputOctets      | *bigint(20)*  | YES  |     | NULL                |
              |
| AcctOutputOctets    | *bigint(20*)  | YES  |     | NULL                |
              |




*3.) Radius is alright configured for lower32_bitcounter
& uper32_bitcounter in following section*

authorize {

instantiate {


*Check Items*
ChilliSpot-Max-Total-Octets = 1073741824          (Bytes)
ChilliSpot-Max-Total-Gigawords = 8589934592    (Bits)


*Reply Items:*
Acct-Interim-Interval
ChilliSpot-Max-Total-Octets = 1073741824          (Bytes)
ChilliSpot-Max-Total-Gigawords = 8589934592     (Bits)


5.) I start radius in debug mode and when a user attempts login. The max
number counter read is 4187593113 (3.9GB) where i have defined the
following "8589934592" (8GB in bits) in the profile attribute as above.


i need help to define check & reply items.


Thanks everyone !
RM --
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.coova.org/pipermail/chilli/attachments/20131021/b6e0ad3e/attachment.html>


More information about the Chilli mailing list