External error 'The host XXXX does not support SSL connections' when connecting with TIBCO Spotfire Connector for Oracle MySQL

book

Article ID: KB0081051

calendar_today

Updated On:

Products	Versions
Spotfire Analyst	7.11 HF-005 and lower, 7.12 HF-003 and lower

Description

When trying to connect to MySQL via TIBCO Spotfire Connector (Add Data Tables > Add > Connection To > Oracle MySQL), the connection may fail with the following error.

External error:
The host XXXX does not support SSL connections.

This error is caused when a new driver i.e MySQL Connector/Net v8.0.8 or later is used.

Issue/Introduction

When trying to connect to MySQL via TIBCO Spotfire Connector (Add Data Tables > Add > Connection To > Oracle MySQL), the connection may fail with the following error 'The host XXXX does not support SSL connections'. This error is caused when a MySQL Connector/Net v8.0.8 or later is used.

Resolution

In MySQL Connector/Net v8.0.8 and later the SSL Mode is set by default to 'Required' which should be 'None' for the Oracle MySQL connection to work using TIBCO Spotfire Connectors.

To resolve, apply the client hotfix which applies to your version: