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

Automate upgrades from MySQL 5.7 with auth_socket to MariaDB with our unix_socket

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.4.4
    • Fix Version/s: 10.4
    • Component/s: None
    • Labels:
      None

      Description

      I haven't checked what upstream MySQL 5.7 does, but since we implemented unix socket authentication in Debian MariaDB 10.0 the maintainers of MySQL 5.7 in Debian followed and also implemented their own version.

      However these versions are slightly different, have different plugin names etc.
      I wish MariaDB 10.4 (that now finally has upstream socket auth as well since https://jira.mariadb.org/browse/MDEV-12484) would include some kind of mariadb_upgrade magic that would detect usage of socket auth in MySQL 5.7 (or later) and convert that into something MariaDB can run with.

      Fixing this bug would solve also downstream Debian MySQL 5.7 -> MariaDB 10.x upgrades since I would backport the upstream mariadb_upgrade improvements myself.

      See current failure at e.g. https://salsa.debian.org/mariadb-team/mariadb-10.3/-/jobs/135254
      https://salsa.debian.org/mariadb-team/mariadb-10.3/-/jobs/135254/artifacts/file/debian/output/debug/var-log-mysql/mysql/error.log

      2019-02-27 17:34:43 0 [Note] InnoDB: Using Linux native AIO
      2019-02-27 17:34:43 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
      2019-02-27 17:34:43 0 [Note] InnoDB: Uses event mutexes
      2019-02-27 17:34:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
      2019-02-27 17:34:43 0 [Note] InnoDB: Number of pools: 1
      2019-02-27 17:34:43 0 [Note] InnoDB: Using SSE2 crc32 instructions
      2019-02-27 17:34:43 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
      2019-02-27 17:34:43 0 [Note] InnoDB: Completed initialization of buffer pool
      2019-02-27 17:34:43 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
      2019-02-27 17:34:43 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
      2019-02-27 17:34:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables
      2019-02-27 17:34:43 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
      2019-02-27 17:34:43 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
      2019-02-27 17:34:43 0 [Note] InnoDB: Waiting for purge to start
      2019-02-27 17:34:43 0 [Note] InnoDB: 10.3.13 started; log sequence number 2937057; transaction id 2317
      2019-02-27 17:34:43 0 [Note] Plugin 'FEEDBACK' is disabled.
      2019-02-27 17:34:43 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
      2019-02-27 17:34:43 0 [Note] InnoDB: Buffer pool(s) load completed at 190227 17:34:43
      ERROR: 1054  Unknown column 'Password' in 'user'
      2019-02-27 17:34:43 0 [ERROR] Aborting
      

       

      $ echo 'SHOW DATABASES;' | mariadb
      ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              otto Otto Kekäläinen
              Reporter:
              otto Otto Kekäläinen
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: