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:

Cause:

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:

jdbc:mysql://mysqlserver.example.com:3306/mysql?useSSL=true&requireSSL=true&verifyServerCertificate=false

• Configuration Properties, MySQL Documentation 
  • http://dev.mysql.com/doc/connectors/en/connector-j-reference-configuration-properties.html