ocp4.0创建的obproxy集群连接不上ob集群

【 使用环境 】测试环境
【 OB or 其他组件 】
【 使用版本 】ocp-4.0.0-ce-x86_64 oceanbase-ce-4.0.0.0-100000282022112511 obproxy-ce-4.0.0-5
【问题描述】不通过obproxy可连接上OceanBase root@sys和obproxyro都正常且有密码,但是通过ocp创建的obproxy集群无法连接oceanbase,日志里全是如下的报错:ob_proxy_test_dev,::,OB_MYSQL,OB_MYSQL_COM_LOGIN,failed,-4124,155us,0us,0us,0us,Y0-00007F5377BFB3A0,0,
通过mysql客户端连接报错信息:Access denied for user ‘root@sys’@‘xx.xx.xx.xx’ (using password: YES)
【附件】

之前有手动改过proxy对应租户密码之类的操作么

初始proxy密码是空的,后面手动加了密码,密码箱里的密码也更新过了。也有尝试更新proxy集群里的observer_sys_password参数,都没有用。

参考下这章节的内容ocp重新感知集群密码信息,另外一般通过ocp管理集群后,不要手动去操作集群,尽量都通过ocp来管理,修改密码等操作也一样

我ob集群也是ocp部署的,然后proxyro租户在ocp没有修改密码按钮,然后密码因为是空的感觉不安全,所以我才去数据库里改的。

通过上面的文档能解决前面的问题么,这个后面再反馈给ocp的同事看看

更新了,但好像还是不行,也重启过obproxy了
image

这个修改是修改全局的proxyro密码,包括了obproxy和oceanbase集群中的密码配置,因为obproxy和ob集群可能是一对多的关系,所以是一起修改的,在白屏没有提供页面,提供了一个接口来触发任务,连接不上的报错信息看是root账号Access denied,帮忙再确认下和直连确实使用的是相同的密码,另外,obproxy的日志也可以提供一下,看下里面有没有什么报错信息
再确认下,oceanbase集群也是通过ocp先部署起来的吧,在创建obproxy的时候选择了关联这个oceanbase集群了吗

密码是相同的,oceanbase是用ocp部署的,创建obproxy的时候关联了ob集群。


obproxy.log
[2022-12-26 13:07:18.376587] WARN [PROXY] get_cluster_name (ob_session_field_mgr.cpp:617) [33894][Y0-00007FB939D263A0] [lt=7] [dc=0] fail to get cluster name(ret=-4018)

[2022-12-26 13:07:18.376789] WARN [PROXY.SM] tunnel_handler_client (ob_mysql_sm.cpp:5462) [33894][Y0-00007FB939D263A0] [lt=12] [dc=0] ObMysqlSM::tunnel_handler_client(event=“VC_EVENT_EOS”, sm_id=6229)

[2022-12-26 13:07:18.376808] WARN [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:7314) [33894][Y0-00007FB939D263A0] [lt=15] [dc=0] client will abort soon(sm_id=6229, cs_id=6224, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={127.0.0.1:24980}, server_ip={Not IP address [0]:0}, cluster_name=, tenant_name=, user_name=, db=, event=“VC_EVENT_EOS”, request_cmd=“Sleep”, sql_cmd=“Delete session”, sql=OB_MYSQL_COM_HANDSHAKE)

[2022-12-26 13:07:19.434508] WARN [PROXY] get_cluster_name (ob_session_field_mgr.cpp:617) [33894][Y0-00007FB93A1263A0] [lt=6] [dc=0] fail to get cluster name(ret=-4018)

[2022-12-26 13:07:19.434738] WARN [PROXY.SM] tunnel_handler_client (ob_mysql_sm.cpp:5462) [33894][Y0-00007FB93A1263A0] [lt=21] [dc=0] ObMysqlSM::tunnel_handler_client(event=“VC_EVENT_EOS”, sm_id=6230)

