Unable to Update Plugin Due to 'FATAL no pg_hba.conf entry' in PostgreSQL

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

Unable to update any plug-in using Universal Plugin Manager with the message: "An unexpected error occurred. Please refer to the logs for more information."

The following appears in the atlassian-confluence.log:

ERROR [http-8080-3] [atlassian.config.bootstrap.DefaultAtlassianBootstrapManager] getTestDatabaseConnection Could not successfully test your database:
 -- referer: http://localhost:8080/setup/setupstandarddb-start.action?database=postgresql | url: /setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb
org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "xxx.xxx.xxx.xxx", user "confluence", database "confluence", SSL off

Cause

PostgreSQL has a list of allowed IP (configured in pg_hba.conf) that allow access to the database server. There is a missing entry for the host.

Resolution

Edit the pg_hba.conf file and add an entry to the Confluence server IP:

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# IPv4 local connections:
host    all         all         127.0.0.1/32          md5
host    confluence  confluence  xxx.xxx.xxx.xxx       md5
# IPv6 local connections:
host    all         all         ::1/128               md5
Last modified on Mar 30, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.