Not sure what I’m doing wrong, I’m trying to download a specific version of mysql, I have installed MySQL repository configuration for yum but when I try to download 8.0.30 I still get packages from 8.0.40:
mysql:~ # zypper in -y --no-recommends mysql-community-server=8.0.30
Loading repository data...
Reading installed packages...
Resolving package dependencies...
The following 6 NEW packages are going to be installed:
mysql-community-client mysql-community-client-plugins mysql-community-common mysql-community-icu-data-files mysql-community-libs
mysql-community-server
6 new packages to install.
Package download size: 68.1 MiB
Package install size change:
| 508.2 MiB required by packages that will be installed
508.2 MiB | - 0 B released by packages that will be removed
Backend: classic_rpmtrans
Continue? [y/n/v/...? shows all options] (y): y
Retrieving: mysql-community-client-plugins-8.0.40-1.sles12.x86_64 (MySQL 8.0 Community Server) (1/6), 1.2 MiB
Retrieving: mysql-community-client-plugins-8.0.40-1.sles12.x86_64.rpm ......................................................................[done]
Retrieving: mysql-community-common-8.0.30-1.sles12.x86_64 (MySQL 8.0 Community Server) (2/6), 492.9 KiB
Retrieving: mysql-community-common-8.0.30-1.sles12.x86_64.rpm ..............................................................................[done]
Retrieving: mysql-community-icu-data-files-8.0.30-1.sles12.x86_64 (MySQL 8.0 Community Server) (3/6), 2.0 MiB
Retrieving: mysql-community-icu-data-files-8.0.30-1.sles12.x86_64.rpm ......................................................................[done]
Retrieving: mysql-community-libs-8.0.40-1.sles12.x86_64 (MySQL 8.0 Community Server) (4/6), 1.3 MiB
Retrieving: mysql-community-libs-8.0.40-1.sles12.x86_64.rpm ................................................................................[done]
Retrieving: mysql-community-client-8.0.40-1.sles12.x86_64 (MySQL 8.0 Community Server) (5/6), 2.8 MiB
Retrieving: mysql-community-client-8.0.40-1.sles12.x86_64.rpm ..............................................................................[done]
Retrieving: mysql-community-server-8.0.30-1.sles12.x86_64 (MySQL 8.0 Community Server) (6/6), 60.4 MiB
Retrieving: mysql-community-server-8.0.30-1.sles12.x86_64.rpm .................................................................[done (55.1 MiB/s)]
Checking for file conflicts: ...............................................................................................................[done]
(1/6) Installing: mysql-community-client-plugins-8.0.40-1.sles12.x86_64 ....................................................................[done]
warning: /var/cache/zypp/packages/mysql80-community/mysql-community-common-8.0.30-1.sles12.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
(2/6) Installing: mysql-community-common-8.0.30-1.sles12.x86_64 ............................................................................[done]
warning: /var/cache/zypp/packages/mysql80-community/mysql-community-icu-data-files-8.0.30-1.sles12.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
(3/6) Installing: mysql-community-icu-data-files-8.0.30-1.sles12.x86_64 ....................................................................[done]
(4/6) Installing: mysql-community-libs-8.0.40-1.sles12.x86_64 ..............................................................................[done]
(5/6) Installing: mysql-community-client-8.0.40-1.sles12.x86_64 ............................................................................[done]
warning: /var/cache/zypp/packages/mysql80-community/mysql-community-server-8.0.30-1.sles12.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
(6/6) Installing: mysql-community-server-8.0.30-1.sles12.x86_64 ............................................................................[done]
mysql:~ # mysql --version
mysql Ver 8.0.40 for Linux on x86_64 (MySQL Community Server - GPL)
I’ve already tried forcing resolution, with and without recommends and still no luck
--no-recommends won’t prevent dependencies that are needed from being installed. Apart from that this is a SLES12 package (which may or may not work on Leap 15.6, which is derived from SLE 15 SP6), your command-line specifies a version for mysql-community-server but not the other dependencies.
I would look at rpm -qa | grep mysql-community-server - if both are installed (which seems likely), it may be necessary to be more precise in executing the command. update-alternativesmay need to be used to select the 8.0.30 version of mysql by default.
You sir, are a genius. Actually your question piked my brain so much as to think: hmmm, what if I dig somewhere else.
And I found this archive that seems to have what I need:
Bear in mind that there are other options besides direct from the MySQL website; personally, I’d look at (and actually run) an instance in Docker. That gives you a lot of flexibility over what version you use, independent of the platform you’re running it on.
Unfortunately Docker is not an option atm, but it’s strange, Ican’t seem to force a single version, for example:
mysql:~ # zypper in --details mysql-community-server=8.0.30-1.sles12
Loading repository data...
Reading installed packages...
Resolving package dependencies...
The following 8 NEW packages are going to be installed:
libncurses5 6.1-150000.5.27.1 x86_64 Update repository with updates from SUSE Linux Enterprise 15 SUSE LLC <https://www.suse.com/>
libopenssl1_0_0 1.0.2p-150000.3.94.1 x86_64 Update repository with updates from SUSE Linux Enterprise 15 SUSE LLC <https://www.suse.com/>
mysql-community-client 8.0.40-1.sles12 x86_64 MySQL 8.0 Community Server Oracle and/or its affiliates
mysql-community-client-plugins 8.0.40-1.sles12 x86_64 MySQL 8.0 Community Server Oracle and/or its affiliates
mysql-community-common 8.0.30-1.sles12 x86_64 MySQL 8.0 Community Server Oracle and/or its affiliates
mysql-community-icu-data-files 8.0.30-1.sles12 x86_64 MySQL 8.0 Community Server Oracle and/or its affiliates
mysql-community-libs 8.0.40-1.sles12 x86_64 MySQL 8.0 Community Server Oracle and/or its affiliates
mysql-community-server 8.0.30-1.sles12 x86_64 MySQL 8.0 Community Server Oracle and/or its affiliates
8 new packages to install.
Package download size: 69.6 MiB
Package install size change:
| 512.3 MiB required by packages that will be installed
512.3 MiB | - 0 B released by packages that will be removed
Backend: classic_rpmtrans
Continue? [y/n/v/...? shows all options] (y):
And yet mysql-community-libs | package | 8.0.30-1.sles12 shows when querying with zypper.
I am not sure why I can’t seem to keep consistency with the version.
Okay, once I installed mysql-commuinty-common v 8.0.30 that seems to have fixed the issue:
mysql:~ # zypper in --details mysql-community-common=8.0.30
Loading repository data...
Reading installed packages...
Resolving package dependencies...
The following NEW package is going to be installed:
mysql-community-common 8.0.30-1.sles12 x86_64 MySQL 8.0 Community Server Oracle and/or its affiliates
1 new package to install.
Package download size: 492.9 KiB
Package install size change:
| 9.9 MiB required by packages that will be installed
9.9 MiB | - 0 B released by packages that will be removed
Backend: classic_rpmtrans
Continue? [y/n/v/...? shows all options] (y): y
Retrieving: mysql-community-common-8.0.30-1.sles12.x86_64 (MySQL 8.0 Community Server) (1/1), 492.9 KiB
Retrieving: mysql-community-common-8.0.30-1.sles12.x86_64.rpm ..................................................................................................................................................................................................................................................................................................[done]
Checking for file conflicts: ...................................................................................................................................................................................................................................................................................................................................[done]
warning: /var/cache/zypp/packages/mysql80-community/mysql-community-common-8.0.30-1.sles12.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
(1/1) Installing: mysql-community-common-8.0.30-1.sles12.x86_64 ................................................................................................................................................................................................................................................................................................[done]
mysql:~ # zypper in --details mysql-community-libs=8.0.30
Loading repository data...
Reading installed packages...
Resolving package dependencies...
The following 3 NEW packages are going to be installed:
libopenssl1_0_0 1.0.2p-150000.3.94.1 x86_64 Update repository with updates from SUSE Linux Enterprise 15 SUSE LLC <https://www.suse.com/>
mysql-community-client-plugins 8.0.30-1.sles12 x86_64 MySQL 8.0 Community Server Oracle and/or its affiliates
mysql-community-libs 8.0.30-1.sles12 x86_64 MySQL 8.0 Community Server Oracle and/or its affiliates
3 new packages to install.
Package download size: 3.6 MiB
Package install size change:
| 24.0 MiB required by packages that will be installed
24.0 MiB | - 0 B released by packages that will be removed
Backend: classic_rpmtrans
Continue? [y/n/v/...? shows all options] (y): y
Retrieving: libopenssl1_0_0-1.0.2p-150000.3.94.1.x86_64 (Update repository with updates from SUSE Linux Enterprise 15) (1/3), 1.1 MiB
Retrieving: libopenssl1_0_0-1.0.2p-150000.3.94.1.x86_64.rpm ........................................................................................................................................................................................................................................................................................[done (5.3 MiB/s)]
Retrieving: mysql-community-client-plugins-8.0.30-1.sles12.x86_64 (MySQL 8.0 Community Server) (2/3), 1.2 MiB
Retrieving: mysql-community-client-plugins-8.0.30-1.sles12.x86_64.rpm ..........................................................................................................................................................................................................................................................................................[done]
Retrieving: mysql-community-libs-8.0.30-1.sles12.x86_64 (MySQL 8.0 Community Server) (3/3), 1.3 MiB
Retrieving: mysql-community-libs-8.0.30-1.sles12.x86_64.rpm ....................................................................................................................................................................................................................................................................................................[done]
Checking for file conflicts: ...................................................................................................................................................................................................................................................................................................................................[done]
(1/3) Installing: libopenssl1_0_0-1.0.2p-150000.3.94.1.x86_64 ..................................................................................................................................................................................................................................................................................................[done]
warning: /var/cache/zypp/packages/mysql80-community/mysql-community-client-plugins-8.0.30-1.sles12.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
(2/3) Installing: mysql-community-client-plugins-8.0.30-1.sles12.x86_64 ........................................................................................................................................................................................................................................................................................[done]
warning: /var/cache/zypp/packages/mysql80-community/mysql-community-libs-8.0.30-1.sles12.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
(3/3) Installing: mysql-community-libs-8.0.30-1.sles12.x86_64 ..................................................................................................................................................................................................................................................................................................[done]
mysql:~ # zypper in --details mysql-community-server=8.0.30-1.sles12
Loading repository data...
Reading installed packages...
Resolving package dependencies...
The following 4 NEW packages are going to be installed:
libncurses5 6.1-150000.5.27.1 x86_64 Update repository with updates from SUSE Linux Enterprise 15 SUSE LLC <https://www.suse.com/>
mysql-community-client 8.0.30-1.sles12 x86_64 MySQL 8.0 Community Server Oracle and/or its affiliates
mysql-community-icu-data-files 8.0.30-1.sles12 x86_64 MySQL 8.0 Community Server Oracle and/or its affiliates
mysql-community-server 8.0.30-1.sles12 x86_64 MySQL 8.0 Community Server Oracle and/or its affiliates
4 new packages to install.
Package download size: 65.5 MiB
Package install size change:
| 473.6 MiB required by packages that will be installed
473.6 MiB | - 0 B released by packages that will be removed
Backend: classic_rpmtrans
Continue? [y/n/v/...? shows all options] (y): y
Retrieving: mysql-community-icu-data-files-8.0.30-1.sles12.x86_64 (MySQL 8.0 Community Server) (1/4), 2.0 MiB
Retrieving: mysql-community-icu-data-files-8.0.30-1.sles12.x86_64.rpm ..............................................................................................................................................................................................................................................................................[done (2.0 MiB/s)]
Retrieving: libncurses5-6.1-150000.5.27.1.x86_64 (Update repository with updates from SUSE Linux Enterprise 15) (2/4), 385.9 KiB
Retrieving: libncurses5-6.1-150000.5.27.1.x86_64.rpm .............................................................................................................................................................................................................................................................................................[done (366.2 KiB/s)]
Retrieving: mysql-community-client-8.0.30-1.sles12.x86_64 (MySQL 8.0 Community Server) (3/4), 2.8 MiB
Retrieving: mysql-community-client-8.0.30-1.sles12.x86_64.rpm ..................................................................................................................................................................................................................................................................................................[done]
Retrieving: mysql-community-server-8.0.30-1.sles12.x86_64 (MySQL 8.0 Community Server) (4/4), 60.4 MiB
Retrieving: mysql-community-server-8.0.30-1.sles12.x86_64.rpm .....................................................................................................................................................................................................................................................................................[done (57.8 MiB/s)]
Checking for file conflicts: ...................................................................................................................................................................................................................................................................................................................................[done]
warning: /var/cache/zypp/packages/mysql80-community/mysql-community-icu-data-files-8.0.30-1.sles12.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
(1/4) Installing: mysql-community-icu-data-files-8.0.30-1.sles12.x86_64 ........................................................................................................................................................................................................................................................................................[done]
(2/4) Installing: libncurses5-6.1-150000.5.27.1.x86_64 .........................................................................................................................................................................................................................................................................................................[done]
warning: /var/cache/zypp/packages/mysql80-community/mysql-community-client-8.0.30-1.sles12.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
(3/4) Installing: mysql-community-client-8.0.30-1.sles12.x86_64 ................................................................................................................................................................................................................................................................................................[done]
warning: /var/cache/zypp/packages/mysql80-community/mysql-community-server-8.0.30-1.sles12.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
(4/4) Installing: mysql-community-server-8.0.30-1.sles12.x86_64 ................................................................................................................................................................................................................................................................................................[done]
mysql:~ #
That’s extremely strange cause I never had to do that in the past, but at least I achieved what I needed, thanks all for the help~!
