【产品名称】
社区版
【产品版本】
【问题描述】
使用直连2881端口没有问题,使用obproxy连接 报2013
[admin@oceanbase etc]$ obclient -h192.168.100.128 -uroot@sys -P2881 -c -A oceanbase -p’7ujm&UJM’
Welcome to the OceanBase. Commands end with ; or \g.
Your MySQL connection id is 3221487664
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 [oceanbase]>
[admin@oceanbase etc]$ obclient -h192.168.100.128 -uroot@sys#obcluster -P2883 -c -A oceanbase -p’7ujm&UJM’
ERROR 2013 (HY000): Lost connection to MySQL server at ‘reading authorization packet’, system error: 11
[admin@oceanbase log]$ cat obproxy_stat.log
2022-02-27 23:58:59.500113,undefined,obcluster:sys:,OB_MYSQL,LOGIN,failed,-4152,2,0,0,0,8873us,0us,0us
2022-02-27 23:59:59.499614,undefined,obcluster:sys:,OB_MYSQL,LOGIN,failed,-4152,1,0,0,0,2349us,0us,0us
2022-02-28 00:00:59.499732,undefined,obcluster:sys:,OB_MYSQL,LOGIN,failed,-4152,2,0,0,0,4889us,0us,0us
2022-02-28 00:01:59.499032,undefined,obcluster:sys:,OB_MYSQL,LOGIN,failed,-4152,1,0,0,0,2417us,0us,0us
2022-02-28 00:02:59.499939,undefined,obcluster:sys:,OB_MYSQL,LOGIN,failed,-4152,1,0,0,0,2257us,0us,0us
2022-02-28 00:03:59.505994,undefined,::,OB_MYSQL,LOGIN,failed,-4124,1,0,0,1,15330006us,0us,0us
2022-02-28 00:03:59.506082,undefined,obcluster:sys:,OB_MYSQL,LOGIN,failed,-4152,1,0,0,0,2357us,0us,0us
2022-02-28 00:04:59.500127,undefined,obcluster:sys:,OB_MYSQL,LOGIN,failed,-4152,1,0,0,0,2395us,0us,0us
2022-02-28 00:05:59.500084,undefined,obcluster:sys:,OB_MYSQL,LOGIN,failed,-4152,1,0,0,0,2377us,0us,0us
2022-02-28 00:15:59.516561,undefined,obcluster:sys:,OB_MYSQL,LOGIN,failed,-4152,1,0,0,0,2376us,0us,0us
2022-02-28 00:16:59.500248,undefined,obcluster:sys:,OB_MYSQL,LOGIN,failed,-4152,2,0,0,0,4540us,0us,0us
2022-02-28 00:20:59.499768,undefined,obcluster:sys:,OB_MYSQL,LOGIN,failed,-4152,1,0,0,0,2387us,0us,0us
2022-02-28 00:21:59.499826,undefined,obcluster:sys:,OB_MYSQL,LOGIN,failed,-4152,1,0,0,0,2424us,0us,0us
2022-03-13 05:52:59.517110,undefined,obcluster:sys:,OB_MYSQL,LOGIN,failed,-4152,1,1,0,0,87031us,0us,0us
2022-03-13 05:54:59.493912,undefined,obcluster:sys:,OB_MYSQL,LOGIN,failed,-4152,1,0,0,0,20885us,0us,0us
2022-03-13 05:55:59.505562,undefined,obcluster:sys:,OB_MYSQL,LOGIN,failed,-4152,1,0,0,0,2417us,0us,0us
2022-03-13 05:58:59.497566,undefined,obcluster:sys:,OB_MYSQL,LOGIN,failed,-4152,1,0,0,0,5337us,0us,0us
2022-03-13 06:03:59.499877,undefined,obcluster:sys:,OB_MYSQL,LOGIN,failed,-4152,3,0,0,0,7595us,0us,0us
2022-03-13 06:13:59.498290,undefined,obcluster:sys:,OB_MYSQL,LOGIN,failed,-4152,1,0,0,0,8836us,0us,0us
[admin@oceanbase log]$ cat obproxy_digest.log
2022-03-13 06:03:03.746289,undefined,obcluster:sys:,OB_MYSQL,OB_MYSQL_COM_LOGIN,failed,-4152,2783us,0us,0us,0us,Y0-2B1D62AF73A0,0,
2022-03-13 06:03:13.726361,undefined,obcluster:sys:,OB_MYSQL,OB_MYSQL_COM_LOGIN,failed,-4152,2455us,0us,0us,0us,Y0-2B1D651BB3A0,0,
2022-03-13 06:03:27.171419,undefined,obcluster:sys:,OB_MYSQL,OB_MYSQL_COM_LOGIN,failed,-4152,2357us,0us,0us,0us,Y0-2B1D62AF73A0,0,
2022-03-13 06:13:12.519196,undefined,obcluster:sys:,OB_MYSQL,OB_MYSQL_COM_LOGIN,failed,-4152,7843us,0us,0us,0us,Y0-2ABECC6173A0,0,
2022-03-13 06:13:56.406303,undefined,obcluster:sys:,OB_MYSQL,OB_MYSQL_COM_LOGIN,failed,-4152,8836us,0us,0us,0us,Y0-2BAA560503A0,0,