Support Questions
Find answers, ask questions, and share your expertise

APACHE Nifi - Error to enable CDC to RDS AuroraDb MySQL instance

APACHE Nifi - Error to enable CDC to RDS AuroraDb MySQL instance

Explorer

I've been facing some issues when I try to enable my DataChangeCaptureProcessor(CDC) in the RDS AuroraDb Mysql instance, I don't know what can't be, the message error is:

ProcessException: Could not connect binlog client to any of the specified hosts due to: Access denied for user 'root@10.0.0.0'(password YES)

 

Ps: The nifi container is running (on Fargate) in the same VPC of the AuroraDb Cluster, due that this should be avoid any connection issue I believe.

 

AuroraDb

Mysql version: 5.7

 

My processor configuration:

Mysql Host: my-db.my-region.my-cluster.rds.amazonaws.com:3306

Mysql Driver Class Name: com.mysql.jdbc.Driver

Mysql Driver Location(s): /opt/nifi/nifi-current/ls-target/mysql-connector-java-8.0.23.jar