obproxy无法连接集群

【产品名称】oceanbase

【产品版本】社区版

【问题描述】obproxy无法通过2883端口连接集群,单独的节点是可以连接的。

[admin@tmgboss101100 ~]$ mysql -h127.1 -uroot@sys -P2881 -poracle_4U -c -A oceanbase mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3221497922 Server version: 5.7.25 OceanBase 3.1.1 (r4-8c615943cbd25a6f7b8bdfd8677a13a21709a05e) (Built Oct 21 2021 10:33:14) Copyright (c) 2000, 2021, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement. mysql> exit Bye [admin@tmgboss101100 ~]$ mysql -h192.168.101.100 -uroot@sys#obcluster -P2883 -poracle_4U -c -A oceanbase mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 2013 (HY000): Lost connection to MySQL server at ‘reading authorization packet’, system error: 0

附件是 obproxy 的日志。

log.tar (286720 KB)


[admin@tmgboss101100 ~]$ netstat -ntlp | grep obproxy

(Not all processes could be identified, non-owned process info

 will not be shown, you would have to be root to see it all.)

tcp    0   0 0.0.0.0:2883      0.0.0.0:*        LISTEN   3775/obproxy     

tcp    0   0 0.0.0.0:2884      0.0.0.0:*        LISTEN   3775/obproxy 


mysql -h${obproxy_ip} -P{$obproxy_port} -uroot@proxysys -p -A -c

alter proxyconfig set observer_sys_password = 'xxx';

注意:obproxy里设置的的observer_sys_password密码跟observer集群里的proxyro的密码需保持一致。