database is down: reconnecting in 10 seconds

[Attilio]

Hi guys,

I'm trying to install Zabbix with a remote database (Postgresql). After installing and configuring, if I access the dashboard, I read:

Zabbix server is running No

and the /var/log/zabbix/zabbix_server.log file if full of:

27970:20210526:070903.003 database is down: reconnecting in 10 seconds
27970:20210526:070913.015 [Z3001] connection to database 'zabbix' failed: [0] FATAL: password authentication failed for user "zabbix"
FATAL: password authentication failed for user "zabbix"

Note that I can work with any problem if I psql from the Zabbix server to the database server.

Further info:
Ubuntu 20.04.2 LTS
PostgreSQL 12.7 (Ubuntu 12.7-1.pgdg20.04+1)
Zabbix 5.4.0

Thank you,
Attilio

[dedy]

you did not specify the database access parameters correctly (login \ password) or try changing the password verification parameters in pg_hba.conf

[Attilio]

Hi dedy,

You are right!!! In zabbix_server.conf I wrote:

DBPassword='MyPassword'

instead of

DBPassword=MyPassword

Thank you for your time!

Best regards,
Attilio