[2022-12-26 13:07:19.434758] WARN [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:7314) [33894][Y0-00007FB93A1263A0] [lt=17] [dc=0] client will abort soon(sm_id=6230, cs_id=6225, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={127.0.0.1:24982}, server_ip={Not IP address [0]:0}, cluster_name=, tenant_name=, user_name=, db=, event=“VC_EVENT_EOS”, request_cmd=“Sleep”, sql_cmd=“Delete session”, sql=OB_MYSQL_COM_HANDSHAKE)

[2022-12-26 13:07:20.379912] WARN [PROXY] get_cluster_name (ob_session_field_mgr.cpp:617) [33894][Y0-00007FB939D263A0] [lt=8] [dc=0] fail to get cluster name(ret=-4018)

[2022-12-26 13:07:20.380141] WARN [PROXY.SM] tunnel_handler_client (ob_mysql_sm.cpp:5462) [33894][Y0-00007FB939D263A0] [lt=16] [dc=0] ObMysqlSM::tunnel_handler_client(event=“VC_EVENT_EOS”, sm_id=6231)

[2022-12-26 13:07:20.380216] WARN [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:7314) [33894][Y0-00007FB939D263A0] [lt=71] [dc=0] client will abort soon(sm_id=6231, cs_id=6226, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={127.0.0.1:24984}, server_ip={Not IP address [0]:0}, cluster_name=, tenant_name=, user_name=, db=, event=“VC_EVENT_EOS”, request_cmd=“Sleep”, sql_cmd=“Delete session”, sql=OB_MYSQL_COM_HANDSHAKE)

[2022-12-26 13:07:20.525439] WARN [PROXY] get_cluster_name (ob_session_field_mgr.cpp:617) [33894][Y0-00007FB93A1263A0] [lt=8] [dc=0] fail to get cluster name(ret=-4018)

[2022-12-26 13:07:20.525848] WARN [PROXY.SM] tunnel_handler_client (ob_mysql_sm.cpp:5462) [33894][Y0-00007FB93A1263A0] [lt=28] [dc=0] ObMysqlSM::tunnel_handler_client(event=“VC_EVENT_EOS”, sm_id=6232)

[2022-12-26 13:07:20.525963] WARN [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:7314) [33894][Y0-00007FB93A1263A0] [lt=111] [dc=0] client will abort soon(sm_id=6232, cs_id=6227, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={127.0.0.1:24986}, server_ip={Not IP address [0]:0}, cluster_name=, tenant_name=, user_name=, db=, event=“VC_EVENT_EOS”, request_cmd=“Sleep”, sql_cmd=“Delete session”, sql=OB_MYSQL_COM_HANDSHAKE)

[2022-12-26 13:07:21.584398] WARN [PROXY] get_cluster_name (ob_session_field_mgr.cpp:617) [33894][Y0-00007FB939D263A0] [lt=5] [dc=0] fail to get cluster name(ret=-4018)

[2022-12-26 13:07:21.584642] WARN [PROXY.SM] tunnel_handler_client (ob_mysql_sm.cpp:5462) [33894][Y0-00007FB939D263A0] [lt=12] [dc=0] ObMysqlSM::tunnel_handler_client(event=“VC_EVENT_EOS”, sm_id=6233)

[2022-12-26 13:07:21.584669] WARN [PROXY.SM] set_client_abort (ob_mysql_sm.cpp:7314) [33894][Y0-00007FB939D263A0] [lt=24] [dc=0] client will abort soon(sm_id=6233, cs_id=6228, proxy_sessid=0, ss_id=0, server_sessid=0, client_ip={127.0.0.1:24988}, server_ip={Not IP address [0]:0}, cluster_name=, tenant_name=, user_name=, db=, event=“VC_EVENT_EOS”, request_cmd=“Sleep”, sql_cmd=“Delete session”, sql=OB_MYSQL_COM_HANDSHAKE)

obproxy_stat.log
2022-12-26 12:46:59.499713,ob_proxy_test_dev,::,OB_MYSQL,LOGIN,failed,-4124,3,0,0,0,673us,0us,0us

2022-12-26 12:47:59.500019,ob_proxy_test_dev,::,OB_MYSQL,LOGIN,failed,-4124,7,0,0,0,1754us,0us,0us

