故障描述
daloradius安装后登陆查看用户。提示出下错误:
Users Listing +
Listing users in database
Database error
Error Message: DB Error: no such table
Debug info: SELECT distinct(radcheck.username),radcheck.value, radcheck.id,usergroup.groupname as groupname, radcheck.attribute, userinfo.firstname, userinfo.lastname FROM radcheck LEFT JOIN userinfo ON radcheck.username=userinfo.username LEFT JOIN usergroup ON radcheck.username=usergroup.username WHERE (Attribute LIKE ‘%-Password’) OR (Attribute=’Auth-Type’) GROUP BY UserName [nativecode=1146 ** Table 'radius.usergroup' doesn't exist]
故障分析
daloradius默认读取数据库列表usergroup。但FreeRadius新版本数据库列表文件为:radusergroup.
处理过程
进入修改radius/config-db.php数据库列表usergroup 为radusergroup即可。
建议/总结
无