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

Error connecting to database FATAL: password authentication failed for user "jiradbuser"

Vick September 5, 2023

I have latest Jira 9.10 installed  | Postgresql 10.3 | Running on Redhat 8.8

CREATE USER jiradbuser;

CREATE DATABASE jiradb WITH ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0;

GRANT ALL PRIVILEGES ON DATABASE jiradb TO jiradbuser;

I changed "pg_hba.conf" to the following: host all all 127.0.0.1/32 md5

 

Database Type: PostgreSQL

Hostname: localhost

Port: 5432

Database: jiradb

Username: jiradbuser

Password: entered correct password and changed it too

Schema: public

I have made sure to restart postgresql service once changed to md5

1 answer

1 accepted

0 votes
Answer accepted
Vick November 17, 2023

This worked for me

Changed --> /var/lib/pgsql/data/pg_hba.conf -

host | all | all | 127.0.0.1/32 | md5
host | all | all | 127.0.0.1/32 | password

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, team '25, conference, certifications, bootcamps, training experience, anaheim ca,

Want to make the most of Team ‘25?

Spend the day sharpening your skills in Atlassian Cloud Organization Admin or Jira Administration, then take the exam onsite. Already ready? Take one - or more - of 12 different certification exams while you’re in Anaheim at Team' 25.

Learn more
AUG Leaders

Upcoming Jira Events