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