Zabbix Server Upgrade from 6.4 to 7

[Lewis Wiltshire]

Having some issues updating DB for zabbix.

Everything else has updated fine but the DB is failing to update. Please see the Web GUI error below



Please can someone help

[Markku]

Hi, note that this error is from the frontend, not from Zabbix server service. You need to restart the zabbix-server service manually after upgrade. See zabbix_server.log for information about the startup and upgrade process completion.

Markku

[Lewis Wiltshire]

Hi, note that this error is from the frontend, not from Zabbix server service. You need to restart the zabbix-server service manually after upgrade. See zabbix_server.log for information about the startup and upgrade process completion.

Markku

I have rebooted the server and still get the same message.

[Lewis Wiltshire]

See the logs

[Jason]

That is saying your database isn't running. Take a look at postgres and see what is going on there.

[Lewis Wiltshire]

That is saying your database isn't running. Take a look at postgres and see what is going on there.

The database is running. We use a mysql database for the server. Do we need to change this? or update this?

[Markku]

The error message talks about port 5432, which is used for PostgreSQL. Please ensure that you are using the correct zabbix-server-mysql package, and not the zabbix-server-pgsql one, if you are using MySQL database.

Markku

[Lewis Wiltshire]

The error message talks about port 5432, which is used for PostgreSQL. Please ensure that you are using the correct zabbix-server-mysql package, and not the zabbix-server-pgsql one, if you are using MySQL database.

Markku

Hi,

The pgsql is not even installed?

[Markku]

sudo grep -v -E "^(#|$)" /etc/zabbix/zabbix_server.conf

Markku

[Lewis Wiltshire]

sudo grep -v -E "^(#|$)" /etc/zabbix/zabbix_server.conf

Markku

see attached

[Markku]

dpkg -l zabbix\*

Markku

[Lewis Wiltshire]

dpkg -l zabbix\*

Markku

see attached

[Markku]

What's your personal idea, why would your Zabbix server (zabbix-server-mysql) try to connect to PostgreSQL server port 5432, as you told us it was still doing after the server reboot?

Markku

[Lewis Wiltshire]

We have been trying to update from 6.4 to 7.0 LTS but then we got this when the update was complete.

[Markku]

sudo systemctl stop zabbix-server
sudo apt purge zabbix-server-mysql zabbix-server-pgsql
sudo apt install zabbix-server-mysql
sudo systemctl start zabbix-server

Markku