psql: FATAL: authentification Ident échouée pour l'utilisateur

[karim -Atlassway-]

Hello 

Team im configured server remotely 

I installed confluence and postgres , when i try to connect my database to postgres ,  for the simple way , when i hit test connection : it looks succeded as picture describe below :

But when i hit next to finish the configuration , it takes a while and i get this error : 

psql: FATAL: authentification Ident échouée pour l'utilisateur « postgres »

By connection string , the test failed : 

I see that i have to change the pg_hba.conf and i did it : Here i my file :

# TYPE DATABASE USER ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 ident
host all all 0.0.0.0/0 md5

# 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
#host replication postgres ::1/128 ident
host all all 0.0.0.0/0 md5
host all all ::/0 md5

Note : im configured my server remotly .

Please i need your help .

Thank you very much for your response .

Regards

Karim

[karim -Atlassway-]

@Alexey Matveev  

I think that you can help me ;) 

Could you please ?

Thank you 

regards

[Brant Schroeder]

You can try the resolution on below guide it is for Jira but Confluence can have the same issue:

https://confluence.atlassian.com/jirakb/jira-unable-to-connect-to-database-with-ident-authentication-failed-error-226787768.html

[karim -Atlassway-]

Hello @Brant Schroeder 

Thank you for your reply

I didi it , i make trust rather than md5

====>  host confluencedb confluenceadmin 0.0.0.0/0 trust

But after the test succes it's charge and return this error always :

Note : i cleaned the cache but always same problems.

I need your help please 

Thank you

[Brant Schroeder]

Do you have a software firewall on the box?

[karim -Atlassway-]

hello @Brant Schroeder  i don't know , how can i make sure please ? 

Thank you

[Brant Schroeder]

What is the Operating System of the server it is running on?  

[karim -Atlassway-]

it's centos 7 , it's a vps .

But i wanna tell you that i open the port of confluence 8090 and the port of postgres , 5432 to acces from remotely from my pc , because the server doesnt have a graphic .

THank you 

Regards

[Brant Schroeder]

Have you tried turning off the firewall or looking at the firewall logs? 

[karim -Atlassway-]

hello @Brant Schroeder 

Yes it's down !!!

[Brant Schroeder]

Is Confluence a stand alone instance or are you using Jira for authentication?

[karim -Atlassway-]

it's alone 

[karim -Atlassway-]

right now the problem with the user is solved , but when the test succed in two ways , it take a while and tell me 

Ce site est inaccessible

vps796322.ovh.net n'autorise pas la connexion.

Voici quelques conseils :

• Vérifier la connexion
• Vérifier le proxy et le pare-feu

ERR_CONNECTION_REFUSED

Regards

[Brant Schroeder]

Do you have a proxy setup?

[karim -Atlassway-]

No i do not have a proxy