跳转到主要内容

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即可。

建议/总结

  无