连接obproxy报错,reading authorization pack

【产品名称】obproxy

【产品版本】3.1.1

【问题描述】

[root@lhrobproxy lhrob311cluster]# obclient -uroot@sys -h 172.72.8.14 -P 2883 -plhr ERROR 2013 (HY000): Lost connection to MySQL server at ‘reading authorization packet’, system error: 11 [root@lhrobproxy lhrob311cluster]# obclient -uroot@sys -h 172.72.8.11 -P 2881 -plhr Welcome to the OceanBase. Commands end with ; or \g. Your MySQL connection id is 3221503892 Server version: 5.7.25 OceanBase 3.1.1 (r4-8c615943cbd25a6f7b8bdfd8677a13a21709a05e) (Built Oct 21 2021 10:33:14) Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement. MySQL [(none)]> select * from oceanbase.__all_server; ±------------±---------±—±------±-----------±----------------±-------+ | svr_ip | svr_port | id | zone | inner_port | with_rootserver | status | ±------------±---------±—±------±-----------±----------------±-------+ | 172.72.8.11 | 2882 | 1 | zone1 | 2881 | 0 | active | | 172.72.8.12 | 2882 | 2 | zone2 | 2881 | 0 | active | | 172.72.8.13 | 2882 | 3 | zone3 | 2881 | 1 | active | ±------------±---------±—±------±-----------±----------------±-------+ 3 rows in set (0.345 sec) MySQL [(none)]> exit Bye [root@lhrobproxy lhrob311cluster]# ps -ef|grep admin admin 13310 1 73 10:42 ? 00:08:22 /home/admin/obproxy/bin/obproxy -o enable_strict_kernel_release=False,enable_cluster_checkout=False --listen_port 2883 --prometheus_listen_port 2884 --rs_list 172.72.8.11:2881;172.72.8.12:2881;172.72.8.13:2881 admin 13548 1 0 10:42 ? 00:00:00 bash /home/admin/obproxy/obproxyd.sh /home/admin/obproxy 172.72.8.14 2883 daemon


########################## 以下是obrpoxy的 搭建参数 ######################3
obproxy: 
  servers:
    - 127.0.0.1
  global:
    listen_port: 2883
    prometheus_listen_port: 2884
    home_path: /home/admin/obproxy
    # oceanbase root server list
    # format: ip:mysql_port,ip:mysql_port
    rs_list: 172.72.8.11:2881;172.72.8.12:2881;172.72.8.13:2881
    enable_cluster_checkout: false

yum install -y yum-utils
yum-config-manager --add-repo https://mirrors.aliyun.com/oceanbase/OceanBase.repo
yum install -y ob-deploy

obd cluster deploy lhrob311cluster -c /tmp/obd_observer_obproxy.yaml -f



您好,obproxy部署,您可以参考下庆涛老师的文档:https://open.oceanbase.com/articles/1100243

1.先rpm安装一下包,rpm -ivh obproxy-3.1.0-1.el7.******
2.参考下图,配置相关信息

1 个赞

select user,host,password from mysql.user; 结果请贴下