maria-discuss team mailing list archive

[Honza Horak <hhorak@xxxxxxxxxx>]

I've reported that issue into Fedora tracker as
https://bugzilla.redhat.com/show_bug.cgi?id=2036572 because if anything
should change, it must be there.

What does not help is that it is not working the same way all the time, in
my empty fedora 34 container it installs mariadb as a dependency as
expected, even when I already have community-mysql-{libs,common} installed
there. Still, I suspect it likely depends on other packages installed.

Miguel, if you can still reproduce it, could you list packages you have
installed and that recommends or suggests either mysql or community-mysql?
(rpm -q --whatsuggests mysql --whatsuggests community-mysql
--whatrecommends mysql --whatrecommends community-mysql)

Thanks,
Honza

On Fri, Dec 31, 2021 at 2:31 AM Daniel Black <daniel@xxxxxxxxxxx> wrote:

> 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.
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>
>