cancel
Showing results for 
Search instead for 
Did you mean: 

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. 

6 REPLIES 6

vambrale
New Contributor
New Contributor

@rushikeshvartak Could you guide me on this ?

sk
Regular Contributor
Regular Contributor

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)?

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).

sk
Regular Contributor
Regular Contributor

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.

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...

MySQL 8.0.26

Connector/J 8.0.31

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