maria-discuss team mailing list archive

[Daniel Black <daniel@xxxxxxxxxxx>]

>From the openstack logs:


Failed to set locale, defaulting to C.UTF-8
Last metadata expiration check: 0:04:44 ago on Thu Dec 30 02:23:09 2021.
Dependencies resolved.
================================================================================
 Package                           Arch     Version             Repo       Size
================================================================================
Installing:
 mariadb-devel                     x86_64   3:10.5.13-1.fc34    updates   1.0 M
 mariadb-server                    x86_64   3:10.5.13-1.fc34    updates    10 M
Installing dependencies:
 community-mysql                   x86_64   8.0.27-1.fc34       updates   2.6 M
 community-mysql-common            x86_64   8.0.27-1.fc34       updates    70 k
 mariadb-common                    x86_64   3:10.5.13-1.fc34    updates    32 k
 mariadb-connector-c               x86_64   3.1.13-1.fc34       updates   199 k
 mariadb-connector-c-config        noarch   3.1.13-1.fc34       updates    11 k
 mariadb-connector-c-devel         x86_64   3.1.13-1.fc34       updates    55 k
 mariadb-errmsg                    x86_64   3:10.5.13-1.fc34    updates   187 k
 mysql-selinux                     noarch   1.0.4-2.fc34        updates    36 k
Installing weak dependencies:
 mariadb-backup                    x86_64   3:10.5.13-1.fc34    updates   6.4 M
 mariadb-cracklib-password-check   x86_64   3:10.5.13-1.fc34    updates    17 k
 mariadb-gssapi-server             x86_64   3:10.5.13-1.fc34    updates    19 k


So community-mysql is a dependency of mariadb-devel/server which is just nuts.

Its somwhere in
https://src.fedoraproject.org/rpms/mariadb/blob/f34/f/mariadb.spec#_322


(on fc35 which I have installed, and I assume fc34 is similar)

$ dnf deplist mariadb-server
package: mariadb-server-3:10.5.13-1.fc35.x86_64

...
  dependency: mysql(x86-64)
   provider: community-mysql-8.0.27-1.fc35.x86_64
   provider: mariadb-3:10.5.13-1.fc35.x86_64
  dependency: mysql-compat-client(x86-64)
   provider: community-mysql-8.0.27-1.fc35.x86_64
   provider: mariadb-3:10.5.13-1.fc35.x86_64


So I'd recommend explicitly installing the "mariadb" package
explicitly that provides the client side mysqladmin/mysql.


There's no reported bug of this on bugzilla.redhat.com either, so if
you have time, please report there too.



