# Getting error while integrating PostgreSQL DB in IDN

**URL:** <https://developer.sailpoint.com/discuss/t/getting-error-while-integrating-postgresql-db-in-idn/85369>\
**Category:** SHF Discussion and Questions\
**Tags:** jdbc-connector, identity-security-cloud\
**Created:** [October 14, 2024, 1:00pm UTC](https://developer.sailpoint.com/discuss/t/getting-error-while-integrating-postgresql-db-in-idn/85369 "2024-10-14T13:00:51Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dipali](https://avatars.discourse-cdn.com/v4/letter/d/bcef8e/32.png) [@dipali](https://developer.sailpoint.com/discuss/u/dipali)\
**Post date:** [October 14, 2024, 1:00pm UTC](https://developer.sailpoint.com/discuss/t/getting-error-while-integrating-postgresql-db-in-idn/85369/1 "2024-10-14T13:00:51Z")

</div>

I am getting below error while connecting postgresql database from SailPoint IdentityNow using JDBC Connector:  
 ![image](https://global.discourse-cdn.com/sailpoint/original/3X/a/e/aecdd3a2205da3f436d5a2d5d744f04ab62d83a5.png)

database details: The DB is behind the VPC. postgresql-42.1.1  
Postgresql version: 13.15

Connection details:  
URL: jdbc:postgresql://\<ip\_address\>:\<port\_no\>/\<database\_name\>  
Driver Class: org.postgresql.Driver  
Jar Version: postgresql-42.7.4.jar  
Test Connection SQL Query: SELECT 1

---

<div class="post-metadata">

**Author:** ![VijayMaripi](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/vijaymaripi/32/15719_2.png) [@VijayMaripi](https://developer.sailpoint.com/discuss/u/VijayMaripi)\
**Post date:** [October 14, 2024, 2:26pm UTC](https://developer.sailpoint.com/discuss/t/getting-error-while-integrating-postgresql-db-in-idn/85369/2 "2024-10-14T14:26:20Z")

</div>

Hi @dipali ,

Here are a few troubleshooting methods we can consider:

- Capture and review the detailed VA logs to identify any specific error messages or codes.
- Please check if server is reachable from VA using “ping” or “nc” commands or for any firewall issue
- Verify if the service account has the necessary permissions.
- Verify that the IP address of the target system is whitelisted
- If the target system uses TLS, ensure that the necessary certificates are correctly configured on the VA.

Thanks,  
Vijay

---

<div class="post-metadata">

**Author:** ![dipali](https://avatars.discourse-cdn.com/v4/letter/d/bcef8e/32.png) [@dipali](https://developer.sailpoint.com/discuss/u/dipali)\
**Post date:** [October 22, 2024, 7:22am UTC](https://developer.sailpoint.com/discuss/t/getting-error-while-integrating-postgresql-db-in-idn/85369/3 "2024-10-22T07:22:45Z")

</div>

We have tried these troubleshooting commands. we have whitelisted our ip at application side.  
error got changed slightly:

Error Received:

[ConnectorException] [Error details] The server encountered an unexpected error while contacting target system during test configuration operation. Please check the logs. **SSL error: Read timed out**

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\
**Post date:** [December 21, 2024, 7:23am UTC](https://developer.sailpoint.com/discuss/t/getting-error-while-integrating-postgresql-db-in-idn/85369/4 "2024-12-21T07:23:30Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.