I'm trying to set up Zabbix with PostGres as the database on CentOS 7, but I'm getting stuck on setup.php with an error reading "Cannot connect to the database".
I've installed Zabbix from the CentOS repos (specifically, I installed the following packages via "sudo yum install": zabbix40 zabbix40-dbfiles-pgsql zabbix40-proxy-pgsql zabbix40-server-pgsql zabbix40-web-pgsql), set up the database, and confirmed that the database can be reached via both command-line psql and a tiny test PHP program.
I get nothing but "OK" statuses on the "Check of pre-requisites" screen of setup.php, but when I click "Next step", enter the database details on the "Configure DB connection" screen, and click "Next step" again, I get an error message reading "Cannot connect to the database." And expanding the details just shows "Error connecting to database."
I've checked in /var/log/zabbixsrv/zabbix_server.log, /var/log/httpd/error.log, and /var/lib/pgsql/data/pg_log/postgresql-Fri.log to see if there were any hints in any of those files, and watched those files with tail -f to see if anything gets written to them as I try to set up the connection - and there's nothing in any of them.
I've installed Zabbix from the CentOS repos (specifically, I installed the following packages via "sudo yum install": zabbix40 zabbix40-dbfiles-pgsql zabbix40-proxy-pgsql zabbix40-server-pgsql zabbix40-web-pgsql), set up the database, and confirmed that the database can be reached via both command-line psql and a tiny test PHP program.
I get nothing but "OK" statuses on the "Check of pre-requisites" screen of setup.php, but when I click "Next step", enter the database details on the "Configure DB connection" screen, and click "Next step" again, I get an error message reading "Cannot connect to the database." And expanding the details just shows "Error connecting to database."
I've checked in /var/log/zabbixsrv/zabbix_server.log, /var/log/httpd/error.log, and /var/lib/pgsql/data/pg_log/postgresql-Fri.log to see if there were any hints in any of those files, and watched those files with tail -f to see if anything gets written to them as I try to set up the connection - and there's nothing in any of them.