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

Support for faking server version

Details

    • Task
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.2.0
    • OTHER
    • None
    • 10.2.0-1

    Description

      The official MySQL server returns version string like this:
      5.5.25-log
      While (latest stable) MariaDB:
      10.0.17-MariaDB-1~wheezy-log

      Some old and crappy CMS installations break with the MariaDB string above, like Joomla til API17:

        public function hasUTF()
      		 
        {
      		 
          $verParts = explode('.', $this->getVersion());
      		 
          return ($verParts[0] == 5 || ($verParts[0] == 4 && $verParts[1] == 1 && (int)$verParts[2] >= 2));
      		 
        }

      MariaDB is told to be a drop-in replacement for MySQL. In this case it is unfortunately not true. Patching the already installed webapps is usually not an option for administrators.

      For this reason I recommend to add a new configuration option, something like this into mysqld section of the config file:
      fake_version=5.5.25-log

      With this option set, MariaDB could return the faked version string.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10541 Faking the version string only works with MariaDB-Clients

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10982 Faking the server version also changes version number logged to error log

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-7365 Option to hide server version

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9593 Print the real version in the error log

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11113 Server with binary logging refuses to start with a vague error if fake version does not match X.Y pattern

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Task - A task that needs to be done. MDEV-12816 Please extend fake server version feature to fake version_comment as well

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. CONJ-321 Handle 10.2 server "forced" version

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10967 Print the real version in the error log #2

          • Major - Major loss of function.
          • Closed
          links to

          Web Link Github revision

          Activity

            Ascending order - Click to sort in descending order
            imre.rad Imre Rad created issue -
            imre.rad Imre Rad made changes -
            Field Original Value New Value
            Summary Feaute request: support for faking server version Feature request: support for faking server version
            elenst Elena Stepanova made changes -
            Affects Version/s 10.0.17 [ 18300 ]
            Environment irrelevant
            Issue Type Bug [ 1 ] Task [ 3 ]
            elenst Elena Stepanova made changes -
            Fix Version/s 10.0 [ 16000 ]
            serg Sergei Golubchik made changes -
            Description The official MySQL server returns version string like this:
            5.5.25-log
            While (latest stable) MariaDB:
            10.0.17-MariaDB-1~wheezy-log

            Some old and crappy CMS installations break with the MariaDB string above, like Joomla til API17:

            public function hasUTF()
            {
            $verParts = explode('.', $this->getVersion());
            return ($verParts[0] == 5 || ($verParts[0] == 4 && $verParts[1] == 1 && (int)$verParts[2] >= 2));
            }

            MariaDB is told to be a drop-in replacement for MySQL. In this case it is unfortunately not true. Patching the already installed webapps is usually not an option for administrators.

            For this reason I recommend to add a new configuration option, something like this into mysqld section of the config file:
            fake_version=5.5.25-log

            With this option set, MariaDB could return the faked version string.             		The official MySQL server returns version string like this:
            5.5.25-log
            While (latest stable) MariaDB:
            10.0.17-MariaDB-1~wheezy-log

            Some old and crappy CMS installations break with the MariaDB string above, like Joomla til API17:
            {code}
              public function hasUTF()
              {
                $verParts = explode('.', $this->getVersion());
                return ($verParts[0] == 5 || ($verParts[0] == 4 && $verParts[1] == 1 && (int)$verParts[2] >= 2));
              }
            {code}
            MariaDB is told to be a drop-in replacement for MySQL. In this case it is unfortunately not true. Patching the already installed webapps is usually not an option for administrators.

            For this reason I recommend to add a new configuration option, something like this into mysqld section of the config file:
            fake_version=5.5.25-log

            With this option set, MariaDB could return the faked version string.
            serg Sergei Golubchik made changes -
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 60124 ] MariaDB v3 [ 63701 ]
            serg Sergei Golubchik made changes -
            Summary Feature request: support for faking server version Support for faking server version
            serg Sergei Golubchik made changes -
            Priority Trivial [ 5 ] Minor [ 4 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.0 [ 16000 ]
            serg Sergei Golubchik added a comment -

            We can simply make @@version writable (from the command-line, not run-time)

            serg Sergei Golubchik added a comment - We can simply make @@version writable (from the command-line, not run-time)
            serg Sergei Golubchik made changes -
            Fix Version/s 10.2 [ 14601 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.0-1 [ 21 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            ratzpo Rasmus Johansson (Inactive) made changes -
            Assignee Sergey Vojtovich [ svoj ]
            svoj Sergey Vojtovich added a comment -

            serg, please review patch for this task.

            svoj Sergey Vojtovich added a comment - serg , please review patch for this task.
            svoj Sergey Vojtovich made changes -
            Assignee Sergey Vojtovich [ svoj ] Sergei Golubchik [ serg ]
            Status Open [ 1 ] In Review [ 10002 ]
            svoj Sergey Vojtovich added a comment -

            serg, please disregard first patch, it's incorrect. Will send updated version ASAP.

            svoj Sergey Vojtovich added a comment - serg , please disregard first patch, it's incorrect. Will send updated version ASAP.
            svoj Sergey Vojtovich added a comment -

            serg, patch updated.

            svoj Sergey Vojtovich added a comment - serg , patch updated.
            svoj Sergey Vojtovich added a comment -

            serg, test case extended as requested.

            svoj Sergey Vojtovich added a comment - serg , test case extended as requested.
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Sergey Vojtovich [ svoj ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            svoj Sergey Vojtovich added a comment -

            serg, test case updated.

            svoj Sergey Vojtovich added a comment - serg , test case updated.
            svoj Sergey Vojtovich made changes -
            Assignee Sergey Vojtovich [ svoj ] Sergei Golubchik [ serg ]
            Status Stalled [ 10000 ] In Review [ 10002 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Sergey Vojtovich [ svoj ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            svoj Sergey Vojtovich made changes -
            svoj Sergey Vojtovich made changes -
            Fix Version/s 10.2.0 [ 20700 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            elenst Elena Stepanova made changes -
            diego dupin Diego Dupin made changes -
            hholzgra Hartmut Holzgraefe made changes -
            hholzgra Hartmut Holzgraefe made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            tanj Guillaume Lefranc made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 63701 ] MariaDB v4 [ 132582 ]
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 196707
            serg Sergei Golubchik added a comment -

            Documentation: https://mariadb.com/kb/en/server-system-variables/#version

            serg Sergei Golubchik added a comment - Documentation: https://mariadb.com/kb/en/server-system-variables/#version

            People

              svoj Sergey Vojtovich
              imre.rad Imre Rad
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.