help request: Multiple mysql proxy stream_proxy

[samsu-lb]

Description

The first one forwards mysql and port 9500 can run normally. The second forwarding mysql, port 9400 failed to run, Doesn't it support multiple TCP ports to enable forwarding?

Configuration related: stream_proxy: # TCP/UDP proxy tcp: # TCP proxy address list

• 9500
• 9400

services: apisix: image: apache/apisix:${APISIX_IMAGE_TAG:-3.7.0-debian} restart: always volumes:

• ./apisix_conf/config.yaml:/usr/local/apisix/conf/config.yaml:ro
• ./apisix_conf/ngx_tpl.lua:/usr/local/apisix/apisix/cli/ngx_tpl.lua:ro
• ./apisix_conf/plugins:/usr/local/apisix/apisix/plugins
• /project/apisix/logs:/usr/local/apisix/logs

  network_mode: host

  ports:

• "9180:9180/tcp"
• "9080:9080/tcp"
• "9091:9091/tcp"
• "9443:9443/tcp"
• "9092:9092/tcp"
• "9500:9500/tcp"
• "9400:9400/tcp"
• "9600:9600/udp" networks: apisix:

Server ports 9400 and 9500 have been started normally

The first one that works normally 9500 port： { "upstream": { "nodes": { "mysql-1": 1 }, "type": "roundrobin" } }

The second one doesn’t work properly 9400 port: { "server_port":9400, "upstream": { "nodes": { "mysql-2": 1 }, "type": "roundrobin" } }

Environment

• APISIX version (run apisix version): apache/apisix:3.7.0-debian
• Operating system (run uname -a): Linux ip-10-10-8-120 6.2.0-1017-aws #17~22.04.1-Ubuntu SMP Fri Nov 17 21:07:13 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux
• OpenResty / Nginx version (run openresty -V or nginx -V): nginx:1.19.0-alpine
• etcd version, if relevant (run curl http://127.0.0.1:9090/v1/server_info): bitnami/etcd:3.4.15
• APISIX Dashboard version, if relevant:
• Plugin runner version, for issues related to plugin runners:
• LuaRocks version, for installation issues (run luarocks --version):

[shreemaan-abhishek]

are there any error logs? Please provide self contained examples so that it's easier to reproduce this bug.

[samsu-lb]

Thanks for the reply, client connection log：

No relevant files were found after the stream log was enabled. Configuration: nginx_config: stream: enabled: true access_log_format: >

[shreemaan-abhishek]

I would appreciate step by step example that leads to this error.

[samsu-lb]

Build apisix and forward multiple mysql instances through streams through multiple tcp ports to achieve the above problems