Hi! Herwin It works and thanks for your great help! BR! Chen Jiang Microshield Technology Co., Ltd å京å¸æµ·æ·åºè¥¿ä¸ç¯åè·¯50å·è±ªæ大å¦C2座18-19å± 100048 (86)10-88518768 (86)18612696123 [1]chenjiang@microshield.com.cn åå§é®ä»¶ å件人: Herwin Weststrate<herwin@quarantainenet.nl> æ¶ä»¶äºº: FreeRadius users mailing list<freeradius-users@lists.freeradius.org> åéæ¶é´: 2015å¹´3æ19æ¥(å¨å)â18:50 主é¢: Re: Traffic Volume Limit per Month cannot exceed 4Gbytes On 19-03-15 11:40, chenjiang wrote:
Hi! Experts
I want to achieve user traffic volume limit per month, but found there is a limit for user traffic to exceed 4Gbytes.
Below is my DB structure, you could see the "Max-Monthly-Trafficâ groupcheck attribute is 10Gbytes and it type is âvarchar", but it seems system deal it like a âinteger" type, so it cannot exceed 4Gbytes.
mysql> select * from radgroupcheck;
+----+--------------------+-----------------------+----+------------+ | id | groupname | attribute | op | value | +----+--------------------+-----------------------+----+------------+ | 25 | group2 | Max-Monthly-Traffic | := | 10737418240| +----+--------------------+-----------------------+----+------------+
3 rows in set (0.00 sec)
In FreeRADIUS debug mode, we could see that the rlm_sqlcounter âcheck_itemâ is always warpped in 4294967296 just like below:
[monthlytrafficcounter]
expand: %{sql:SELECT SUM(acctinputoctets+acctoutputoctets) FROM radacct WHERE username='lichan' AND UNIX_TIMESTAMP(acctstarttime) > '1425139200'} -> 7250810110
Change the last query to "SUM(...)/1024", divide the value in radgroupcheck by 1024 as well. This way it's less accurate, but that wouldn't matter much when comparing these kind of values. -- Herwin Weststrate - List info/subscribe/unsubscribe? See [2]http://www.freeradius.org/list/users.htm l References 1. mailto:chenjiang@microshield.com.cn 2. http://www.freeradius.org/list/users.html