topic Re: Failed Test Connection for MySQL v8.0 as Source Endpoint in Qlik Replicate

Failed Test Connection for MySQL v8.0 as Source Endpoint

cdc — Fri, 23 Feb 2024 03:28:54 GMT

Hi all,

Recently my client upgraded their MySQL to version 8.0 on Qlik Replicate version 6.6.0.546. Unfortunately, it failed when trying to test the connection. Any idea or solution regarding this case? in addition, this happen in production environment. Thank you

Akbar

Re: Failed Test Connection for MySQL v8.0 as Source Endpoint

john_wang — Fri, 23 Feb 2024 03:37:44 GMT

Hello @cdc ,

Thanks for reaching out to Qlik Community!

The problem is Qlik Replicate v6.6 does not support characterset UTF8MB4. This charset is supported from version v7.0.

However versions v6.6 and 7.0 and other old versions had reached end of support (EOS) date. Please upgrade to supported major versions, version 2023.11 is highly recommended.

Hope this helps.

John.

Re: Failed Test Connection for MySQL v8.0 as Source Endpoint

cdc — Fri, 23 Feb 2024 03:39:08 GMT

Hi John,

Thank you for the response, is there any solution beside upgrade the Qlik version?

Thank you

Re: Failed Test Connection for MySQL v8.0 as Source Endpoint

john_wang — Fri, 23 Feb 2024 03:48:37 GMT

Hello @cdc ,

Thanks for the feedback.

UTF8MB4 is the default charset in MySQL 8.0 and up, while in MySQL 5.7 and lower versions it's UTF8MB3. Maybe you can specify UTF8MB3 in MySQL server configuration file (need restart MySQL Service) and try again. However as Replicate 6.6 is out of support, it's risk to run it in a PROD system.

Regards,

John.

Re: Failed Test Connection for MySQL v8.0 as Source Endpoint

cdc — Fri, 23 Feb 2024 04:29:21 GMT

Hi John,

Is there any best practice to configure from Qlik for this case?

Thanks

Re: Failed Test Connection for MySQL v8.0 as Source Endpoint

john_wang — Fri, 23 Feb 2024 14:18:50 GMT

Hello @cdc ,

It's pure MySQL server settings, It's better to work with your DBA to setup the MySQL.

Thanks,

John.