[Zabbix 5.2] Problem with database after upgrade

[lin]

Hi all,

I've problem with my Zabbix installation after upgrade from Zabbix 5.0 to 5.2. On the web interface I'm getting:

Database error: Access denied for user 'zabbix'@'localhost' (using password: YES)

In the /var/log/mysql/error.log I see this problem:

2020-10-29 14:37:45 241 [Warning] Access denied for user 'zabbix'@'localhost' (using password: YES)

In the /etc/zabbix/zabbix_server.conf I've following lines:

DBUser=zabbix
DBPassword=ZabbixPassword

When I'm trying run command mysql -u zabbix -p and insert same password as in zabbix_server.conf, I'm correctly logged in MySQL and I can, for example, show databases etc. Between the upgrade was Zabbix working fine. Any idea what is wrong?

systemctl status zabbix-server

root@zabbix:~# systemctl status zabbix-server
● zabbix-server.service - Zabbix Server
Loaded: loaded (/lib/systemd/system/zabbix-server.service; enabled; vendor preset: enabled)
Active: active (running) since Thu 2020-10-29 13:48:07 CET; 1h 0min ago
Process: 570 ExecStart=/usr/sbin/zabbix_server -c $CONFFILE (code=exited, status=0/SUCCESS)
Main PID: 582 (zabbix_server)
Tasks: 38 (limit: 4915)
Memory: 130.9M
CGroup: /system.slice/zabbix-server.service
├─582 /usr/sbin/zabbix_server -c /etc/zabbix/zabbix_server.conf
├─624 /usr/sbin/zabbix_server: configuration syncer [synced configuration in 0.109717 sec, idle 60 sec]
├─625 /usr/sbin/zabbix_server: housekeeper [deleted 21402 hist/trends, 0 items/triggers, 0 events, 0 sessions, 0 alarms, 0 audit items, 0 records in 1.328710 sec, idle for 1 hour(s)]
├─626 /usr/sbin/zabbix_server: timer #1 [updated 0 hosts, suppressed 0 events in 0.000572 sec, idle 59 sec]
├─627 /usr/sbin/zabbix_server: http poller #1 [got 0 values in 0.000956 sec, idle 5 sec]
├─628 /usr/sbin/zabbix_server: discoverer #1 [processed 0 rules in 0.000648 sec, idle 60 sec]
├─630 /usr/sbin/zabbix_server: history syncer #1 [processed 0 values, 0 triggers in 0.000091 sec, idle 1 sec]
├─631 /usr/sbin/zabbix_server: history syncer #2 [processed 0 values, 0 triggers in 0.000092 sec, idle 1 sec]
├─633 /usr/sbin/zabbix_server: history syncer #3 [processed 0 values, 0 triggers in 0.000085 sec, idle 1 sec]
├─634 /usr/sbin/zabbix_server: history syncer #4 [processed 3 values, 3 triggers in 0.003763 sec, idle 1 sec]
├─635 /usr/sbin/zabbix_server: escalator #1 [processed 0 escalations in 0.001087 sec, idle 3 sec]
├─637 /usr/sbin/zabbix_server: proxy poller #1 [exchanged data with 2 proxies in 0.170609 sec, exchanging data]
├─638 /usr/sbin/zabbix_server: self-monitoring [processed data in 0.000031 sec, idle 1 sec]
├─640 /usr/sbin/zabbix_server: task manager [processed 0 task(s) in 0.033642 sec, idle 5 sec]
├─642 /usr/sbin/zabbix_server: poller #1 [got 0 values in 0.000019 sec, idle 1 sec]
├─643 /usr/sbin/zabbix_server: poller #2 [got 0 values in 0.000063 sec, idle 1 sec]
├─645 /usr/sbin/zabbix_server: poller #3 [got 0 values in 0.000032 sec, idle 1 sec]
├─647 /usr/sbin/zabbix_server: poller #4 [got 0 values in 0.000072 sec, idle 1 sec]
├─648 /usr/sbin/zabbix_server: poller #5 [got 2 values in 0.001279 sec, idle 1 sec]
├─650 /usr/sbin/zabbix_server: unreachable poller #1 [got 0 values in 0.000042 sec, idle 5 sec]
├─652 /usr/sbin/zabbix_server: trapper #1 [processed data in 0.002255 sec, waiting for connection]
├─653 /usr/sbin/zabbix_server: trapper #2 [processed data in 0.001723 sec, waiting for connection]
├─656 /usr/sbin/zabbix_server: trapper #3 [processed data in 0.002366 sec, waiting for connection]
├─657 /usr/sbin/zabbix_server: trapper #4 [processed data in 0.001966 sec, waiting for connection]
├─658 /usr/sbin/zabbix_server: trapper #5 [processed data in 0.002309 sec, waiting for connection]
├─660 /usr/sbin/zabbix_server: icmp pinger #1 [got 3 values in 2.037507 sec, idle 5 sec]
├─662 /usr/sbin/zabbix_server: alert manager #1 [sent 0, failed 0 alerts, idle 5.002821 sec during 5.002909 sec]
├─665 /usr/sbin/zabbix_server: alerter #1 started
├─667 /usr/sbin/zabbix_server: alerter #2 started
├─668 /usr/sbin/zabbix_server: alerter #3 started
├─670 /usr/sbin/zabbix_server: preprocessing manager #1 [queued 0, processed 362 values, idle 5.395213 sec during 5.401211 sec]
├─672 /usr/sbin/zabbix_server: preprocessing worker #1 started
├─674 /usr/sbin/zabbix_server: preprocessing worker #2 started
├─675 /usr/sbin/zabbix_server: preprocessing worker #3 started
├─676 /usr/sbin/zabbix_server: lld manager #1 [processed 0 LLD rules during 5.005460 sec]
├─677 /usr/sbin/zabbix_server: lld worker #1 [processed 1 LLD rules, idle 983.680766 sec during 983.705156 sec]
├─679 /usr/sbin/zabbix_server: lld worker #2 [processed 1 LLD rules, idle 599.446089 sec during 599.446265 sec]
└─680 /usr/sbin/zabbix_server: alert syncer [queued 0 alerts(s), flushed 0 result(s) in 0.000518 sec, idle 1 sec]

