[MDEV-28910] remove the 5.5.5- version hack Created: 2022-06-20  Updated: 2023-11-16  Resolved: 2023-01-26

Status: Closed
Project: MariaDB Server
Component/s: Protocol
Fix Version/s: 11.0.1

Type: Task Priority: Critical
Reporter: Sergei Golubchik Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: Preview_11.0

Issue Links:
Relates
relates to MDEV-4088 Replication 10.0 -> 5.5 fails Closed
relates to MXS-4865 5.5.5- prefix should not be added if ... Closed
relates to MDEV-28723 MySQL Connector fails to connect to M... Closed

 Description   

it seems that this workaround is no longer necessary, the bug was fixed in MySQL 5.6 and 5.5 has long reached EOL.

this hack constantly creates problems with third-party tools and clients, so it'd be better to get rid of it.

 Comments   
Comment by Lena Startseva [ 2023-01-22 ]

Check on MySQL Connector NET 8.0.31 in branch preview-11.0-preview - everything works well.

Comment by Ramesh Sivaraman [ 2023-01-23 ]

lstartseva Thank you for testing this fix.

Comment by Allen Herrera [ 2023-11-13 ]

Enterprise 10.6.12-8 + still has an issue with displaying 5.5.5- prefixed.
Besides hardcoding "version=" in the /etc/my.cnf.d/server.cnf,
how can the real version be displayed?

Replicate

mariadb -e "create user root@'172.%.%.%' identified by 'aBcd123%123%aBc';"
 
mariadb -e "grant all on *.* to root@'172.%.%.%';"
 
yum install telnet
 
telnet 172.31.26.135 3306
 
Trying 172.31.26.135...
 
Connected to 172.31.26.135.
 
Escape character is '^]'.
 
f
 
5.5.5-10.6.12-8-MariaDB-enterprisez{xk->1x�,ng;.t#K0Mqrmysql_native_passwordConnection closed by foreign host.

UPDATE:
Retesting in 23.08.0 - appears fixed, so the community fixes not in the 10.6.xx minors which is expected i believe

Trying 172.31.26.135...
 
Connected to 172.31.26.135.
 
Escape character is '^]'.
 
^
 
23.08.0-MariaDB-enterprise
 
                          ],b+Kx<b�XqR&a<F-Jlb*mysql_native_password
 
 
 
8#HY000Proxy header is not accepted from 172.31.26.135Connection closed by foreign host.

Generated at Thu Feb 08 10:04:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.