[debian-mysql] Bug#1001385: Bug#1001385: mariadb-client-10.5: authentification fails while the credentials are ok

[Faustin Lammler]

I am able to reproduce this and it looks indeed like a bug (but not
related to Debian packaging IMO, so it should be reported upstream, see
below).

Here is a snippet to reproduce.

| #!/bin/bash
|
| # clean
| systemctl stop mariadb
| rm -rf /var/lib/mysql
| mysql_install_db
| systemctl start mariadb
|
| # create user and db
| typeset -r VAR_PWD=$(pwgen 128 1)
| mariadb -e "create database testbug;"
| mariadb -e "grant all privileges on testbug.* to 'testbug'@'127.0.0.1' identified by '$VAR_PWD';"
| mariadb -h 127.0.0.1 -u testbug -p"$VAR_PWD" -e "show databases;"

See the following:
| root at a77afbebd41d:# bash -x t.sh
| + systemctl stop mariadb
| + rm -rf /var/lib/mysql
| + mysql_install_db
| Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
| OK
| ...
| + systemctl start mariadb
| ++ pwgen 128 1
| + typeset -r VAR_PWD=niovooChie7oomefoohat0fah8Foo8muDaethee4iakeithu9ahM4eeveib4goa6deixo6joo6ofedies6Taa2ua3looziek5caixohPhai8OhGeemieweesei8Veiy0
| + mariadb -e 'create database testbug;'
| + mariadb -e 'grant all privileges on testbug.* to '\''testbug'\''@'\''127.0.0.1'\'' identified by '\''niovooChie7oomefoohat0fah8Foo8muDaethee4iakeithu9ahM4eeveib4goa6deixo6joo6ofedies6Taa2ua3looziek5caixohPhai8OhGeemieweesei8Veiy0'\'';'
| + mariadb -h 127.0.0.1 -u testbug -pniovooChie7oomefoohat0fah8Foo8muDaethee4iakeithu9ahM4eeveib4goa6deixo6joo6ofedies6Taa2ua3looziek5caixohPhai8OhGeemieweesei8Veiy0 -e 'show databases;'
| +--------------------+
| | Database           |
| +--------------------+
| | information_schema |
| | test               |
| | testbug            |
| +--------------------+

This works as expected:
| root at a77afbebd41d:# mariadb -h 127.0.0.1 -u testbug -pniovooChie7oomefoohat0fah8Foo8muDaethee4iakeithu9ahM4eeveib4goa6deixo6joo6ofedies6Taa2ua3looziek5caixohPhai8OhGeemieweesei8Veiy0 -e 'show databases;'
| +--------------------+
| | Database           |
| +--------------------+
| | information_schema |
| | test               |
| | testbug            |
| +--------------------+

This not (tty ask the password):
| root at a77afbebd41d:# mysql -h 127.0.0.1 -u testbug -p
| Enter password:
| ERROR 1045 (28000): Access denied for user 'testbug'@'localhost' (using password: YES)

I can't reproduce this with smaller password (with 'pwgen 64 1' for
instance).

Can I ask you to:
- verify if there is a similar issue upstream (jira.mariadb.org) and
  report it in case you do not find something similar;
- forward this bug report to the upstream issue.

Thanks!

--
Faustin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: not available
URL: <http://alioth-lists.debian.net/pipermail/pkg-mysql-maint/attachments/20211209/3c12860e/attachment-0001.sig>