2022-12-26 12:48:59.499287,ob_proxy_test_dev,::,OB_MYSQL,LOGIN,failed,-4124,2,0,0,0,260us,0us,0us

2022-12-26 12:49:59.500042,ob_proxy_test_dev,::,OB_MYSQL,LOGIN,failed,-4124,6,0,0,0,747us,0us,0us

2022-12-26 12:50:59.499964,ob_proxy_test_dev,::,OB_MYSQL,LOGIN,failed,-4124,9,0,0,0,1629us,0us,0us

2022-12-26 12:51:59.499405,ob_proxy_test_dev,::,OB_MYSQL,LOGIN,failed,-4124,1,0,0,0,127us,0us,0us

2022-12-26 12:52:59.499321,ob_proxy_test_dev,::,OB_MYSQL,LOGIN,failed,-4124,5,0,0,0,777us,0us,0us

2022-12-26 12:53:59.499124,ob_proxy_test_dev,::,OB_MYSQL,LOGIN,failed,-4124,3,0,0,0,423us,0us,0us

2022-12-26 12:54:59.516912,ob_proxy_test_dev,::,OB_MYSQL,LOGIN,failed,-4124,6,0,0,0,798us,0us,0us

2022-12-26 12:55:59.499940,ob_proxy_test_dev,::,OB_MYSQL,LOGIN,failed,-4124,2,0,0,0,258us,0us,0us

2022-12-26 12:56:59.517073,ob_proxy_test_dev,::,OB_MYSQL,LOGIN,failed,-4124,5,0,0,0,1439us,0us,0us

2022-12-26 12:57:59.500426,ob_proxy_test_dev,::,OB_MYSQL,LOGIN,failed,-4124,4,0,0,0,1261us,0us,0us

2022-12-26 12:58:59.516643,ob_proxy_test_dev,::,OB_MYSQL,LOGIN,failed,-4124,6,0,0,0,1779us,0us,0us

2022-12-26 12:59:59.499125,ob_proxy_test_dev,::,OB_MYSQL,LOGIN,failed,-4124,4,0,0,0,958us,0us,0us

2022-12-26 13:00:59.500675,ob_proxy_test_dev,::,OB_MYSQL,LOGIN,failed,-4124,4,0,0,0,1178us,0us,0us

2022-12-26 13:01:59.499393,ob_proxy_test_dev,::,OB_MYSQL,LOGIN,failed,-4124,2,0,0,0,770us,0us,0us

2022-12-26 13:02:59.500103,ob_proxy_test_dev,::,OB_MYSQL,LOGIN,failed,-4124,4,0,0,0,1126us,0us,0us

2022-12-26 13:03:59.499178,ob_proxy_test_dev,::,OB_MYSQL,LOGIN,failed,-4124,5,0,0,0,688us,0us,0us

2022-12-26 13:03:59.499276,ob_proxy_test_dev,ob_cluster_test_dev:sys:,OB_MYSQL,LOGIN,failed,-4016,1,0,0,0,299us,0us,0us

2022-12-26 13:04:59.499717,ob_proxy_test_dev,::,OB_MYSQL,LOGIN,failed,-4124,3,0,0,0,399us,0us,0us

2022-12-26 13:05:59.499796,ob_proxy_test_dev,::,OB_MYSQL,LOGIN,failed,-4124,3,0,0,0,330us,0us,0us

2022-12-26 13:06:59.516729,ob_proxy_test_dev,::,OB_MYSQL,LOGIN,failed,-4124,4,0,0,0,592us,0us,0us

2022-12-26 13:06:59.516824,ob_proxy_test_dev,ob_cluster_test_dev:sys:,OB_MYSQL,LOGIN,failed,-4016,1,0,0,0,417us,0us,0us

obproxy_digest.log
2022-12-26 13:03:12.471957,ob_proxy_test_dev,::,OB_MYSQL,OB_MYSQL_COM_LOGIN,failed,-4124,78us,0us,0us,0us,Y0-00007FB93A1263A0,0,

