[MDEV-14977] 10.2.12 libmariadb doesn't support old protocol Created: 2018-01-17  Updated: 2024-01-04  Resolved: 2018-08-16

Status: Closed
Project: MariaDB Server
Component/s: Scripts & Clients
Affects Version/s: 10.2
Fix Version/s: 10.2.18

Type: Bug Priority: Major
Reporter: Zoltán Böszörményi Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: contribution

Attachments: File mariadb-fix-old-pass-auth.patch    

 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



 Comments   
Comment by Zoltán Böszörményi [ 2024-01-04 ]

This issue is closed but not fixed. While connection succeeds, queries do not, see the last part of the description:

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

Generated at Thu Feb 08 08:17:46 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.