fresh installation of latest zambix on ubuntu fails on Admin login
We installed a completelly new Zambix installation on ubuntu, mysql, apache. The login screen pops up, but on login of Admin with the default password, we get a
"
medzabbix can't currently handle this request.
HTTP ERROR 500"
message. The Apache2 error log shows :
"[Mon Dec 04 11:11:22.744250 2023] [php:warn] [pid 2071] [client 132.72.79.26:51745] PHP Warning: Error in query [SELECT type FROM role WHERE roleid='3'] [Table 'zabbix.role' doesn't exist] in /usr/share/zabbix/include/db.inc.php on line 248, referer: http://medzabbix/zabbix/index.php
[Mon Dec 04 11:11:22.744354 2023] [php:warn] [pid 2071] [client 132.72.79.26:51745] PHP Warning: Undefined array key 0 in /usr/share/zabbix/include/classes/api/services/CUser.php on line 2137, referer: http://medzabbix/zabbix/index.php
[Mon Dec 04 11:11:22.816401 2023] [php:warn] [pid 2071] [client 132.72.79.26:51745] PHP Warning: Error in query [SELECT DISTINCT r.roleid,r.name,r.type FROM role r,users u WHERE r.roleid='3' AND r.roleid=u.roleid AND u.userid=1] [Table 'zabbix.role' doesn't exist] in /usr/share/zabbix/include/db.inc.php on line 248, referer: http://medzabbix/zabbix/index.php
[Mon Dec 04 11:11:22.816634 2023] [php:error] [pid 2071] [client 132.72.79.26:51745] PHP Fatal error: Uncaught Exception: Specified role was not found. in /usr/share/zabbix/include/classes/helpers/CRoleHelper.php:199\nStack trace:\n#0 /usr/share/zabbix/include/classes/helpers/CRoleHelper.php(140): CRoleHelper::loadRoleRules()\n#1 /usr/share/zabbix/include/classes/user/CWebUser.php(145): CRoleHelper::checkAccess()\n#2 /usr/share/zabbix/include/classes/helpers/CMenuHelper.php(33): CWebUser::checkAccess()\n#3 /usr/share/zabbix/include/classes/helpers/CMenuHelper.php(496): CMenuHelper::getMainMenu()\n#4 /usr/share/zabbix/include/classes/helpers/CMenuHelper.php(523): CMenuHelper::getFirstMenuItem()\n#5 /usr/share/zabbix/index.php(80): CMenuHelper::getFirstUrl()\n#6 {main}\n thrown in /usr/share/zabbix/include/classes/helpers/CRoleHelper.php on line 199, referer: http://medzabbix/zabbix/index.php
"
It tells me the table "role" does not exist. But when accessing MYSQL manually, also with the Zambix user, the query "SELECT DISTINCT r.roleid,r.name,r.type FROM role r,users u WHERE r.roleid='3' AND r.roleid=u.roleid AND u.userid=1"
works fine. I first installed MYSQL on an external Windows server, and later on on the local Ubuntu server. The messages are the same !
Latest Zabbix 6.4, MYSQL 8, PHP 8, Ubuntu 22.04 .
Ideas ?
David
"
medzabbix can't currently handle this request.
HTTP ERROR 500"
message. The Apache2 error log shows :
"[Mon Dec 04 11:11:22.744250 2023] [php:warn] [pid 2071] [client 132.72.79.26:51745] PHP Warning: Error in query [SELECT type FROM role WHERE roleid='3'] [Table 'zabbix.role' doesn't exist] in /usr/share/zabbix/include/db.inc.php on line 248, referer: http://medzabbix/zabbix/index.php
[Mon Dec 04 11:11:22.744354 2023] [php:warn] [pid 2071] [client 132.72.79.26:51745] PHP Warning: Undefined array key 0 in /usr/share/zabbix/include/classes/api/services/CUser.php on line 2137, referer: http://medzabbix/zabbix/index.php
[Mon Dec 04 11:11:22.816401 2023] [php:warn] [pid 2071] [client 132.72.79.26:51745] PHP Warning: Error in query [SELECT DISTINCT r.roleid,r.name,r.type FROM role r,users u WHERE r.roleid='3' AND r.roleid=u.roleid AND u.userid=1] [Table 'zabbix.role' doesn't exist] in /usr/share/zabbix/include/db.inc.php on line 248, referer: http://medzabbix/zabbix/index.php
[Mon Dec 04 11:11:22.816634 2023] [php:error] [pid 2071] [client 132.72.79.26:51745] PHP Fatal error: Uncaught Exception: Specified role was not found. in /usr/share/zabbix/include/classes/helpers/CRoleHelper.php:199\nStack trace:\n#0 /usr/share/zabbix/include/classes/helpers/CRoleHelper.php(140): CRoleHelper::loadRoleRules()\n#1 /usr/share/zabbix/include/classes/user/CWebUser.php(145): CRoleHelper::checkAccess()\n#2 /usr/share/zabbix/include/classes/helpers/CMenuHelper.php(33): CWebUser::checkAccess()\n#3 /usr/share/zabbix/include/classes/helpers/CMenuHelper.php(496): CMenuHelper::getMainMenu()\n#4 /usr/share/zabbix/include/classes/helpers/CMenuHelper.php(523): CMenuHelper::getFirstMenuItem()\n#5 /usr/share/zabbix/index.php(80): CMenuHelper::getFirstUrl()\n#6 {main}\n thrown in /usr/share/zabbix/include/classes/helpers/CRoleHelper.php on line 199, referer: http://medzabbix/zabbix/index.php
"
It tells me the table "role" does not exist. But when accessing MYSQL manually, also with the Zambix user, the query "SELECT DISTINCT r.roleid,r.name,r.type FROM role r,users u WHERE r.roleid='3' AND r.roleid=u.roleid AND u.userid=1"
works fine. I first installed MYSQL on an external Windows server, and later on on the local Ubuntu server. The messages are the same !
Latest Zabbix 6.4, MYSQL 8, PHP 8, Ubuntu 22.04 .
Ideas ?
David
Comment