proxy-protocol = "v2" doesn't work well

[shawn0915]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

tiproxy --config tiproxy.toml

[proxy]
require-backend-tls = false
proxy-protocol = "v2"

2. What did you expect to see? (Required)

3. What did you see instead (Required)

mysql --comments --host 127.0.0.1 --port 6000 -u root
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error: 0

4. What is your version? (Required)

tiproxy: main,
tidb: 7.0.0

[djshow832]

Did you turn on the TiDB proxy protocol?
https://docs.pingcap.com/tidb/stable/command-line-flags-for-tidb-configuration#--proxy-protocol-networks

If this flag is left empty, no IP address can connect to TiDB using the PROXY protocol.

[shawn0915]

Did you turn on the TiDB proxy protocol? https://docs.pingcap.com/tidb/stable/command-line-flags-for-tidb-configuration#--proxy-protocol-networks

If this flag is left empty, no IP address can connect to TiDB using the PROXY protocol.

oh, ur right.
and, do you know how that show port :0?

mysql> \r
Connection id:    100
Current database: *** NONE ***

mysql> show processlist;
+--------------------+------+-------------+------+---------+------+------------+------------------+
| Id                 | User | Host        | db   | Command | Time | State      | Info             |
+--------------------+------+-------------+------+---------+------+------------+------------------+
| 151132271284322879 | root | 127.0.0.1:0 | NULL | Query   |    0 | autocommit | show processlist |
+--------------------+------+-------------+------+---------+------+------------+------------------+
1 row in set (0.01 sec)

[djshow832]

Did you turn on the TiDB proxy protocol? https://docs.pingcap.com/tidb/stable/command-line-flags-for-tidb-configuration#--proxy-protocol-networks

If this flag is left empty, no IP address can connect to TiDB using the PROXY protocol.

oh, ur right. and, do you know how that show port :0?

mysql> \r
Connection id:    100
Current database: *** NONE ***

mysql> show processlist;
+--------------------+------+-------------+------+---------+------+------------+------------------+
| Id                 | User | Host        | db   | Command | Time | State      | Info             |
+--------------------+------+-------------+------+---------+------+------------+------------------+
| 151132271284322879 | root | 127.0.0.1:0 | NULL | Query   |    0 | autocommit | show processlist |
+--------------------+------+-------------+------+---------+------+------------+------------------+
1 row in set (0.01 sec)

Good point. I didn't realize that yet. We'll investigate it and keep this issue. cc @xhebox

[xhebox]

Bug of tidb or go-proxyprotocol.