>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 <mig...@mlavalle.com> 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 <dan...@mariadb.org> wrote: >> >> Hi Miguel, >> >> On Thu, Dec 30, 2021 at 10:26 AM Miguel Lavalle <mig...@mlavalle.com> 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
