postgressql initial connection error

[robert knox]

Error connecting to database on initial set up of Jira - i beliee I have follwed th eset up of psotgressql as per th esetup instructions

FATAL: no pg_hba.conf entry for host "192.168.1.37", user "jiradbuser", database "jiradb", SSL off

I can't finmd a reference to this error

[Adrian Stephen · Accepted solution]

Hi @robert knox 

Welcome to the community!

Based on the error message provided, it looks like you are facing the issue documented here:

• https://confluence.atlassian.com/jirakb/error-connecting-to-database-fatal-no-pg_hba-conf-entry-for-host-x-x-x-x-user-jiradbuser-database-jiradb-ssl-off-950801726.html

Have you tried the resolution from the KB article above?

The resolution mentioned that in order to solve this error :

Add the IP address of the application (e.g., Jira) server to the pg_hba.conf and make sure that the method is not set to reject. You need to modify the xxx.xxx.xxx.xxx and put the IP address to allow connections.

Do check the article for more details information and keep us updated with the progress. 

Have a great day.

Regards,
Adrian Stephen

[robert knox]

Many thanks Adrian - up and running now. Appreciate the fast response

[Adrian Stephen]

Hi @robert knox , 

Glad to hear it’s up and running! If the solution provided helped, please click on “Accept Answer” so that it can help other users with the similar issue in the future. 

Regards, 

Adrian Stephen