cannot create PoolableConnectionFactory FATAL no pg_hba.conf entry for host

Products

• CA Service Desk Manager
• CA Service Catalog
• CA Service Management - Service Desk Manager

Issue/Introduction

The following error appears when integrating JasperReports Server 8.x with SDM:

ERROR SqlExceptionHelper,Catalina-utility-2:131 - Cannot create PoolableConnectionFactory (FATAL: no pg_hba.conf entry for host "<IP Address>", user "<user>", database "<DB Name>", SSL off)

 

 

Environment

JasperReports Server 8.x, 9.x

Service Desk Manager 17.x

Cause

OOTB the Postgres database for JasperReports allows connections only from the local server

Resolution

1. Edit the pg_hba.conf file located in Jaspersoft\jasperreports-server-xxx\postgresql\data

Add the following line to allow remote connections from all servers

host all all 0.0.0.0/0 md5

If you need to add only the IP address of the SDM Server, refer to the following link: The pg_hba.conf file

2. Restart Postgres and JasperReports services

3. Re-Run the integration