FreeRADIUS 报错：'%b' Invalid variable expansion

Question

在FreeRADIUS 3.0.1 中配置月流量限制功能，在/etc/raddb/mods-available/sqlcounter中加入： 

sqlcounter monthlytrafficcounter { 

        sql_module_instance = sql 

        counter_name = Monthly-Traffic 

        check_name = Max-Monthly-Traffic

        reply_name = Monthly-Traffic-Limit

        key = User-Name

        reset = monthly

        query = "SELECT SUM(acctinputoctets + acctoutputoctets) DIV 1024 FROM radacct WHERE UserName='%{${key}}' AND UNIX_TIMESTAMP(AcctStartTime) > '%b'" 

} 

报错：'%b' Invalid variable expansion 请指教！@AidenZhang

Answer 1

那我该怎么解决这个问题？我可以在哪里添加这个%b的定义吗？

Answer 2

回复
去src/main/xlat.c文件里面添加你的%b定义，可以参考其他的上面列举的变量实现

Answer 3

回复
这样要重新编译了吧？

Answer 4

%b这个变量没有在FreeRADIUS里面定义，参考https://github.com/FreeRADIUS/freeradius-server/blob/0a0e2076b0d1f7f1e9eae80e6437b71493b82672/doc/configuration/variables.rst

Variable	Description	Proper Equivalent
%a	Protocol (SLIP/PPP)	%{Framed-Protocol}
%c	Callback-Number	%{Callback-Number}
%d	request day (DD)
%f	Framed IP address	%{Framed-IP-Address}
%i	Calling Station ID	%{Calling-Station-Id}
%l	request timestamp
%m	request month (MM)
%n	NAS IP address	%{NAS-IP-Address}
%p	Port number	%{NAS-Port}
%s	Speed (PW_CONNECT_INFO)	%{Connect-Info}
%t	request in ctime format
%u	User name	%{User-Name}
%A	radacct_dir	%{config:radacctdir}
%C	clientname
%D	request date (YYYYMMDD)
%G	request minute
%H	request hour
%I	request ID
%L	radlog_dir	%{config:logdir}
%M	MTU	%{Framed-MTU}
%R	radius_dir	%{config:raddbdir}
%S	request timestamp in SQL format
%T	request timestamp in database format
%U	Stripped User name	%{Stripped-User-Name}
%V	Request-Authenticator (Verified/None)
%v	Server Version
%Y	request year (YYYY)
%Z	All request attributes except password (must have a big buffer)