Zabbix PSQL Ubuntu 11.10

[arctic11]

Hi All,

I am new to Zabbix but was highly recommeded to me so I am giving it a whirl. I have an issue at the moment with the postgresql configuration of the server. I am running Ubuntu 11.10 server with psql 9.1.2 and I am running the command from the installation guide:

psql -U zabbix

but I get this error:

psql: FATAL: Peer authentication failed for user "zabbix"

I have run that as is and with the sudo command also tried changing the user at the command line with the su command and running it under zabbix account but still get the same error and the services are definitely started. Not sure if there is something I am missing or there is an issue with the install/configuration of psql.

Any help would be much appreciated as I have been googling this alot.

[p__]

Seems more like it's a PostgreSQL problem. You probably need to update you pg_hba.conf file (/etc/postgresql/9.1/main/pg_hba.conf ?) to allow md5 authentication method.

[arctic11]

Looked at the pg_hba.conf file and added the following lines but it did not help:

local all all trust
local all all md5
host all all 127.0.0.1/32 trust

Any other suggestions or this question I should posting on the postgresql forums as I agree with you it seems more of psql issue then zabbix?

Cheers

[p__]

Is the database hosted on the same machine as the zabbix server?
Did you reload postgres after editing the file?