Unable to connect to PostgreSQL server: FATAL: Ident authen

[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.

[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