connection to database failed, access denied for user

[chrisbirley]

ive just upgraded from 7.2.14 to 7.4.5, followed through the process, and it all appeared to go well. went into the zabbix_server.conf file and ensured that DBName, DBUser nd DBPassword are all correct, checked that they matched zabbix.conf.php. but upon restarting the zabbix service, my log file is inundatated with the following:

2327:20251210:124431.068 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)

2327:20251210:124431.068 database is down: reconnecting in 10 seconds

it was working fine before the upgrade. the front end loads fine, but is understandably reporting that the ssytem isnt running.

do i need to try andd edit the user on the mysqlDB - it is a local instance on the zabbix server?

[chrisbirley]

i can log into my sql using the zabbix user and the password that i have set:

[chrisbirley]

ok, so further update, it looks like this killed the web front end, but ive re entered the password in the php file, and also the config file, and can now get back into the system. however the front end is still telling me that the server isnt running, and wont give me any information about server version etc. now when im looking in the server.log file i get the following:

1505:20251210:135118.747 Starting Zabbix Server. Zabbix 7.4.5 (revision c525822dce0).
1505:20251210:135118.747 ****** Enabled features ******
1505:20251210:135118.747 SNMP monitoring: YES
1505:20251210:135118.747 IPMI monitoring: YES
1505:20251210:135118.747 Web monitoring: YES
1505:20251210:135118.747 VMware monitoring: YES
1505:20251210:135118.747 SMTP authentication: YES
1505:20251210:135118.747 ODBC: YES
1505:20251210:135118.747 SSH support: YES
1505:20251210:135118.747 IPv6 support: YES
1505:20251210:135118.747 TLS support: YES
1505:20251210:135118.747 ******************************
1505:20251210:135118.747 using configuration file: /etc/zabbix/zabbix_server.conf
1505:20251210:135118.760 current database version (mandatory/optional): 07040000/07040000
1505:20251210:135118.760 required mandatory version: 07040000
1506:20251210:135118.762 starting HA manager
1506:20251210:135118.769 HA manager started in active mode
1505:20251210:135118.769 server #0 started [main process]
1507:20251210:135118.770 server #1 started [service manager #1]
1508:20251210:135118.771 server #2 started [configuration syncer #1]
1508:20251210:135119.723 __mem_malloc: skipped 33 asked 288 skip_min 256 skip_max 280
1508:20251210:135119.723 === memory statistics for configuration cache ===
1508:20251210:135119.723 free chunks of size 64 bytes: 1
1508:20251210:135119.723 free chunks of size >= 256 bytes: 33
1508:20251210:135119.723 min chunk size: 64 bytes
1508:20251210:135119.723 max chunk size: 280 bytes
1508:20251210:135119.723 memory of total size 29131112 bytes fragmented into 276434 chunks
1508:20251210:135119.723 of those, 8648 bytes are in 34 free chunks
1508:20251210:135119.723 of those, 29122464 bytes are in 276400 used chunks
1508:20251210:135119.723 of those, 4422928 bytes are used by allocation overhead
1508:20251210:135119.723 ================================
1508:20251210:135119.723 === Backtrace: ===
1508:20251210:135119.724 12: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](zbx_backtrace+0x52) [0x5d5cc5aef312]
1508:20251210:135119.724 11: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](__zbx_shmem_malloc+0x68) [0x5d5cc59f9988]
1508:20251210:135119.724 10: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](zbx_hashset_insert_ext+0xc7) [0x5d5cc5a295e7]
1508:20251210:135119.724 9: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](+0x2968c1) [0x5d5cc59678c1]
1508:20251210:135119.724 8: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](zbx_dc_sync_configuration+0x35e6) [0x5d5cc5982f46]
1508:20251210:135119.724 7: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](dbconfig_thread+0x108) [0x5d5cc57b52d8]
1508:20251210:135119.724 6: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](zbx_thread_start+0x24) [0x5d5cc5a04914]
1508:20251210:135119.724 5: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](+0xdac5b) [0x5d5cc57abc5b]
1508:20251210:135119.724 4: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](MAIN_ZABBIX_ENTRY+0x1056) [0x5d5cc57ad3d6]
1508:20251210:135119.724 3: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](main+0x3ab) [0x5d5cc57a10bb]
1508:20251210:135119.724 2: /lib/x86_64-linux-gnu/libc.so.6(+0x2a1ca) [0x74454462a1ca]
1508:20251210:135119.724 1: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x8b) [0x74454462a28b]
1508:20251210:135119.724 0: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](_start+0x25) [0x5d5cc57a8255]
1508:20251210:135119.724 [file:dbconfig.c,line:263] __zbx_shmem_malloc(): out of memory (requested 288 bytes)
1508:20251210:135119.724 [file:dbconfig.c,line:263] __zbx_shmem_malloc(): please increase CacheSize configuration parameter
1505:20251210:135119.728 One child process died (PID:1508,exitcode/signal:1). Exiting ...
1506:20251210:135119.728 HA manager has been paused
1506:20251210:135120.839 HA manager has been stopped
1505:20251210:135120.841 Zabbix Server stopped. Zabbix 7.4.5 (revision c525822dce0).

i changed the CacheSize in the server conf file from 512M to 4G, and restarted, and still seeing the same.

[chrisbirley]

ok....i was being blind, i was editing the wrong cachesize, did the correct one and its now happy