Debezium + kafka connect SASL实现sqlserver CDC

在项目中使用SASL_PLAINTEXT协议配置了用户名密码,启动connect的时候,一直报disconnect

启动的时候一直报错授权失败,或者是disconnected

需要在connect的配置文件connect-distributed.properties和插件的配置文件里同时添加相关的配置项

Kafka安装路径/kafka/config/connect-distributed.properties

# plugin.path=/usr/local/share/java,/usr/local/share/kafka/plugins,/opt/connectors,
plugin.path=

# 1.配置Connect workers去使用SASL/PLAIN
sasl.mechanism=PLAIN
# Configure SASL_SSL if SSL encryption is enabled, otherwise configure SASL_PLAINTEXT
security.protocol=SASL_SSL

# 2.配置JAAS参数,Connect的生产者和消费者去连接Kafka
sasl.jaas.config=org.apache.kafka.common.security.plain.PlainLoginModule required \
  username="connect" \
  password="connect-secret";
  
# 3.Source连接器配置相同的参数,加上producer前缀
producer.sasl.mechanism=PLAIN
# Configure SASL_SSL if SSL encryption is enabled, otherwise configure SASL_PLAINTEXT
producer.security.protocol=SASL_SSL
producer.sasl.jaas.config=org.apache.kafka.common.security.plain.PlainLoginModule required \
  username="connect" \
  password="connect-secret";

# 4.Sink连接器配置相同的参数,加上consumer前缀
consumer.sasl.mechanism=PLAIN
# Configure SASL_SSL if SSL encryption is enabled, otherwise configure SASL_PLAINTEXT
consumer.security.protocol=SASL_SSL
consumer.sasl.jaas.config=org.apache.kafka.common.security.plain.PlainLoginModule required \
  username="connect" \
  password="connect-secret";

sqlserver-cdc-source.json

{
    "name": "sqlserver-cdc-source",
    "config": {
        "connector.class" : "io.debezium.connector.sqlserver.SqlServerConnector",
        "tasks.max" : "1",
        "database.server.name" : "db",
        "database.hostname" : "192.168.1.1&

相关推荐

  1. Spring WebSocket实现实时通信

    2024-05-14 09:10:06       37 阅读
  2. rsync+inotify实现实时同步

    2024-05-14 09:10:06       18 阅读
  3. 通讯录实现

    2024-05-14 09:10:06       35 阅读
  4. Promise实现

    2024-05-14 09:10:06       18 阅读
  5. SpringBoot集成etcd,实现实时监听,实现配置中心

    2024-05-14 09:10:06       33 阅读

最近更新

  1. TCP协议是安全的吗?

    2024-05-14 09:10:06       16 阅读
  2. 阿里云服务器执行yum,一直下载docker-ce-stable失败

    2024-05-14 09:10:06       16 阅读
  3. 【Python教程】压缩PDF文件大小

    2024-05-14 09:10:06       15 阅读
  4. 通过文章id递归查询所有评论(xml)

    2024-05-14 09:10:06       18 阅读

热门阅读

  1. 学习Uni-app开发小程序Day9

    2024-05-14 09:10:06       7 阅读
  2. 《1w实盘and大盘基金预测 day34》

    2024-05-14 09:10:06       8 阅读
  3. 安装和配置OceanBase

    2024-05-14 09:10:06       11 阅读
  4. list的模拟实现

    2024-05-14 09:10:06       9 阅读
  5. Serverless-架构的兴起

    2024-05-14 09:10:06       11 阅读
  6. uniapp外部scss文件使用scss语法不生效

    2024-05-14 09:10:06       13 阅读
  7. 第十六章数据管理组织与角色期望练习

    2024-05-14 09:10:06       10 阅读
  8. ALOHA多相机Realsense配置以及数据采集

    2024-05-14 09:10:06       10 阅读
  9. 探索QChart:Qt中的数据可视化艺术

    2024-05-14 09:10:06       10 阅读
  10. MYSQL5.7.39 升级到 MYSQL8.0.33

    2024-05-14 09:10:06       11 阅读