# Identitynow JDBC source test connection issue

**URL:** <https://developer.sailpoint.com/discuss/t/identitynow-jdbc-source-test-connection-issue/8084>\
**Category:** SHF Discussion and Questions\
**Created:** [February 9, 2023, 7:06pm UTC](https://developer.sailpoint.com/discuss/t/identitynow-jdbc-source-test-connection-issue/8084 "2023-02-09T19:06:42Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![SBahl](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SBahl](https://developer.sailpoint.com/discuss/u/SBahl)\
**Post date:** [February 9, 2023, 7:06pm UTC](https://developer.sailpoint.com/discuss/t/identitynow-jdbc-source-test-connection-issue/8084/1 "2023-02-09T19:06:42Z")

</div>

Hi all,

I have been trying to setup JDBC source in IdentityNow. Not sure where I am going wrong so if anyone can help me with the below problem it will be really helpful. While trying to test connection for a JDBC source connected to Mysql database getting below error.

**Error**

We have detected an error from the managed system.  
Error Received:

Timeout waiting for response to message 9 from client 02bxxbaf-xxxx-xxxx-xxxx-8724xxxxfc41 after 15 seconds.

**Below are the details of the VA**

I have a VA cluster with 2 VA’s in it 1 VA is healthy.

VA on an IP Address (1.10.1.11) , Able to ping MySQL IP from this VA.

**Below are the details of the MySQL**

MySQL is on IP (1.10.1.12), Able to ping VA IP from this side as well.

I am using root user to login with a password.

DB Name : db1

Table name : MyTable

**Below are the details of the source setup**

**Base Configuration**

Source Name : MyAccessJDBC

Source Description : MyAccess JDBC data source

Source Owner : SBahl

Virtual Appliance Cluster : TestVACluster2

Governance Group for Source Management :

Uploaded Files : mysql-connector-j-8.0.31.jar

**account**

User Name : root

Password : \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

Database URL : jdbc:mysql://1.10.1.12:3306/db1

Driver Class : com.mysql.cj.jdbc.Driver

Additional Connection Parameters :

Test Connection SQL Query : show databases;

Use Stored Procedure for Test Connection SQL Query : false

Account SQL Query : select \* from MyTable;

Use Stored Procedure for Account SQL Query : false

Single Account SQL Query :

Use Stored Procedure for Single Account SQL Query : false

Use executeQuery : false

Enable Direct Permission : false

Enable Delta Aggregation : false

Please let me know if any more info is required for this.

---

<div class="post-metadata">

**Author:** ![colin\_mckibben](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/colin_mckibben/32/37182_2.png) [@colin\_mckibben](https://developer.sailpoint.com/discuss/u/colin_mckibben)\
**Post date:** [February 10, 2023, 2:08pm UTC](https://developer.sailpoint.com/discuss/t/identitynow-jdbc-source-test-connection-issue/8084/2 "2023-02-10T14:08:53Z")

</div>

You can try and increase the timeout limit: [JDBC - Stored Procedure - #2 by AnamicaShroti](https://developer.sailpoint.com/discuss/t/jdbc-stored-procedure/1785/2)

---

<div class="post-metadata">

**Author:** ![SBahl](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SBahl](https://developer.sailpoint.com/discuss/u/SBahl)\
**Post date:** [February 10, 2023, 3:11pm UTC](https://developer.sailpoint.com/discuss/t/identitynow-jdbc-source-test-connection-issue/8084/3 "2023-02-10T15:11:59Z")

</div>

@colin_mckibben : I have already tried increasing the timeout, Still it gets timeout after 15 secs even after setting the value to a higher side.

---

<div class="post-metadata">

**Author:** ![sabthamis](https://avatars.discourse-cdn.com/v4/letter/s/46a35a/32.png) [@sabthamis](https://developer.sailpoint.com/discuss/u/sabthamis)\
**Post date:** [February 17, 2023, 11:35am UTC](https://developer.sailpoint.com/discuss/t/identitynow-jdbc-source-test-connection-issue/8084/4 "2023-02-17T11:35:33Z")

</div>

> [@SBahl](#):
>
> mysql-connector-j-8.0.31.jar

Hi Shivam,

Were you able to resolve this error ? I am getting the same error

---

<div class="post-metadata">

**Author:** ![2135797](https://avatars.discourse-cdn.com/v4/letter/2/8797f3/32.png) [@2135797](https://developer.sailpoint.com/discuss/u/2135797)\
**Post date:** [April 17, 2023, 10:17am UTC](https://developer.sailpoint.com/discuss/t/identitynow-jdbc-source-test-connection-issue/8084/5 "2023-04-17T10:17:00Z")

</div>

I am also getting same error,when I tried to ping the server in cmd I am getting time out error

---

<div class="post-metadata">

**Author:** ![sabthamis](https://avatars.discourse-cdn.com/v4/letter/s/46a35a/32.png) [@sabthamis](https://developer.sailpoint.com/discuss/u/sabthamis)\
**Post date:** [April 18, 2023, 8:13am UTC](https://developer.sailpoint.com/discuss/t/identitynow-jdbc-source-test-connection-issue/8084/6 "2023-04-18T08:13:04Z")

</div>

Nope. Just rename the JAR file upload it from UI and just wait for 2 mintues and the save.try to test the connection. this resolved my issue

---

<div class="post-metadata">

**Author:** ![2135797](https://avatars.discourse-cdn.com/v4/letter/2/8797f3/32.png) [@2135797](https://developer.sailpoint.com/discuss/u/2135797)\
**Post date:** [April 18, 2023, 8:16am UTC](https://developer.sailpoint.com/discuss/t/identitynow-jdbc-source-test-connection-issue/8084/7 "2023-04-18T08:16:37Z")

</div>

thank you @sabthami subramanian

---

<div class="post-metadata">

**Author:** ![sabthamis](https://avatars.discourse-cdn.com/v4/letter/s/46a35a/32.png) [@sabthamis](https://developer.sailpoint.com/discuss/u/sabthamis)\
**Post date:** [April 18, 2023, 8:18am UTC](https://developer.sailpoint.com/discuss/t/identitynow-jdbc-source-test-connection-issue/8084/8 "2023-04-18T08:18:15Z")

</div>

but is the ping from your VA server to the DB works or not ?

if not it could be some firewall rules issue which could block the connection.

---

<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:** [July 19, 2023, 2:24pm UTC](https://developer.sailpoint.com/discuss/t/identitynow-jdbc-source-test-connection-issue/8084/9 "2023-07-19T14:24:17Z")

</div>


