Creating a data source to a MySQL database using SSL fails in Information Designer.
Creating a data source to a MySQL database using SSL in Spotfire Information Designer may fail with errors, even though users can login to MySQL WorkBench using SSL.When saving the Data Source in Spotfire Information Designer to MySQL using SSL, it may fail with the following error:
Cannot connect to database server
Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
Based on the MySQL version used, this could be because of the value set for the "verifyServerCertificate" parameter. The default value of this parameter is "true" and should be set to "false" explicitly in the JDBC connection URL. The following provides additional information about this parameter:
If "useSSL" is set to "true", should the driver verify the server's certificate? When using this feature, the keystore parameters should be specified by the "clientCertificateKeyStore" properties, rather than by system properties. The default is "false" when connecting to MySQL 5.5.45+, 5.6.26+ or 5.7.6+ and "useSSL" was not explicitly set to "true". Otherwise the default is "true".
Append 'verifyServerCertificate=false' to the JDBC connection URL in Information Designer. This is an example of such a URL: