Data limit

[Randeep]

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 at 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>