11/15/2022 06:30 PM - edited 11/15/2022 08:47 PM
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.
11/15/2022 11:07 PM
@rushikeshvartak Could you guide me on this ?
11/16/2022 12:16 PM
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)?
11/16/2022 06:50 PM
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).
11/17/2022 06:24 AM
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.
11/17/2022 02:20 PM - edited 11/17/2022 02:22 PM
11/17/2022 06:25 PM
04/18/2023 01:19 PM
you need to replace the jar on server. Is that step performed
04/30/2023 06:52 PM
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
04/16/2023 09:26 PM
I believe for setting up the connectivity routing has to be enabled from SC2.0 to target app.