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

10.2.12 libmariadb doesn't support old protocol

    XMLWordPrintable

    Details

      Description

      I have compiled mariadb 10.2.12 on Fedora 27 and tried connecting to the company's MySQL 3.23.58 server and it failed with:

      \$ mysql -h host -u username -p db
      Enter password:
      ERROR 2059 (HY000): Plugin old_password could not be loaded: /usr/lib64/mysql/plugin/old_password.so: cannot open shared object file: No such file or directory

      The first bug is that libmariadb/plugins/auth/my_auth.c wants to use the plugin called "old_password" but the plugin is called "mysql_old_password".

      After fixing this (the one-liner patch is attached), I was able to successfully connect to the server:

      \$ mysql -h host -u username -p db
      Enter password:
      Welcome to the MariaDB monitor. Commands end with ; or \g.
      Your MySQL connection id is 246
      Server version: 3.23.58

      Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

      The problem now is that any query I try to run prints a garbled output or this error:
      ERROR 2000 (HY000): Unknown MySQL error

        Attachments

          Activity

            People

            Assignee:
            serg Sergei Golubchik
            Reporter:
            zboszor Zoltán Böszörményi
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.