Hello,
I recently installed ZABBIX 1.0 on a Debian box using MySQL and managed to get the entire program working with monitored hosts and a few custom items running. However, my knowledge of MySQL and PostgreSQL is very limited and since my office uses Postgres, I have been trying to migrate ZABBIX over to a Postgres database.
I changed the db.inc.php file to use a Postgres database, installed Postgres, added a user named zabbix, and created a databased named zabbix. I then used cat to add the postgres schema.sql and data.sql values to the zabbix database. I added a line in pg_hba.conf to allow access for the user to the zabbix host server. However, when pointing my browser to the address: http://<ip-address>/~zabbix, I get this error:
Nothing has been changed in the ZABBIX frontend except commenting out the MySQL line and uncommenting the PostgreSQL line and no changes have been made to Apache. As far as I can tell, all required software is installed including the various php modules. I'm afraid this is simply a PostgreSQL configuration problem and my ignorance of PostgreSQL is leaving me in a quandary. The various forms of online Postgres documentation haven't alluded any clues. If any of you have any ideas as to what is giving me this error, they would be most appreciated. Also, if you need further information, I'll be happy to provide it.
Thanks for your time,
Nate
I recently installed ZABBIX 1.0 on a Debian box using MySQL and managed to get the entire program working with monitored hosts and a few custom items running. However, my knowledge of MySQL and PostgreSQL is very limited and since my office uses Postgres, I have been trying to migrate ZABBIX over to a Postgres database.
I changed the db.inc.php file to use a Postgres database, installed Postgres, added a user named zabbix, and created a databased named zabbix. I then used cat to add the postgres schema.sql and data.sql values to the zabbix database. I added a line in pg_hba.conf to allow access for the user to the zabbix host server. However, when pointing my browser to the address: http://<ip-address>/~zabbix, I get this error:
Warning: pg_pconnect(): Unable to connect to PostgreSQL server: FATAL: no pg_hba.conf entry for host "<ip-address>", user "zabbix", database "zabbix", SSL off in /home/zabbix/html/include/db.inc.php on line 43
Error connecting to database
Error connecting to database
Thanks for your time,
Nate
Comment