After upgrading MySQL ODBC drivers (to, for example, connect to MySQL 8.0), old tasks connecting to MySQL 5.5/5.6/5.7 as sources fail.
Error:
Cannot connect to ODBC provider,RetCode: SQL_ERROR SqlState: HY000 NativeError: 2026 Message:
[MySQL][ODBC 8.0(w) Driver]SSL connection error: error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol
Environment:
Qlik Replicate
Resolution:
With MySQL ODBC Client 5.3 or higher, the internal parameters must be set to point at the correct driver.
First, locate the exact name of the driver in the Windows ODBC Data Source Administrator.
- Open the windows ODBC Data Source Administrator
- Open the Drivers tab
- Scroll to your MySQL ODBC driver. Example: MySQL ODBC 8.0 Unicode Driver
- Copy MySQL ODBC 8.0 Unicode Driver. This will be the name we use for the internal parameter.
Then set the Internal Parameter in Qlik Replicate.
- In the Qlik Replicate Web Console, go to Manage Endpoint
- Locate your MySQL Source or Target that is failing with the connection error
- Switch to the Advanced tab
- Click Internal Parameters
- In the top search bar, type provider (for source) or driver (for target)
- Click the suggestion. It will add a Parameter to define.
- In Value, paste the name of your driver, replacing the <x.x> with the actual version: MySQL ODBC
- Click OK