Hi all,
Please I have installed jira 8.5 on centos-8 and also have postgresql 9.6 installed on it.
I have created a database, user and encrypted password for user.
On first attempt to connect to postgresql database I got an error message
Fatal: Ident authentication failed for user "username"
I did not have to touch the hba.conf because the database is installed on same server with Jira.
I have recreated the user again with same password using "ALTER USER" command to ensure I am getting my password details right.
I also noticed that
i) I am not able to connect to postgresql db on command line using
psql -h localhost -p 5432 -U <username> <databasename>;
Got similar error message
"psql: FATAL: Ident authentication failed for user "username"
Please what solution can you recommend?
Thanks for your help.
Akin
Hi,
Have you edited the The pg_hba.conf File to allow user and password credentials? You must use md5 authentication.
Regards
I thought this file is required to be edited when you have your postgresql installed on a remote server. Would give a go if that will fix it.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks so much @Jack Nolddor _Sweet Bananas_ that fixed the issue. I am able to coonect to my database now.
You rock!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You're welcome!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.