跳转到主要内容

FAQ-daloradius无法显示用户列表

故障描述
  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即可。
建议/总结
  无