有个问题,OBproxy V4.3.5 ,我们使用NLB 做负载均衡 开启了Proxy Protocol。但是OBPROXY侧报错日志:[2026-11-17 15:23:40.695322] [895414][Y0-00007F10CF70DA10] [LOGIN](trace_type=“LOGIN_TRACE”, connection_diagnosis={cs_id:17039611, ss_id:0, proxy_session_id:0, server_session_id:0, client_addr:“10.40.xxx.xxx:42700”, server_addr:“Not IP address [0]:0”, proxy_server_addr:“Not IP address [0]:0”, cluster_name:"", tenant_name:"", user_name:"", error_code:-8205, error_msg:“virtual ip user @#undefined can not pass whitelist”, request_cmd:“OB_MYSQL_COM_LOGIN”, sql_cmd:“OB_MYSQL_COM_HANDSHAKE”, req_total_time(us):0}{internal_sql:"", login_result:“failed”})
[2026-11-17 15:23:41.718519] [895414][Y0-00007F10CF70DA10] [LOGIN](trace_type=“LOGIN_TRACE”, connection_diagnosis={cs_id:17039613, ss_id:0, proxy_session_id:0, server_session_id:0, client_addr:“10.40.xxx.xxx:42704”, server_addr:“Not IP address [0]:0”, proxy_server_addr:“Not IP address [0]:0”, cluster_name:"", tenant_name:"", user_name:"", error_code:-8205, error_msg:“virtual ip user @#undefined can not pass whitelist”, request_cmd:“OB_MYSQL_COM_LOGIN”, sql_cmd:“OB_MYSQL_COM_HANDSHAKE”, req_total_time(us):0}{internal_sql:"", login_result:“failed”})
ObProxy 解析 PPv2 头之后,在还不知道集群名和租户名的阶段做了 VIP 白名单校验,校验失败,ObProxy主动断开连接。 但是我在OBproxy中也没有看到对应vip 白名单的配置? 有什么解法吗?
SHOW PROXYCONFIG LIKE ‘rootservice_cluster_name’;
SHOW PROXYCONFIG LIKE ‘proxy_tenant_name’;
SELECT * FROM white_list;
这个信息查一下
mysql> show proxyconfig like ‘proxy_tenant_name’ ;
±------------------±------±-----------------------------------±------------±--------------±------±-------------+
| name | value | info | need_reboot | visible_level | range | config_level |
±------------------±------±-----------------------------------±------------±--------------±------±-------------+
| proxy_tenant_name | | default tenant name for cloud user | false | SYS | | LEVEL_VIP |
±------------------±------±-----------------------------------±------------±--------------±------±-------------+
1 row in set (0.00 sec)
mysql> show proxyconfig like ‘rootservice_cluster_name’ ;
±-------------------------±----------±-------------------------------------------------------------------------------------±------------±--------------±------±-------------+
| name | value | info | need_reboot | visible_level | range | config_level |
±-------------------------±----------±-------------------------------------------------------------------------------------±------------±--------------±------±-------------+
| rootservice_cluster_name | undefined | 1. default cluster name for rootservice_list; 2. default cluster name for cloud user | true | SYS | | LEVEL_VIP |
±-------------------------±----------±-------------------------------------------------------------------------------------±------------±--------------±------±-------------+
1 row in set (0.00 sec)
mysql> SELECT * FROM white_list;
Query OK, 0 rows affected (0.00 sec)
看了一下 这样确实是不支持的
关闭ppv2 又看不到源端IP地址是吧?无解?
是的 确实是不支持