topic MySQL Community as a Source in Qlik Replicate

MySQL Community as a Source

Clever_Anjos — Wed, 15 Apr 2020 21:05:19 GMT

I'm trying to load data from a MySQL Community (Server version: 8.0.19 MySQL Community Server - GPL) installed in same machine that Replicate 6.5

my.ini
default-storage-engine=INNODB
log-bin="SENSE-bin"
binlog_format=row
binlog_checksum=NONE

When I try to create a task using this MySQL as a source, I'm getting this error:

Stream component 'st_0_MySQL' terminated
Cannot initialize subtask
Failed while preparing stream component 'st_0_MySQL'.
Errors in MySQL server binary logging configuration
Error 2019 (Can't initialize character set unknown (path: compiled_in)) connecting to MySQL server 'localhost'

Can anyone point me one direction to check what can be done to solve this?

Re: MySQL Community as a Source

Clever_Anjos — Fri, 17 Apr 2020 18:06:14 GMT

Solved

file path: %PROGRAMDATA%\MySQL\MySQL Server X.X\my.ini

[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8
skip-character-set-client-handshake

[client]
default-character-set = utf8

[mysql]
default-character-set = utf8

Re: MySQL Community as a Source

john_wang — Thu, 30 Apr 2020 15:30:13 GMT

MySQL default character set changed from UTF8 to UTF8MB4. Qlik Replicate does not support this character set yet.
You can change the character set to UTF8 as a WA.

thanks,

John.