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默認(rèn)讀取數(shù)據(jù)庫列表usergroup。但FreeRadius新版本數(shù)據(jù)庫列表文件為：radusergroup.
處理過程
進(jìn)入修改radius/config-db.php數(shù)據(jù)庫列表usergroup 為radusergroup即可。
建議/總結(jié)
無