Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.4.4
-
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
- blocks
-
MDEV-6284 Merge downstream Debian/Ubuntu packaging into upstream MariaDB
-
- Closed
-
- relates to
-
-
- Closed
-
-
-
- Closed
-