Page 1 of 1

Unable to connect to PostgreSQL server: FATAL: Ident authen

Posted: Mon Apr 14, 2014 4:24 am
by vsara90
Hi All,

Currently, we are facing issue with Nagios XI.
i.e., in UI, we couldn't able to login and getting the following error.

"DB Connect Error [nagiosxi]: Database connection failed"

By checking the httpd log, we identified the following issue with postgres.
"psql: FATAL: Ident authentication failed for user "nagiosxi""

Also, we changed the pg_hba.conf and changed the IDENT to TRUST.

But it didn't work.

Please help

Thanks.

Re: Unable to connect to PostgreSQL server: FATAL: Ident au

Posted: Mon Apr 14, 2014 1:41 pm
by abrist
Have you changed any of the database passwords?
Can you log into the postgresql db locally?

Code: Select all

echo "\dt" | psql nagiosxi nagiosxi