topic MySQL endpoint: error in configuration in Qlik Replicate

MySQL endpoint: error in configuration

Benkku — Thu, 05 Aug 2021 07:29:38 GMT

Hi!

I am trying to connect to a MySQL database as source endpoint with Qlik Replicate and when testing the endpoint I get the following error:

SYS-E-HTTPFAIL, Cannot connect to ODBC provider.

SYS,GENERAL_EXCEPTION,Cannot connect to ODBC provider,RetCode: SQL_ERROR SqlState: HY000 NativeError: 2007 Message: [MySQL][ODBC 8.0(w) Driver]Protocol mismatch; server version = 11, client version = 10

Qlik Replicate runs in a Microsoft server. When I go to Control Panel > Administrative Tools > ODBC Data Sources, I see the version 8.0.26 is used.

Any hint?

Thanks,

Bernardo Di Chiara

Re: MySQL endpoint: error in configuration

john_wang — Thu, 05 Aug 2021 07:49:48 GMT

Hello @Benkku ,

Thanks for you contacting Qlik Community.

Not sure what's your Replicate version. Replicate version 2021.5 support MySQL versions 5.6, 5.7, and 8.0. see:
https://help.qlik.com/en-US/replicate/May2021/Content/Replicate/Main/Support%20Matrix/supported_source_endpoints.htm#ar_app_supported_dbversions_993761142_1330908

I'm assuming you are facing a client/server version compatibility issue. Can you check what's the MySQL Server version?

You may try to create a system DSN to use your "MySQL ODBC 8.0 Unicode Driver" to connect to the MySQL Server to see if the DSN works or not.

Hope this helps.

Regards,

John.

Re: MySQL endpoint: error in configuration

Benkku — Thu, 05 Aug 2021 08:18:49 GMT

Hi John!

Thanks a lot for your quick reply.

My Replicate version is: 7.0.0.356 (November 2020).

The Server SQL version is: 5.7.33-log Source distribution.

Best Regards,

Bernardo

Re: MySQL endpoint: error in configuration

john_wang — Thu, 05 Aug 2021 08:45:56 GMT

Hello @Benkku ,

Thanks for your update.

MySQL ODBC version 8.0 driver should work with MySQL Server 5.7, and this is MySQL recommended versions combination. Replicate 7.0 certainly will work too.

So far from MySQL error messages, seems you are using a wrong port number. see page #49:

https://docs.oracle.com/cd/E17952_01/mysql-shell-8.0-relnotes-en/mysql-shell-8.0-relnotes-en.pdf

You may try to create a DSN (it's irrelevant to Replicate) and check which port number (default 3306) should be used. Or check with your DBA to confirm the settings.

let me know if you need additional information.

Regards,

John.

Re: MySQL endpoint: error in configuration

Benkku — Thu, 05 Aug 2021 12:28:31 GMT

Hi John!

Yes, it was a port number issue. I am using Bitvise SSH Client to create a SSH tunnel and I have changed the listen port in the C2S tab of bitvise and in the source endpoint configuration in Replicate. Now the connection tested successfully!

Thanks a lot,

Bernardo

Re: MySQL endpoint: error in configuration

john_wang — Thu, 05 Aug 2021 12:33:26 GMT

Hello Bernardo,

Glad to hear that!

have a nice day,

John.