2022-12-26 13:03:36.949332,ob_proxy_test_dev,::,OB_MYSQL,OB_MYSQL_COM_LOGIN,failed,-4124,154us,0us,0us,0us,Y0-00007FB939D263A0,0,

2022-12-26 13:03:38.003550,ob_proxy_test_dev,::,OB_MYSQL,OB_MYSQL_COM_LOGIN,failed,-4124,167us,0us,0us,0us,Y0-00007FB93A1263A0,0,

2022-12-26 13:03:52.906389,ob_proxy_test_dev,::,OB_MYSQL,OB_MYSQL_COM_LOGIN,failed,-4124,103us,0us,0us,0us,Y0-00007FB939D263A0,0,

2022-12-26 13:03:56.192394,ob_proxy_test_dev,ob_cluster_test_dev:sys:,OB_MYSQL,OB_MYSQL_COM_LOGIN,failed,-4016,299us,0us,0us,0us,Y0-00007FB93A1263A0,0,

2022-12-26 13:04:00.383017,ob_proxy_test_dev,::,OB_MYSQL,OB_MYSQL_COM_LOGIN,failed,-4124,142us,0us,0us,0us,Y0-00007FB93A1263A0,0,

2022-12-26 13:04:21.682789,ob_proxy_test_dev,::,OB_MYSQL,OB_MYSQL_COM_LOGIN,failed,-4124,150us,0us,0us,0us,Y0-00007FB93A1263A0,0,

2022-12-26 13:04:25.946373,ob_proxy_test_dev,::,OB_MYSQL,OB_MYSQL_COM_LOGIN,failed,-4124,107us,0us,0us,0us,Y0-00007FB939D263A0,0,

2022-12-26 13:05:13.866279,ob_proxy_test_dev,::,OB_MYSQL,OB_MYSQL_COM_LOGIN,failed,-4124,127us,0us,0us,0us,Y0-00007FB939D263A0,0,

2022-12-26 13:05:40.475627,ob_proxy_test_dev,::,OB_MYSQL,OB_MYSQL_COM_LOGIN,failed,-4124,118us,0us,0us,0us,Y0-00007FB939D263A0,0,

2022-12-26 13:05:56.387063,ob_proxy_test_dev,::,OB_MYSQL,OB_MYSQL_COM_LOGIN,failed,-4124,85us,0us,0us,0us,Y0-00007FB93A1263A0,0,

2022-12-26 13:06:22.040110,ob_proxy_test_dev,::,OB_MYSQL,OB_MYSQL_COM_LOGIN,failed,-4124,115us,0us,0us,0us,Y0-00007FB939D263A0,0,

2022-12-26 13:06:29.480406,ob_proxy_test_dev,::,OB_MYSQL,OB_MYSQL_COM_LOGIN,failed,-4124,111us,0us,0us,0us,Y0-00007FB939D263A0,0,

2022-12-26 13:06:37.937009,ob_proxy_test_dev,::,OB_MYSQL,OB_MYSQL_COM_LOGIN,failed,-4124,170us,0us,0us,0us,Y0-00007FB939D263A0,0,

2022-12-26 13:06:53.327832,ob_proxy_test_dev,ob_cluster_test_dev:sys:,OB_MYSQL,OB_MYSQL_COM_LOGIN,failed,-4016,417us,0us,0us,0us,Y0-00007FB939D263A0,0,

2022-12-26 13:06:58.098160,ob_proxy_test_dev,::,OB_MYSQL,OB_MYSQL_COM_LOGIN,failed,-4124,196us,0us,0us,0us,Y0-00007FB93A1263A0,0,

这个日志中看到cluster_name, tenant_name, user_name, db都是空的,连接串中-u参数后面不可以直接写root,这样是不能识别的,-u的格式是username@tenantname#clustername, 需要按照这种格式写,example: root@sys#obcluster, 这样obproxy才能识别

可以了,是我格式没写全,谢谢了。那那些日志里的报错一直有,这个什么问题导致的?OB_MYSQL,LOGIN,failed

这个不太确定,还有其他连接吗

没有了,就日志里一直刷这些错误