[Maria-discuss] Weird behavior in Fedora 34 server
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
What I get installed instead is:
$ mysql --version mysql Ver 8.0.27 for Linux on x86_64 (Source distribution)
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?
Thanks!
Hi Miguel,
On Thu, Dec 30, 2021 at 10:26 AM Miguel Lavalle miguel@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.
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... "
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-fe.... 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@mariadb.org wrote:
Hi Miguel,
On Thu, Dec 30, 2021 at 10:26 AM Miguel Lavalle miguel@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.
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@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..."
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-fe.... 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@mariadb.org wrote:
Hi Miguel,
On Thu, Dec 30, 2021 at 10:26 AM Miguel Lavalle miguel@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.
On Fri, Dec 31, 2021 at 12:31 PM Daniel Black daniel@mariadb.org wrote:
There's no reported bug of this on bugzilla.redhat.com either, so if you have time, please report there too.
Actually found it - https://bugzilla.redhat.com/show_bug.cgi?id=2026933
Installing the mariadb package explicitly is a good workaround for my situation. Thanks
On Thu, Dec 30, 2021 at 7:36 PM Daniel Black daniel@mariadb.org wrote:
On Fri, Dec 31, 2021 at 12:31 PM Daniel Black daniel@mariadb.org wrote:
There's no reported bug of this on bugzilla.redhat.com either, so if you have time, please report there too.
Actually found it - https://bugzilla.redhat.com/show_bug.cgi?id=2026933
Ha, I failed to see this reply, so will close https://bugzilla.redhat.com/show_bug.cgi?id=2036572 as a duplicate of this original one.
Honza
On Fri, Dec 31, 2021 at 2:37 AM Daniel Black daniel@mariadb.org wrote:
On Fri, Dec 31, 2021 at 12:31 PM Daniel Black daniel@mariadb.org wrote:
There's no reported bug of this on bugzilla.redhat.com either, so if you have time, please report there too.
Actually found it - https://bugzilla.redhat.com/show_bug.cgi?id=2026933
_______________________________________________ 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
Thanks Honza,
Nice proposal - https://fedoraproject.org/wiki/Changes/MariaDB_MySQL_Renaming
It looks like you'll need (or would be easier with): * a build option that prevents symlinks being created.
Are there packaging that don't build on mariadb-connector-c ?
Anything else?
On Mon, Jan 3, 2022 at 10:18 PM Honza Horak hhorak@redhat.com wrote:
Ha, I failed to see this reply, so will close https://bugzilla.redhat.com/show_bug.cgi?id=2036572 as a duplicate of this original one.
Honza
On Fri, Dec 31, 2021 at 2:37 AM Daniel Black daniel@mariadb.org wrote:
On Fri, Dec 31, 2021 at 12:31 PM Daniel Black daniel@mariadb.org wrote:
Actually found it - https://bugzilla.redhat.com/show_bug.cgi?id=2026933
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@mariadb.org 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@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... "
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-fe.... 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@mariadb.org wrote:
Hi Miguel,
On Thu, Dec 30, 2021 at 10:26 AM Miguel Lavalle miguel@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
participants (3)
-
Daniel Black -
Honza Horak -
Miguel Lavalle