
我已將此區塊新增至 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
然後添加monthlytrafficcounter
到authorize
/etc/freeradius/sites-enabled/default
但這不起作用
Max-Monthly-Traffic
在 MySQL 表中定義,radgroupcheck
並將使用者新增至群組中radusergroup
使用者雖然達到了流量限制,但仍可以被FreeRadius授權