[jira] [Resolved] (NIFI-8517) Cannot enable Distributed Map Cache Client in CaptureChangeMySQL

["David Handermann (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/NIFI-8517?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

David Handermann resolved NIFI-8517.
------------------------------------
      Assignee: David Handermann
    Resolution: Information Provided

The {{No suitable driver found}} error indicates that the {{MySQL Driver Locations}} property does not reference a working MySQL JDBC Driver JAR file. The Distributed Map Cache Client is optional for CaptureChangeMySQL, but it enables enriched information of binary log events, such as Table Names.

> Cannot enable Distributed Map Cache Client in CaptureChangeMySQL
> ----------------------------------------------------------------
>
>                 Key: NIFI-8517
>                 URL: https://issues.apache.org/jira/browse/NIFI-8517
>             Project: Apache NiFi
>          Issue Type: Bug
>          Components: Core Framework
>    Affects Versions: 1.12.1, 1.13.2
>            Reporter: Luki
>            Assignee: David Handermann
>            Priority: Major
>              Labels: features
>         Attachments: Screen Shot 2021-05-05 at 19.50.24.png, reproduction.xml
>
>
> If I don't enable the Distributed Map Cache Client property in the CaptureChangeMySQL processor I get a warning log:
> {{"No Distributed Map Cache Client is specified, so no event enrichment (resolution of column names, e.g.) will be performed."}}
>  
> If I enable the Distributed Map Cache Client I get the following error:
> {{"Error creating binlog enrichment JDBC connection to any of the specified hosts"}}
>  
> Both DistributedMapCacheServer and DistributedMapCacheClientService are running fine, I can communicate with the server on localhost:4557.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)