我已经将这个块添加到了radiusd.conf
sqlcounter monthlytrafficcounter {
vcounter-name = Monthly-Traffic
check-name = Max-Monthly-Traffic
reply-name = Monthly-Traffic-LIMIT
sqlmod-inst = SQL
key = User-Name
reset = monthly
query = "SELECT SUM(acctinputoctets + acctoutputoctets) FROM radacct WHERE UserName='%{%k}' AND UNIX_TIMESTAMP(AcctStartTime) > '%b'"
}并添加了双字词典
ATTRIBUTE Max-Monthly-Traffic 3003 integer
ATTRIBUTE Monthly-Traffic-Limit 3004 integer然后在/etc/freeradius/sites-enabled/default中将monthlytrafficcounter添加到authorize
但它不起作用
Max-Monthly-Traffic在MySQL表radgroupcheck中定义,用户已添加到radusergroup中的组中
虽然用户已经达到流量限制,但仍然可以通过FreeRadius:http://i.stack.imgur.com/RIVsZ.jpg进行授权
发布于 2016-08-29 04:34:31
尝试将您的radiusd.conf块移动到sql/mysql/counter.conf
https://stackoverflow.com/questions/36774470
复制相似问题