我搭建了一个kafka connect集群,注册连接器报错:
{"error_code":400,"message":"Connector configuration is invalid and contains the following 1 error(s):\nUnable to connect. Check this and other connection properties. Error: Couldn't obtain database name\nYou can also find the above list of errors at the endpoint `/connector-plugins/{connectorType}/config/validate`"}
配置如下:
curl -i -X POST -H "Accept:application/json" -H "Content-Type:application/json" 192.168.10.137:8083/connectors/ -d\
'{
"name": "sqlserver-connector-test",
"config": {
"connector.class": "io.debezium.connector.sqlserver.SqlServerConnector",
"database.hostname": "121.***",
"database.port": "***",
"database.user": "yun***",
"database.password": "***",
"database.dbname": "***",
"database.server.name": "sqlserver-test",
"table.include.list": "dbo.cdc_test",
"snapshot.mode": "schema_only",
"decimal.handling.mode": "String",
"database.server.timezone": "Asia/Shanghai",
"database.history.kafka.bootstrap.servers": "192.168.10.137:9092",
"database.history.kafka.topic": "dbhistory.sqlserver-test"
}
}'
日志:
[2021-09-28 18:58:57,428] INFO Connection gracefully closed (io.debezium.jdbc.JdbcConnection:951)
[2021-09-28 18:58:57,432] INFO AbstractConfig values:
(org.apache.kafka.common.config.AbstractConfig:372)
...没啥有用信息...
最后,我检查了所有kafka节点的公网ip,发现其中一台机器公网ip不对,更改之后注册成功。