【 使用环境 】测试环境
【 OB or 其他组件 】OB4.2.0和LOGproxy 1.1.2----flink 1.17.1
【 使用版本 】
【问题描述】部署了3台机器的集群，客户端可以连成功，flink-cdc连接，logproxy报认证失败
Log line format: [IWEF]yyyymmdd hh:mm:ss.uuuuuu threadid file:line] msg
E20230811 09:37:39.474835 3457 mysql_protocol.cpp:126] Auth user failed of server: 192.168.0.30:2881, user: test_ocp
配置文件如下：
{
“service_port”: 2983,
“encode_threadpool_size”: 8,
“encode_queue_size”: 20000,
“max_packet_bytes”: 67108864,
“record_queue_size”: 20000,
“read_timeout_us”: 2000000,
“read_fail_interval_us”: 1000000,
“read_wait_num”: 20000,
“send_timeout_us”: 2000000,
“send_fail_interval_us”: 1000000,
“check_quota_enable”: false,
“command_timeout_s”: 10,
“log_quota_size_mb”: 5120,
“log_quota_day”: 7,
“log_gc_interval_s”: 43200,
“oblogreader_path_retain_hour”: 168,
“oblogreader_lease_s”: 300,
“oblogreader_path”: “./run”,
“allow_all_tenant”: true,
“auth_user”: true,
“auth_use_rs”: false,
“auth_allow_sys_user”: true,
“ob_sys_username”: “8E98D3213CD479B6104479D44F32EB5C”,
“ob_sys_password”: “2A7653E45FFB7BB13FDB4BE1E15501E8”,
“counter_interval_s”: 2,
“metric_enable”: true,
“metric_interval_s”: 10,
“debug”: false,
“verbose”: false,
“verbose_packet”: false,
“readonly”: false,
“count_record”: false,
“channel_type”: “plain”,
“tls_ca_cert_file”: “”,
“tls_cert_file”: “”,
“tls_key_file”: “”,
“tls_verify_peer”: true,
“liboblog_tls”: false,
“liboblog_tls_cert_path”: “”
}
【复现路径】问题出现前后相关操作
【问题现象及影响】
flink-cdc同步ob数据失败，
flink-cdc客户端配置如下
‘connector’ = ‘oceanbase-cdc’,
‘scan.startup.mode’ = ‘initial’,
‘username’ = ‘test_ocp@ocp#myoceanbase’,
‘password’ = ‘123456’,
‘tenant-name’ = ‘ocp’,
‘database-name’ = ‘test’,
‘table-name’ = ‘zjb_test1’,
‘hostname’ = ‘192.168.0.30’,
‘port’ = ‘2883’,
‘rootserver-list’ = ‘192.168.0.30:2882:2881;192.168.0.39:2882:2881;192.168.0.71:2882:2881’,
‘logproxy.host’ = ‘192.168.0.30’,
‘logproxy.port’ = ‘2983’
【附件】
。。。这样配置的，应该没有问题的吧