zabbix_server doesn't start with postgresql

[surenx]

Hi

I have zabbix web interface installed and configured to work with postgresql database, zabbix user is created along with it's password and entered in /usr/local/share/zabbix/php/conf/zabbix.conf.php.
Web interface works very well, but I can't start the zabbix_server script, in the log file I get the following.

Failed to connect to database: Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) [2002]

when I edit the /usr/local/etc/zabbix/zabbix_server.conf file I see that I can only change the username and password but not the DB type, and it seems that zabbix_server only wants to connect to Mysql DB.

Can anyone tell me, how can I make zabbix_server connect to postgresql database.

Thanks in Advance

[malmo]

1, is your zabbix server compiled with postgres support?
2, are you able to connect to postgres database using dbname, username and password specified in zabbix_server.conf file?

[surenx]

Yes, it is compiled with postgres support and web interface connects to the postgresql database and works normally, but zabbix_server only wants to connect to mysql I don't know how to change the configuration to postgresql in zabbix_server.conf file

[surenx]

Problem is solved, actually you need to be really careful how you compile zabbix.

So it be better compiled only with postgresql support if you intend to use that database