I have upgraded Zabbix-Server:
- Ubuntu 20.04.3 LTS
- dedicated to this task
- postgresql backend version 12.9
- python 3.8 (default package in Ubuntu 20.04)
I did:
- wget https://repo.zabbix.com/zabbix/5.4/u...u20.04_all.deb
- backup of Zabbix directories
- service zabbix-server stop
- dpkg -i zabbix-release_5.4-1+ubuntu20.04_all.deb
- apt update
- apt install --only-upgrade zabbix-server-pgsql zabbix-frontend-php zabbix-agent
- apt upgrade
- service zabbix-server start
I had overwritten my zabbix_server.conf but rescued the database password from the backup. Should I have recovered anything else? With diff I only see a lot of changes in the comments for zabbix_server.conf
After this I have a blank web front and a lot of errors in /var/log/apache/error.log
Searching the web and this forum for this problem I have found:
- not having python 3 might be a problem. But I have it installed.
- dbversion was not updated: done that manually from 5020000 to 5040000
But to no change.
What can I do next to figure this out?
- Ubuntu 20.04.3 LTS
- dedicated to this task
- postgresql backend version 12.9
- python 3.8 (default package in Ubuntu 20.04)
I did:
- wget https://repo.zabbix.com/zabbix/5.4/u...u20.04_all.deb
- backup of Zabbix directories
- service zabbix-server stop
- dpkg -i zabbix-release_5.4-1+ubuntu20.04_all.deb
- apt update
- apt install --only-upgrade zabbix-server-pgsql zabbix-frontend-php zabbix-agent
- apt upgrade
- service zabbix-server start
I had overwritten my zabbix_server.conf but rescued the database password from the backup. Should I have recovered anything else? With diff I only see a lot of changes in the comments for zabbix_server.conf
After this I have a blank web front and a lot of errors in /var/log/apache/error.log
Code:
[Thu Dec 30 11:34:18.335626 2021] [php7:notice] [pid 60201] [client 10.1.100.2:55962] PHP Notice: Undefined offset: 0 in /usr/share/zabbix/include/classes/api/services/CSettings.php on line 130, referer: http://10.1.11.242/zabbix/zabbix.php?action=charts.view&view_as=showgraph&fi lter_search_type=0&filter_hostids%5B%5D=10287&filt er_set=1
[Thu Dec 30 11:34:18.335642 2021] [php7:error] [pid 60201] [client 10.1.100.2:55962] PHP Fatal error: Uncaught TypeError: Return value of CSettings::getGlobal() must be of the type array, null returned in /usr/share/zabbix/include/classes/api/services/CSettings.php:130\nStack trace:\n#0 /usr/share/zabbix/include/classes/helpers/CSettingsHelper.php(98): CSettings->getGlobal()\n#1 /usr/share/zabbix/include/classes/helpers/CSettingsHelper.php(121): CSettingsHelper::loadParams()\n#2 /usr/share/zabbix/include/classes/core/CEncryptedCookieSession.php(33): CSettingsHelper::getGlobal()\n#3 /usr/share/zabbix/include/classes/core/ZBase.php(463): CEncryptedCookieSession->extractSessionId()\n#4 /usr/share/zabbix/include/classes/core/ZBase.php(186): ZBase->authenticateUser()\n#5 /usr/share/zabbix/include/config.inc.php(25): ZBase->run()\n#6 /usr/share/zabbix/chart2.php(22): require_once('/usr/share/zabb...')\n#7 {main}\n thrown in /usr/share/zabbix/include/classes/api/services/CSettings.php on line 130, referer: http://10.1.11.242/zabbix/zabbix.php?action=charts.view&view_as=showgraph&fi lter_search_type=0&filter_hostids%5B%5D=10287&filt er_set=1
[Thu Dec 30 11:34:18.336026 2021] [php7:warn] [pid 25404] [client 10.1.100.2:55964] PHP Warning: pg_query(): Query failed: ERROR: column c.dbversion_status does not exist\nLINE 1: ....x_frame_options,c.default_timezone,c.session_k ey,c.dbversio...\n ^ in /usr/share/zabbix/include/db.inc.php on line 248, referer: http://10.1.11.242/zabbix/zabbix.php?action=charts.view&view_as=showgraph&fi lter_search_type=0&filter_hostids%5B%5D=10287&filt er_set=1
[Thu Dec 30 11:34:18.336070 2021] [php7:notice] [pid 25404] [client 10.1.100.2:55964] PHP Notice: Undefined offset: 0 in /usr/share/zabbix/include/classes/api/services/CSettings.php on line 130, referer: http://10.1.11.242/zabbix/zabbix.php?action=charts.view&view_as=showgraph&fi lter_search_type=0&filter_hostids%5B%5D=10287&filt er_set=1
[Thu Dec 30 11:34:18.336098 2021] [php7:error] [pid 25404] [client 10.1.100.2:55964] PHP Fatal error: Uncaught TypeError: Return value of CSettings::getGlobal() must be of the type array, null returned in /usr/share/zabbix/include/classes/api/services/CSettings.php:130\nStack trace:\n#0 /usr/share/zabbix/include/classes/helpers/CSettingsHelper.php(98): CSettings->getGlobal()\n#1 /usr/share/zabbix/include/classes/helpers/CSettingsHelper.php(121): CSettingsHelper::loadParams()\n#2 /usr/share/zabbix/include/classes/core/CEncryptedCookieSession.php(33): CSettingsHelper::getGlobal()\n#3 /usr/share/zabbix/include/classes/core/ZBase.php(463): CEncryptedCookieSession->extractSessionId()\n#4 /usr/share/zabbix/include/classes/core/ZBase.php(186): ZBase->authenticateUser()\n#5 /usr/share/zabbix/include/config.inc.php(25): ZBase->run()\n#6 /usr/share/zabbix/chart2.php(22): require_once('/usr/share/zabb...')\n#7 {main}\n thrown in /usr/share/zabbix/include/classes/api/services/CSettings.php on line 130, referer: http://10.1.11.242/zabbix/zabbix.php?action=charts.view&view_as=showgraph&fi lter_search_type=0&filter_hostids%5B%5D=10287&filt er_set=1
[Thu Dec 30 11:34:18.337635 2021] [php7:warn] [pid 56638] [client 10.1.100.2:55968] PHP Warning: pg_query(): Query failed: ERROR: column c.dbversion_status does not exist\nLINE 1: ....x_frame_options,c.default_timezone,c.session_k ey,c.dbversio...\n ^ in /usr/share/zabbix/include/db.inc.php on line 248, referer: http://10.1.11.242/zabbix/zabbix.php?action=charts.view&view_as=showgraph&fi lter_search_type=0&filter_hostids%5B%5D=10287&filt er_set=1
[Thu Dec 30 11:34:18.337682 2021] [php7:notice] [pid 56638] [client 10.1.100.2:55968] PHP Notice: Undefined offset: 0 in /usr/share/zabbix/include/classes/api/services/CSettings.php on line 130, referer: http://10.1.11.242/zabbix/zabbix.php?action=charts.view&view_as=showgraph&fi lter_search_type=0&filter_hostids%5B%5D=10287&filt er_set=1
[Thu Dec 30 11:34:18.337709 2021] [php7:error] [pid 56638] [client 10.1.100.2:55968] PHP Fatal error: Uncaught TypeError: Return value of CSettings::getGlobal() must be of the type array, null returned in /usr/share/zabbix/include/classes/api/services/CSettings.php:130\nStack trace:\n#0 /usr/share/zabbix/include/classes/helpers/CSettingsHelper.php(98): CSettings->getGlobal()\n#1 /usr/share/zabbix/include/classes/helpers/CSettingsHelper.php(121): CSettingsHelper::loadParams()\n#2 /usr/share/zabbix/include/classes/core/CEncryptedCookieSession.php(33): CSettingsHelper::getGlobal()\n#3 /usr/share/zabbix/include/classes/core/ZBase.php(463): CEncryptedCookieSession->extractSessionId()\n#4 /usr/share/zabbix/include/classes/core/ZBase.php(186): ZBase->authenticateUser()\n#5 /usr/share/zabbix/include/config.inc.php(25): ZBase->run()\n#6 /usr/share/zabbix/chart2.php(22): require_once('/usr/share/zabb...')\n#7 {main}\n thrown in /usr/share/zabbix/include/classes/api/services/CSettings.php on line 130, referer: http://10.1.11.242/zabbix/zabbix.php?action=charts.view&view_as=showgraph&fi lter_search_type=0&filter_hostids%5B%5D=10287&filt er_set=1
[Thu Dec 30 11:34:18.339812 2021] [php7:warn] [pid 25402] [client 10.1.100.2:55966] PHP Warning: pg_query(): Query failed: ERROR: column c.dbversion_status does not exist\nLINE 1: ....x_frame_options,c.default_timezone,c.session_k ey,c.dbversio...\n ^ in /usr/share/zabbix/include/db.inc.php on line 248, referer: http://10.1.11.242/zabbix/zabbix.php?action=charts.view&view_as=showgraph&fi lter_search_type=0&filter_hostids%5B%5D=10287&filt er_set=1
[Thu Dec 30 11:34:18.339831 2021] [php7:warn] [pid 25414] [client 10.1.100.2:55970] PHP Warning: pg_query(): Query failed: ERROR: column c.dbversion_status does not exist\nLINE 1: ....x_frame_options,c.default_timezone,c.session_k ey,c.dbversio...\n ^ in /usr/share/zabbix/include/db.inc.php on line 248, referer: http://10.1.11.242/zabbix/zabbix.php?action=charts.view&view_as=showgraph&fi lter_search_type=0&filter_hostids%5B%5D=10287&filt er_set=1
[Thu Dec 30 11:34:18.339850 2021] [php7:notice] [pid 25402] [client 10.1.100.2:55966] PHP Notice: Undefined offset: 0 in /usr/share/zabbix/include/classes/api/services/CSettings.php on line 130, referer: http://10.1.11.242/zabbix/zabbix.php?action=charts.view&view_as=showgraph&fi lter_search_type=0&filter_hostids%5B%5D=10287&filt er_set=1
[Thu Dec 30 11:34:18.339859 2021] [php7:notice] [pid 25414] [client 10.1.100.2:55970] PHP Notice: Undefined offset: 0 in /usr/share/zabbix/include/classes/api/services/CSettings.php on line 130, referer: http://10.1.11.242/zabbix/zabbix.php?action=charts.view&view_as=showgraph&fi lter_search_type=0&filter_hostids%5B%5D=10287&filt er_set=1
[Thu Dec 30 11:34:18.339875 2021] [php7:error] [pid 25402] [client 10.1.100.2:55966] PHP Fatal error: Uncaught TypeError: Return value of CSettings::getGlobal() must be of the type array, null returned in /usr/share/zabbix/include/classes/api/services/CSettings.php:130\nStack trace:\n#0 /usr/share/zabbix/include/classes/helpers/CSettingsHelper.php(98): CSettings->getGlobal()\n#1 /usr/share/zabbix/include/classes/helpers/CSettingsHelper.php(121): CSettingsHelper::loadParams()\n#2 /usr/share/zabbix/include/classes/core/CEncryptedCookieSession.php(33): CSettingsHelper::getGlobal()\n#3 /usr/share/zabbix/include/classes/core/ZBase.php(463): CEncryptedCookieSession->extractSessionId()\n#4 /usr/share/zabbix/include/classes/core/ZBase.php(186): ZBase->authenticateUser()\n#5 /usr/share/zabbix/include/config.inc.php(25): ZBase->run()\n#6 /usr/share/zabbix/chart2.php(22): require_once('/usr/share/zabb...')\n#7 {main}\n thrown in /usr/share/zabbix/include/classes/api/services/CSettings.php on line 130, referer: http://10.1.11.242/zabbix/zabbix.php?action=charts.view&view_as=showgraph&fi lter_search_type=0&filter_hostids%5B%5D=10287&filt er_set=1
[Thu Dec 30 11:34:18.339876 2021] [php7:error] [pid 25414] [client 10.1.100.2:55970] PHP Fatal error: Uncaught TypeError: Return value of CSettings::getGlobal() must be of the type array, null returned in /usr/share/zabbix/include/classes/api/services/CSettings.php:130\nStack trace:\n#0 /usr/share/zabbix/include/classes/helpers/CSettingsHelper.php(98): CSettings->getGlobal()\n#1 /usr/share/zabbix/include/classes/helpers/CSettingsHelper.php(121): CSettingsHelper::loadParams()\n#2 /usr/share/zabbix/include/classes/core/CEncryptedCookieSession.php(33): CSettingsHelper::getGlobal()\n#3 /usr/share/zabbix/include/classes/core/ZBase.php(463): CEncryptedCookieSession->extractSessionId()\n#4 /usr/share/zabbix/include/classes/core/ZBase.php(186): ZBase->authenticateUser()\n#5 /usr/share/zabbix/include/config.inc.php(25): ZBase->run()\n#6 /usr/share/zabbix/chart2.php(22): require_once('/usr/share/zabb...')\n#7 {main}\n thrown in /usr/share/zabbix/include/classes/api/services/CSettings.php on line 130, referer: http://10.1.11.242/zabbix/zabbix.php?action=charts.view&view_as=showgraph&fi lter_search_type=0&filter_hostids%5B%5D=10287&filt er_set=1
[Thu Dec 30 11:34:18.342476 2021] [php7:warn] [pid 54593] [client 10.1.100.2:55972] PHP Warning: pg_query(): Query failed: ERROR: column c.dbversion_status does not exist\nLINE 1: ....x_frame_options,c.default_timezone,c.session_k ey,c.dbversio...\n ^ in /usr/share/zabbix/include/db.inc.php on line 248, referer: http://10.1.11.242/zabbix/zabbix.php?action=charts.view&view_as=showgraph&fi lter_search_type=0&filter_hostids%5B%5D=10287&filt er_set=1
[Thu Dec 30 11:34:18.342506 2021] [php7:notice] [pid 54593] [client 10.1.100.2:55972] PHP Notice: Undefined offset: 0 in /usr/share/zabbix/include/classes/api/services/CSettings.php on line 130, referer: http://10.1.11.242/zabbix/zabbix.php?action=charts.view&view_as=showgraph&fi lter_search_type=0&filter_hostids%5B%5D=10287&filt er_set=1
[Thu Dec 30 11:34:18.342523 2021] [php7:error] [pid 54593] [client 10.1.100.2:55972] PHP Fatal error: Uncaught TypeError: Return value of CSettings::getGlobal() must be of the type array, null returned in /usr/share/zabbix/include/classes/api/services/CSettings.php:130\nStack trace:\n#0 /usr/share/zabbix/include/classes/helpers/CSettingsHelper.php(98): CSettings->getGlobal()\n#1 /usr/share/zabbix/include/classes/helpers/CSettingsHelper.php(121): CSettingsHelper::loadParams()\n#2 /usr/share/zabbix/include/classes/core/CEncryptedCookieSession.php(33): CSettingsHelper::getGlobal()\n#3 /usr/share/zabbix/include/classes/core/ZBase.php(463): CEncryptedCookieSession->extractSessionId()\n#4 /usr/share/zabbix/include/classes/core/ZBase.php(186): ZBase->authenticateUser()\n#5 /usr/share/zabbix/include/config.inc.php(25): ZBase->run()\n#6 /usr/share/zabbix/chart2.php(22): require_once('/usr/share/zabb...')\n#7 {main}\n thrown in /usr/share/zabbix/include/classes/api/services/CSettings.php on line 130, referer: http://10.1.11.242/zabbix/zabbix.php?action=charts.view&view_as=showgraph&fi lter_search_type=0&filter_hostids%5B%5D=10287&filt er_set=1
Searching the web and this forum for this problem I have found:
- not having python 3 might be a problem. But I have it installed.
- dbversion was not updated: done that manually from 5020000 to 5040000
But to no change.
What can I do next to figure this out?