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

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

症状

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."

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

原因

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.

ソリューション

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

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.