Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Getting an error while first time authenticating the db (psql)

Abhinav Purokait
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 10, 2023

While configuring for the first time bamboo in local system it gives an error 

'Error accessing database: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "my_user" '

 

I tried with multiple user but it shows the same error 

 

PFA, Screenshot from 2023-05-10 16-30-23.png

1 answer

0 votes
Eduardo Alvarenga
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
May 10, 2023

Hello @Abhinav Purokait,

Welcome to Atlassian Community!

Your PostgreSQL Database configuration is probably not allowing connections with a password from localhost. To fix that, please review your Database pg_hba.conf file and add/fix the following entries:

local all all trust
host all 127.0.0.1/32 trust

PostgreSQL needs to be restarted to apply any changes to the logon ACLs.

You can find more details on this KB article:

Best regards,

Eduardo Alvarenga
Atlassian Support APAC

--please don't forget to Accept the answer if the reply is helpful-- 

Abhinav Purokait
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 10, 2023

I already did this troubleshoot and restarted the psql also but the error remains the same 

 

PFA,Screenshot from 2023-05-10 21-05-17.png

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events