Hi i’m new with confluent. Installed confluent platform in docker and installed debezium-connector-mysql:1.2.2(confluent-hub install debezium/debezium-connector-mysql:1.2.2) into cnfldemos/cp-server-connect-datagen. But after making connection settings, I get an error that connector failed to connect.
My connector config :
{
“name”: “MySqlConnectorConnector_0”,
“config”: {
“name”: “MySqlConnectorConnector_0”,
“connector.class”: “io.debezium.connector.mysql.MySqlConnector”,
“tasks.max”: “1”,
“errors.log.enable”: “true”,
“errors.log.include.messages”: “true”,
“database.hostname”: “database-test123ferlkfcl.eu-central-1.rds.amazonaws.com”,
“database.port”: “3306”,
“database.user”: “admin”,
“database.password”: “**********”,
“database.server.name”: “prod”,
“database.history.kafka.bootstrap.servers”: “192.168.0.26:9092”,
“database.history.kafka.topic”: “test”,
“include.schema.changes”: “true”,
“inconsistent.schema.handling.mode”: “skip”,
“connect.keep.alive”: “true”
}
}
Connector logs:
[2023-01-24 11:09:57,834] INFO [Producer clientId=MySqlConnectorConnector_0-dbhistory] Node -1 disconnected. (org.apache.kafka.clients.NetworkClient)
[2023-01-24 11:09:57,834] WARN [Producer clientId=MySqlConnectorConnector_0-dbhistory] Connection to node -1 (localhost/127.0.0.1:9092) could not be established. Broker may not be available. (org.apache.kafka.clients.NetworkClient)
[2023-01-24 11:09:57,834] WARN [Producer clientId=MySqlConnectorConnector_0-dbhistory] Bootstrap broker localhost:9092 (id: -1 rack: null) disconnected (org.apache.kafka.clients.NetworkClient)
[2023-01-24 11:09:57,937] INFO [Producer clientId=MySqlConnectorConnector_0-dbhistory] Node -1 disconnected. (org.apache.kafka.clients.NetworkClient)
[2023-01-24 11:09:57,937] WARN [Producer clientId=MySqlConnectorConnector_0-dbhistory] Connection to node -1 (/0.0.0.0:9092) could not be established. Broker may not be available. (org.apache.kafka.clients.NetworkClient)