Oct 29 13:48:07 xxx systemd[1]: Starting Zabbix Server...
Oct 29 13:48:07 xxx systemd[1]: Started Zabbix Server.

systemctl status mysql

root@zabbix:~# systemctl status mysql
● mariadb.service - MariaDB 10.3.23 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: active (running) since Thu 2020-10-29 13:48:07 CET; 1h 0min ago
Docs: man:mysqld(8)

https://mariadb.com/kb/en/library/systemd/

Process: 448 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 458 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 460 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCC
Process: 565 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 567 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
Main PID: 525 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 57 (limit: 4915)
Memory: 220.6M
CGroup: /system.slice/mariadb.service
└─525 /usr/sbin/mysqld

Oct 29 13:48:06 xxx systemd[1]: Starting MariaDB 10.3.23 database server...
Oct 29 13:48:07 xxx mysqld[525]: 2020-10-29 13:48:07 0 [Note] /usr/sbin/mysqld (mysqld 10.3.23-MariaDB-0+deb10u1) starting as process 525 ...
Oct 29 13:48:07 xxx mysqld[525]: 2020-10-29 13:48:07 0 [Warning] Could not increase number of max_open_files to more than 16364 (request: 32186)
Oct 29 13:48:07 xxx systemd[1]: Started MariaDB 10.3.23 database server.
Oct 29 13:48:07 xxx /etc/mysql/debian-start[569]: Upgrading MySQL tables if necessary.

[tim.mooney]

The web front end is configured separately from the zabbix-server process. Large environments sometimes host the web front end on a completely different server from the zabbix-server processes.

Your zabbix-server is running fine and is able to connect to the database, because you have the correct database credentials in the /etc/zabbix/zabbix_server.conf

Your web front end is not working because you're missing database credentials in the zabbix/conf/zabbix.conf.php file.

[lin]

Thx Tim! The problem realy was in bad credentials in zabbix.conf.php. I solved the problem yesterday but I couldn't edit the post