It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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 :

Image 1.png

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 : 

String way postgres connection .png

 

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

 

 

 

 

 

 

 

 

 

2 answers

0 votes
Brant Schroeder Community Leader Mar 23, 2020

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

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 :

 

 

aprés succes.pngNote : i cleaned the cache but always same problems.

I need your help please 

Thank you

Brant Schroeder Community Leader Mar 24, 2020

Do you have a software firewall on the box?

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

Thank you

Brant Schroeder Community Leader Mar 24, 2020

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

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 Community Leader Mar 24, 2020

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

hello @Brant Schroeder 

Yes it's down !!!

Brant Schroeder Community Leader Mar 24, 2020

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

it's alone 

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 :

ERR_CONNECTION_REFUSED

 

Regards

Brant Schroeder Community Leader Mar 24, 2020

Do you have a proxy setup?

No i do not have a proxy

@Alexey Matveev _cPrime_  

I think that you can help me ;) 

Could you please ?

 

Thank you 

regards

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

Lessons and Learnings: Six Months of Working Remote [Discussion]

Hey there, folks! For most of us, the past six months- yes, you read that right- have been a journey. More people than ever before have pivoted to working remotely, and navigating being on-scre...

5,345 views 4 6
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you