Hello, I am getting this error while configuring POSTGRESQL parameters when setting up the database in confluence.
I am getting the following error. I have verfied the database configuration multiple times and the configuration seems to be ok in PostGreSQL. Need your support here. Thanks.
Problem connecting to your database
SQLState - 28000
org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "X.X.X.X", user "confluenceadmin", database "postgresdb", SSL off
Your database is not set up to allow connections from your server, so I'm afraid your "configuration seems to be ok in PostGreSQL" is not right.
Have a look at the database's pg_hba.conf file - it needs a rule in there to allow confluenceuser to connect from x.x.x.x and use the databases.
Are you sure you should be connecting Confluence to postgresdb? Is that not the admin database in there? Should it not be confluencedb?
That may be a diversion though, just something I would want to check.
Going back to the error message: There are no pg_hba.conf settings in that GUI I can see, you're going to have to edit it directly to allow the connection.
Sorry, have you read a documentation from PostgreSQL?
For me just interesting how did you check a configuration multiple times?
As I understand you are check on "app" level, I mean you just check for user about access to DB.
But "network" level have you test? like (telnet postgreshost 5432) from confluence. (short instruction https://blog.bigbinary.com/2016/01/23/configure-postgresql-to-allow-remote-connection.html , normal documentation
And double check "auth" level? like (psql -h postgreshost -d postgresdb -U confluenceadmin -W ) (for more info https://www.postgresql.org/docs/9.4/static/auth-pg-hba-conf.html)
I hope it helps for troubleshooting. And please, try to use cli, therefore you will fix so faster
Thanks Ann for your response. I fear I am not seeing the server configuration option under tools as you can see in the snapshot which I have shared. The one which I have is pgadmin ver4 on windows and I believe the snapshot which you shared is based on non-Windows platform.
Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time! We're looking for people to participate in a remote 1-hr workshop...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs