Unable to access the Jaspersoft Console. When checking in the Jaspersoft Tomcat log, there is a very long exception listed, indicating connection issues:
Failed to obtain DB connection from data source 'springNonTxDataSource.quartzScheduler': org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. [See nested exception: org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.]
CABI JasperReports 6.3.x or later
This error indicates a potential connection issue with postgresql database on port 5432 (default database installed)
There are several reasons this error may occur:
<CABI INSTALL DIR>/startServers.sh
for Windows:
netstat -ano | grep -i 5432
for Linux:
netstat -apn | grep -i 5432
<CABI INSTALL DIR>/postgresql/data/postgresql.conf
If the above does not solve the issue, there are other possibilities which can be reviewed by the links below:
https://www.postgresql.org/message-id/[email protected]