Hi Herwin, mysql> select * from radgroupcheck; +----+---------------------------+---------------------+----+--------------+ | id | groupname | attribute | op | value | +----+---------------------------+---------------------+----+--------------+ | 1 | daloRADIUS-Disabled-Users | Auth-Type | := | Reject | | 25 | testing | Mikrotik-Rate-Limit | := | 1024k/1024k | | 26 | testing | Max-Data | := | 5368709120 | | 22 | admins | Mikrotik-Rate-Limit | := | 256k/256k | | 16 | power | Max-Data | := | 107374182400 | *| 15 | premium | Max-Data | := | 53687091200 |* | 14 | starter | Max-Data | := | 32212254720 | | 13 | admins | Max-Data | := | 1073741824 | +----+---------------------------+---------------------+----+--------------+ 8 rows in set (0.00 sec) mysql> desc radgroupcheck; +-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ | id | int(11) unsigned | NO | PRI | NULL | auto_increment | | groupname | varchar(64) | NO | MUL | | | | attribute | varchar(64) | NO | | | | | op | char(2) | NO | | == | | *| value | varchar(253) | NO | | | |* +-----------+------------------+------+-----+---------+----------------+ 5 rows in set (0.00 sec) I dont know where i have to convert into 64 bit integer. It looks like the datatype is varchar. Regards, Randeep On Fri, Jul 3, 2015 at 5:39 PM, Herwin Weststrate <herwin@quarantainenet.nl> wrote:
On 03-07-15 12:59, Randeep wrote:
Hi Newton,
We are using this parameter only for a "if" condition check. We are not sending this value to Mikrotik.
If the SUM(acctinputoctets)+SUM(acctoutputoctets) > Max-Data, we are sending the Mikrotik-Rate-Limit to the Mikrotik to reduce the speed.
But the issue is We are not able to set more than 4G to Max-Data.
Is Max-Data defined as an integer? If so, it is a 32bit unsigned integer, and 4G is the maximum value that fits in there. Change it to a integer64, or perform some magic with splitting it into two values with bitshifting operations. The first option is probably the easiest.
-- Herwin Weststrate
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Randeep Mob: +919447831699[kerala] Mob: +919880050349[B'lore] http://twitter.com/Randeeppr http://in.linkedin.com/in/randeeppr [image: --] Randeep Raman [image: http://]about.me/Randeeppr <http://about.me/Randeeppr>