We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Database Connection using SSL

vambrale
New Contributor
New Contributor

Recently I have uploaded the SSL(Client) on Saviynt for Database Access also tried with SSL(Server). However, I am not able to establish a connection between the Saviynt Platform and the Google Cloud MySQL Database.(tried it without SSL the connection is working fine). The driver in place is Connector/J 8.0.31 

I established a connection using Workbench with and without SSL, both are able to establish a connection.

The logs are as follows:

{"log":"2022-11-15 06:37:58,074 [http-nio-8080-exec-16] DEBUG connectorms.ConnectorMsHelperService - Checking ConnectorMs isAvailable \n","stream":"stdout","time":"2022-11-15T06:37:58.074479515Z"}
2022-11-15, 12:07 pm
ecm
{"log":"2022-11-15 06:37:58,076 [http-nio-8080-exec-16] DEBUG connectorms.ConnectorMsHelperService - ConnectorMs is Configured false\n","stream":"stdout","time":"2022-11-15T06:37:58.076351053Z"}
2022-11-15, 12:07 pm
ecm
{"log":"2022-11-15 06:37:58,076 [http-nio-8080-exec-16] DEBUG connectorms.ConnectorMsHelperService - ConnectorMs Available =false\n","stream":"stdout","time":"2022-11-15T06:37:58.076388885Z"}
2022-11-15, 12:07 pm
ecm
{"log":"2022-11-15 06:37:58,084 [http-nio-8080-exec-16] DEBUG domain.EcmConfigController - size of connectionTypeAndTemplateMap: 8\n","stream":"stdout","time":"2022-11-15T06:37:58.084700691Z"}
2022-11-15, 12:07 pm
ecm
{"log":"2022-11-15 06:37:56,381 [http-nio-8080-exec-7] DEBUG integration.ExternalConnectionCallService - in testExternalConnection for External Connection : "name"_DB\n","stream":"stdout","time":"2022-11-15T06:37:56.381341911Z"}
2022-11-15, 12:07 pm
ecm
{"log":"2022-11-15 06:37:56,382 [http-nio-8080-exec-7] INFO provisoning.DBProvisioningService - Start getConnection\n","stream":"stdout","time":"2022-11-15T06:37:56.382802196Z"}
2022-11-15, 12:07 pm
ecm
{"log":"2022-11-15 06:37:56,382 [http-nio-8080-exec-7] DEBUG provisoning.DBProvisioningService - using passed external connection :: "name"_DB\n","stream":"stdout","time":"2022-11-15T06:37:56.382830213Z"}
2022-11-15, 12:07 pm
ecm
{"log":"2022-11-15 06:37:56,385 [http-nio-8080-exec-7] DEBUG provisoning.DBProvisioningService - url before binding .. jdbc:mysql://IPAddress:3306/name\n","stream":"stdout","time":"2022-11-15T06:37:56.386002127Z"}
2022-11-15, 12:07 pm
ecm
{"log":"2022-11-15 06:37:56,385 [http-nio-8080-exec-7] DEBUG provisoning.DBProvisioningService - calling templateUtilityService.getTemplateString for binding \n","stream":"stdout","time":"2022-11-15T06:37:56.386017999Z"}
2022-11-15, 12:07 pm
ecm
{"log":"2022-11-15 06:37:56,649 [http-nio-8080-exec-7] ERROR provisoning.DBProvisioningService - Creating connection failed \n","stream":"stdout","time":"2022-11-15T06:37:56.650003423Z"}
2022-11-15, 12:07 pm
ecm
{"log":"com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.\n","stream":"stdout","time":"2022-11-15T06:37:56.650032762Z"}

 

I am not able to figure out what seems to be the problem. 

9 REPLIES 9

vambrale
New Contributor
New Contributor

@rushikeshvartak Could you guide me on this ?

sk
All-Star
All-Star

Is your Google Cloud MySQL Database created in Private or Public?

Do you have connectivity to DB from your SC2.0 client?

Are these the full logs? If not do you see any unknow host error(java.net.UnknownHostException)?


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

vambrale
New Contributor
New Contributor

Hi

GC MySQL is on free trial basis and has a public IP with port 3306.

No there is no connectivity of SC2.0

Yes, these are the full logs and No it does not have any such error(java.net.UnknownHostException).

If there is no connectivity from SC2.0 client then check if there are is any firewall needs to be open.

Another thing to check is, see if the target has routing through SC2 server-client pair. This has to be done on Saviynt side.


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

rushikeshvartak
All-Star
All-Star
  • share connector screenshot showing url
  • what is version of sql
  • it seems error with sql version and driver

https://stackoverflow.com/questions/50177907/com-mysql-jdbc-exceptions-jdbc4-mysqlnontransientconnec...


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

MySQL 8.0.26

Connector/J 8.0.31

We tried with other versions of connector as well but still not connecting

you need to replace the jar on server. Is that step performed 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Hi,

Is there a way to determine the version of the MySQL Driver jar used by Saviynt? Ideally since MySQL is a supported database by Saviynt connector the latest jar file which is compatible with all the MySQL versions supported by Saviynt should be bundled with the Saviynt EIC binaries. 

Regards,

Nilesh

Manu269
All-Star
All-Star

I believe for setting up the connectivity routing has to be enabled from SC2.0 to target app.

 

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.