Qlik Community

Qlik Replicate

Discussion board for collaboration on Qlik Replicate.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Clever_Anjos
Employee
Employee

MySQL Community as a Source

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?

 

 

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee
Author

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

View solution in original post

2 Replies
Clever_Anjos
Employee
Employee
Author

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

View solution in original post

john_wang
Support
Support

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.