Error: Binary logging is disabled for MySQL server

[OritA]

When working with MySQL source endpoint you may get the following error in the Replicate log:

[SOURCE_CAPTURE ]E: Binary logging is disabled for MySQL server [1020418] (mysql_endpoint_capture.c:386)
[SOURCE_CAPTURE ]E: Errors in MySQL server validation. [1020418] (mysql_endpoint_imp.c:670)
[TASK_MANAGER ]E: Failed while preparing stream component ….
[TASK_MANAGER ]E: Cannot initialize subtask [1020418] (subtask.c:1297)

Environment

• Qlik Replicate with MySQL source endpoint

 

Resolution

This error happens when the system var log_bin is not set to ON. To resolve it the MySQL DBA should set the system var 'log_bin' = 'ON'.