Error: Ident authentication failed for user "postgres";

danielbussade commented 5 years ago

I can't connect to my instance of Postgresql Server. I can connect with sudo -U psql postgres -W and after type password, it works.

I edited the file located /var/lib/pgsql/9.6/data/pg_hba.conf and changed the method to local instance from peer to md5; Below is my file:

TYPE DATABASE USER ADDRESS METHOD "local" is for Unix domain socket connections only local all all md5 IPv4 local connections: host all all 127.0.0.1/32 ident IPv6 local connections: host all all ::1/128 ident Allow replication connections from localhost, by a user with the replication privilege. local replication postgres peer host replication postgres 127.0.0.1/32 ident

Here is the log after i run the command npm start: RasaUI@2.5.1 start /root/rasaui node server/server.js

Environment CentOS Linux release 7.5.1804 (Core)

node -v: v11.10.0

npm -v 6.7.0

Postgres Version 9.6

Is there any other configuration should i have to do?

Tks

pradeepmvn commented 5 years ago

@danielbussade Are you using Docker to run Postgres? But either way the error seems to be a user Auth issue. Are you sure you created a postgres user and using a correct password for it?

danielbussade commented 5 years ago

@pradeepmvn Thanks for your answer. As a matter of fact i am not using Docker, I've installed via Node JS using npm. I finally get fixed this error, editing the file pg_hba.conf and adding the line:

TYPE DATABASE USER ADDRESS METHOD host all all 127.0.0.1/32 md5

I think the Postgre SQL was accepting just Unix Domain socket connections before I added this line. So I am going to close this issue, right now.

Tks again

paschmann / rasa-ui

Error: Ident authentication failed for user "postgres"; #166