Zabbix failing to connect to psql database after helper script install.

[shadowsix]

Having a Zabbix first time install issue. The setup on web UI after using the PVE Helper script to set it all up gives me the below error:

cat zabbix.creds gives me the creds confirmed they are entered and just no luck resolving this -


Does anyone have any ideas?

What I've checked in psql:
-SSH into Zabbix LXC and enter psql with:
sudo -u postgres psql

-In PSQL check for db to ensure it actually existed \l yes it was found

-\du for listing users in PSQL found zabbix and tried giving it privileges to the DB with:
GRANT ALL PRIVILEGES ON DATABASE zabbixdb TO zabbix; this did not help

-Tried restarting psql:
sudo systemctl restart postgresql

All of this is still giving me some kind of connection error its all on the same lxc since the Helperscript did all the work I figured it would be fine from here but it would appear perhaps PSQL may need some config change to allow connections?

Anyone have feedback on that?

 

[shadowsix]

Disregard for some reason the password set by the script would not work.

After going into PSQL again with sudo -u postgres psql I then could use this command to set the new password and it fixed the issue:
ALTER USER zabbix WITH PASSWORD 'newpassword';

Script did not set the password or logged the incorrect one to give me when checking with the creds: cat zabbix.creds

Resolved.