Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-28910

remove the 5.5.5- version hack

Details

    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.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-4088 Replication 10.0 -> 5.5 fails

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MXS-4865 5.5.5- prefix should not be added if all backends are MariaDB 11

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28723 MySQL Connector fails to connect to MariaDB

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            serg Sergei Golubchik created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            serg Sergei Golubchik made changes -
            Fix Version/s 10.12 [ 28320 ]
            Fix Version/s 10.11 [ 27614 ]
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Assignee Sergei Golubchik [ serg ] Andrew Hutchings [ JIRAUSER52179 ]
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Assignee Andrew Hutchings [ JIRAUSER52179 ] Sergei Golubchik [ serg ]
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Comment [ Draft pull request open for this against 10.11 for now until we have somewhere to merge it. ]
            serg Sergei Golubchik made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            serg Sergei Golubchik made changes -
            Status Stalled [ 10000 ] In Testing [ 10301 ]
            ramesh Ramesh Sivaraman made changes -
            Assignee Sergei Golubchik [ serg ] Ramesh Sivaraman [ JIRAUSER48189 ]
            lstartseva Lena Startseva added a comment -

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

            lstartseva Lena Startseva added a comment - Check on MySQL Connector NET 8.0.31 in branch preview-11.0-preview - everything works well.
            ramesh Ramesh Sivaraman made changes -
            Assignee Ramesh Sivaraman [ JIRAUSER48189 ] Sergei Golubchik [ serg ]
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            ramesh Ramesh Sivaraman added a comment -

            lstartseva Thank you for testing this fix.

            ramesh Ramesh Sivaraman added a comment - lstartseva Thank you for testing this fix.
            serg Sergei Golubchik made changes -
            Fix Version/s 11.0.1 [ 28548 ]
            Fix Version/s 11.0 [ 28320 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels Preview_11.0
            allen.herrera Allen Herrera added a comment - - edited

            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.

            allen.herrera Allen Herrera added a comment - - edited 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.
            Richard Richard Stracke made changes -
            danblack Daniel Black added a comment -

            allen.herrera the fix version for community MariaDB 11.0.1

            danblack Daniel Black added a comment - allen.herrera the fix version for community MariaDB 11.0.1

            People

              serg Sergei Golubchik
              serg Sergei Golubchik
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.