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
            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)
            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 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.
            svoj Sergey Vojtovich added a comment -

            serg, test case updated.

            svoj Sergey Vojtovich added a comment - serg , test case updated.
            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.