Qlik Replicate

[sat29]

Setup an endpoint of MYSQL server in Attunity, test connection fail with the following message:

Cannot connect to ODBC provider ODBC general error.RetCode: SQL_ERROR SqlState: HY000 NativeError: 2026 Message: [unixODBC][MySQL][ODBC 5.3(w) Driver]SSL connection error: unknown error number ODBC general error.

Internal Parameters has set:
provider : MySQL ODBC 5.3.8 Unicode Driver

 (Try set as either source or target type got the same error)

The Attunity Server and the MYSQL stand in the same segment

But also there has another existing MySQL server which could connected success

[john_wang · Accepted solution]

Hello @sat29 ,

Thanks for you opening the article.

MYSQL Driver depends on the Replicate version. Below is the Client prerequisites  from the 2022.5 user guide:

Install MySQL ODBC Unicode Driver 64-bit on the Replicate Server machine.

Information note

Only these driver versions are supported:

• 5.3.11 to 5.3.13
• 8.0.23

you may find the correct client versions for other Replicate version in the above link. 

If you want to point out the specific driver version then please follow the steps provided in the below community article specify a driver version .

BTW, let us know your MySQL Server version. Install the support version and let us know if the issue solved (remember to restart Replicate Services after MySQL ODBC Driver upgrading).

Hope this helps.

Regards,

John.

[sat29]

After downloaded (https://downloads.mysql.com/archives/c-odbc/) and upgraded mysql-connector-odbc-8.0.23-1.el7.x86_64.rpm, test connection fail with the following message: 
=============================================================================================
Cannot connect to ODBC provider ODBC general error.RetCode: SQL_ERROR SqlState: HY000 NativeError: 2026 Message: [unixODBC][MySQL][ODBC 8.0(w) Driver]SSL connection error: Didn't find key on read or update ODBC general error.
=============================================================================================

#rpm --checksig mysql-connector-odbc-8.0.23-1.el7.x86_64.rpm
mysql-connector-odbc-8.0.23-1.el7.x86_64.rpm: (sha1) dsa sha1 md5 gpg OK

[Steve_Nguyen]

1. what version of MySQL DB are you working with?

2. are you trying to connect with SSL , have you try to set SSL to none and test ?

3. from the Replicate Server , outside of Replicate, using Windows ODBC 64 bit, are you able to setup the ODBC connect to your MySQL server , does it works?

[sat29]

1. The MySQL version is 8.0.29

2. how to set SSL to none?

3. no sql client in the Replicate Server, but could connect to the MySQL server via another PC. Also the Replicate server could connect to another existing MySQL after upgrade to 8.0.23 odbc driver.

[sureshkumar]

Hi Team,

how to set SSL to none?

--> MySQL Source Endpoint => Security => SSL Mode Preferred change this to None.

Regards,

Suresh

[sat29]

I could not found the option from UI, could you have screen dump please?  (The Attunity version is 5.5.0.446)

[john_wang]

Hello @sat29 ,

Replicate 5.5 reached its end of support date 2 years ago, see Replicate lifecycle .

Please upgrade to supported versions. A sample of the setting in current major versions GUI:

Hope this helps.

Regards,

John.