On Fri, Dec 31, 2021 at 11:01 AM Miguel Lavalle <miguel@xxxxxxxxxxxx> wrote:
>
> Hi,
>
> In both cases, I get the exact same output to the two following commands:
>
> $ rpm -qi mariadb-server
> Name        : mariadb-server
> Epoch       : 3
> Version     : 10.5.13
> Release     : 1.fc34
> Architecture: x86_64
> Install Date: Thu 30 Dec 2021 04:22:06 PM UTC
> Group       : Unspecified
> Size        : 71001174
> License     : GPLv2 and LGPLv2
> Signature   : RSA/SHA256, Thu 02 Dec 2021 03:32:29 PM UTC, Key ID 1161ae6945719a39
> Source RPM  : mariadb-10.5.13-1.fc34.src.rpm
> Build Date  : Thu 02 Dec 2021 01:13:13 PM UTC
> Build Host  : buildvm-x86-11.iad2.fedoraproject.org
> Packager    : Fedora Project
> Vendor      : Fedora Project
> URL         : http://mariadb.org
> Bug URL     : https://bugz.fedoraproject.org/mariadb
> Summary     : The MariaDB server and related files
> Description :
> MariaDB is a multi-user, multi-threaded SQL database server. It is a
> client/server implementation consisting of a server daemon (mariadbd)
> and many different client programs and libraries. This package contains
> the MariaDB server and some accompanying files and directories.
> MariaDB is a community developed fork from MySQL.
>
>
> $ which mysql
> /usr/bin/mysql
>
> The difference, though, is in the output to 'ls -l /usr/bin/mysqladmin':
>
> # Good case, in which I install mariadb before anything else and I can set root password with mysqladmin
> # Note that /usr/bin/mysqladmin is a link to mariadb-admin
> $ ls -l /usr/bin/mysqladmin
> lrwxrwxrwx. 1 root root 13 Dec  2 13:44 /usr/bin/mysqladmin -> mariadb-admin
>
> # Whereas in the bad case, in which mariadb is installed after vim and git and mysqladmin doesn't allow me
> # to set root password, /usr/bin/mysqladmin is an executable file and mariadb-admin is not installed
> $ ls /usr/bin/mysqladmin -l
> -rwxr-xr-x. 1 root root 6738168 Nov  1 01:52 /usr/bin/mysqladmin
> $ ls /usr/bin/mariadb-admin
> ls: cannot access '/usr/bin/mariadb-admin': No such file or directory
>
> I should probably also mention that:
>
> 1. I'm running these tests locally in VMs that I create with vagrant and I am using this box:
>
> config.vm.box_url = "https://download.fedoraproject.org/pub/fedora/linux/releases/34/Cloud/x86_64/images/Fedora-Cloud-Base-Vagrant-34-1.2.x86_64.vagrant-virtualbox.box";
>
> 2. I am replicating in my local environment this problem because it is manifesting itself in one of the OpenStack CI system job: https://zuul.openstack.org/builds?job_name=neutron-ovn-tempest-ovs-master-fedora. All those failures are due to this problem with mysqladmin. As it can be seen in the job's page, the problem started showing up on December 13th.
>
> Any ideas as to what might be the root problem?
>
> Thanks
>
> Miguel
>
> On Wed, Dec 29, 2021 at 7:43 PM Daniel Black <daniel@xxxxxxxxxxx> wrote:
>>
>> Hi Miguel,
>>
>> On Thu, Dec 30, 2021 at 10:26 AM Miguel Lavalle <miguel@xxxxxxxxxxxx> wrote:
>> >
>> > Hi,
>> >
>> > I am installing MariaDB in Fedora 34 server with the following sequence of commands:
>> >
>> > sudo dnf upgrade -y
>> > sudo dnf install -y mariadb-server mariadb-devel
>> > sudo dnf -y install git vim
>> >
>> > With this sequence of commands, I get the following installed:
>> >
>> > $ mysql --version
>> > mysql  Ver 15.1 Distrib 10.5.13-MariaDB, for Linux (x86_64) using  EditLine wrapper
>> >
>> > and I can successfully perform the initial setup of the root password:
>> >
>> > sudo mysqladmin -u root password password
>> >
>> > and continue with the rest of my installation.
>> >
>> > However, if I change the sequence of commands to:
>> >
>> > sudo dnf upgrade -y
>> > sudo dnf -y install git vim
>> > sudo dnf install -y mariadb-server mariadb-devel
>>
>> Odd -> $ repoquery --deplist git vim
>>
>> doesn't list anything pulling in MySQL.
>>
>> > What I get installed instead is:
>> >
>> > $ mysql --version
>> > mysql  Ver 8.0.27 for Linux on x86_64 (Source distribution)
>>
>> This looks like an Oracle mysql-client version. Do you have
>> community-mysql installed?
>>
>> > and the 'sudo mysqladmin -u root password password' command fails with:
>> >
>> > mysqladmin: unable to change password; error: 'You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '() IDENTIFIED BY 'secretdatabase'' at line 1'
>> >
>> > Could anyone shed some light on this?
>>
>> given mysql --version, the client version is showing 8.0.27,
>> mysqladmin is also probably the Oracle version and is speaking a
>> slightly different syntax to MariaDB.