MySQL repo: expired gpg key

ajajajsfkffk · December 23, 2023, 8:49am

I can’t install MariaDB (mariadb mariadb-server) , neither MySql (community-mysql-server | I tried also importing official repo so: mysql-community-server doesn’t work neither)

I’m running fedora 38. I tried sudo dnf update, updated everything. And still nothing.
Do I need to upgrade do fedora 39 ?

Or in other case, who the h*ll leaves expired gpg key in repo ? This is the key it requires but can’t import:
sudo rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

You see:

sudo dnf install mariadb mariadb-server
Last metadata expiration check: 1:03:56 ago on Sat 23 Dec 2023 08:44:53 AM CET.
Dependencies resolved.
================================================================================
 Package                  Arch   Version                Repository         Size
================================================================================
Installing:
 mysql-community-client   x86_64 8.0.35-10.fc38         mysql80-community 3.7 M
 mysql-community-server   x86_64 8.0.35-10.fc38         mysql80-community  20 M
Installing dependencies:
 mecab                    x86_64 0.996-3.fc38.5         fedora            355 k
 mysql-community-client-plugins
                          x86_64 8.0.35-10.fc38         mysql80-community 1.3 M
 mysql-community-common   x86_64 8.0.35-10.fc38         mysql80-community 557 k
 mysql-community-icu-data-files
                          x86_64 8.0.35-10.fc38         mysql80-community 2.3 M
 mysql-community-libs     x86_64 8.0.35-10.fc38         mysql80-community 1.5 M
Installing weak dependencies:
 mecab-ipadic             x86_64 2.7.0.20070801-26.fc38 fedora             11 M
 mecab-ipadic-EUCJP       x86_64 2.7.0.20070801-26.fc38 fedora            9.6 M

Transaction Summary
================================================================================
Install  9 Packages

Total download size: 50 M
Installed size: 303 M
Is this ok [y/N]: y
Downloading Packages:
(1/9): mecab-0.996-3.fc38.5.x86_64.rpm          501 kB/s | 355 kB     00:00    
(2/9): mysql-community-client-8.0.35-10.fc38.x8 2.0 MB/s | 3.7 MB     00:01    
(3/9): mysql-community-client-plugins-8.0.35-10 2.4 MB/s | 1.3 MB     00:00    
(4/9): mysql-community-common-8.0.35-10.fc38.x8 2.1 MB/s | 557 kB     00:00    
(5/9): mysql-community-icu-data-files-8.0.35-10 2.4 MB/s | 2.3 MB     00:00    
(6/9): mysql-community-libs-8.0.35-10.fc38.x86_ 2.3 MB/s | 1.5 MB     00:00    
(7/9): mecab-ipadic-2.7.0.20070801-26.fc38.x86_ 2.0 MB/s |  11 MB     00:05    
(8/9): mecab-ipadic-EUCJP-2.7.0.20070801-26.fc3 1.1 MB/s | 9.6 MB     00:08    
(9/9): mysql-community-server-8.0.35-10.fc38.x8 3.7 MB/s |  20 MB     00:05    
--------------------------------------------------------------------------------
Total                                           4.6 MB/s |  50 MB     00:10     
MySQL 8.0 Community Server                      3.0 MB/s | 3.1 kB     00:00    
GPG key at file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2023 (0xA8D3785C) is already installed
MySQL 8.0 Community Server                      3.0 MB/s | 3.1 kB     00:00    
Importing GPG key 0x3A79BD29:
 Userid     : "MySQL Release Engineering <mysql-build@oss.oracle.com>"
 Fingerprint: 859B E8D7 C586 F538 430B 19C2 467B 942D 3A79 BD29
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
Is this ok [y/N]: y
error: Certificate 467B942D3A79BD29:
  The certificate is expired: The primary key is not live
Key import failed (code 2). Failing package is: mysql-community-client-8.0.35-10.fc38.x86_64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2023, file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
Public key for mysql-community-client-plugins-8.0.35-10.fc38.x86_64.rpm is not installed. Failing package is: mysql-community-client-plugins-8.0.35-10.fc38.x86_64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2023, file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
Public key for mysql-community-common-8.0.35-10.fc38.x86_64.rpm is not installed. Failing package is: mysql-community-common-8.0.35-10.fc38.x86_64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2023, file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
Public key for mysql-community-icu-data-files-8.0.35-10.fc38.x86_64.rpm is not installed. Failing package is: mysql-community-icu-data-files-8.0.35-10.fc38.x86_64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2023, file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
Public key for mysql-community-libs-8.0.35-10.fc38.x86_64.rpm is not installed. Failing package is: mysql-community-libs-8.0.35-10.fc38.x86_64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2023, file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
Public key for mysql-community-server-8.0.35-10.fc38.x86_64.rpm is not installed. Failing package is: mysql-community-server-8.0.35-10.fc38.x86_64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2023, file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022
The downloaded packages were saved in cache until the next successful transaction.
You can remove cached packages by executing 'dnf clean packages'.
Error: GPG check FAILED

glb · December 23, 2023, 6:29pm

I just installed it on my Fedora Linux 38 PC. It is working for me.

[/home/gregory]$ dnf install mariadb mariadb-server                                           
Fedora 38 - x86_64 - Updates                                    99 kB/s |  20 kB     00:00    
Fedora 38 - x86_64 - Updates                                   622 kB/s | 3.0 MB     00:04    
Fedora Modular 38 - x86_64 - Updates                           103 kB/s |  24 kB     00:00    
RPM Fusion for Fedora 38 - Free tainted                        5.9 kB/s | 3.3 kB     00:00    
Dependencies resolved.
===============================================================================================
 Package                               Architecture Version                Repository     Size
===============================================================================================
Installing:
 mariadb                               x86_64       3:10.5.23-1.fc38       updates       1.6 M
 mariadb-server                        x86_64       3:10.5.23-1.fc38       updates        11 M
Installing dependencies:
 mariadb-common                        x86_64       3:10.5.23-1.fc38       updates        33 k
 mariadb-errmsg                        x86_64       3:10.5.23-1.fc38       updates       217 k
 mysql-selinux                         noarch       1.0.10-1.fc38          updates        35 k
 perl-DBD-MariaDB                      x86_64       1.22-4.fc38            fedora        151 k
 perl-DBI                              x86_64       1.643-15.fc38          fedora        709 k
Installing weak dependencies:
 mariadb-backup                        x86_64       3:10.5.23-1.fc38       updates       6.5 M
 mariadb-cracklib-password-check       x86_64       3:10.5.23-1.fc38       updates        15 k
 mariadb-gssapi-server                 x86_64       3:10.5.23-1.fc38       updates        16 k
 mariadb-server-utils                  x86_64       3:10.5.23-1.fc38       updates       217 k

Transaction Summary
===============================================================================================
Install  11 Packages

Total download size: 20 M
Installed size: 117 M
Is this ok [y/N]: y
Downloading Packages:
(1/11): perl-DBD-MariaDB-1.22-4.fc38.x86_64.rpm                319 kB/s | 151 kB     00:00    
(2/11): perl-DBI-1.643-15.fc38.x86_64.rpm                      829 kB/s | 709 kB     00:00    
(3/11): mariadb-common-10.5.23-1.fc38.x86_64.rpm               259 kB/s |  33 kB     00:00    
(4/11): mariadb-cracklib-password-check-10.5.23-1.fc38.x86_64. 119 kB/s |  15 kB     00:00    
(5/11): mariadb-errmsg-10.5.23-1.fc38.x86_64.rpm               587 kB/s | 217 kB     00:00    
(6/11): mariadb-gssapi-server-10.5.23-1.fc38.x86_64.rpm        243 kB/s |  16 kB     00:00    
(7/11): mariadb-10.5.23-1.fc38.x86_64.rpm                      936 kB/s | 1.6 MB     00:01    
(8/11): mariadb-server-utils-10.5.23-1.fc38.x86_64.rpm         561 kB/s | 217 kB     00:00    
(9/11): mysql-selinux-1.0.10-1.fc38.noarch.rpm                 277 kB/s |  35 kB     00:00    
(10/11): mariadb-backup-10.5.23-1.fc38.x86_64.rpm              1.0 MB/s | 6.5 MB     00:06    
(11/11): mariadb-server-10.5.23-1.fc38.x86_64.rpm              1.5 MB/s |  11 MB     00:07    
-----------------------------------------------------------------------------------------------
Total                                                          2.1 MB/s |  20 MB     00:09     
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                       1/1 
  Installing       : mariadb-common-3:10.5.23-1.fc38.x86_64                               1/11 
  Installing       : perl-DBI-1.643-15.fc38.x86_64                                        2/11 
  Installing       : perl-DBD-MariaDB-1.22-4.fc38.x86_64                                  3/11 
  Installing       : mariadb-errmsg-3:10.5.23-1.fc38.x86_64                               4/11 
  Running scriptlet: mysql-selinux-1.0.10-1.fc38.noarch                                   5/11 
  Installing       : mysql-selinux-1.0.10-1.fc38.noarch                                   5/11 
  Running scriptlet: mysql-selinux-1.0.10-1.fc38.noarch                                   5/11 
libsemanage.semanage_direct_install_info: Overriding mysql module at lower priority 100 with module at priority 200.

  Installing       : mariadb-3:10.5.23-1.fc38.x86_64                                      6/11 
  Installing       : mariadb-backup-3:10.5.23-1.fc38.x86_64                               7/11 
  Installing       : mariadb-cracklib-password-check-3:10.5.23-1.fc38.x86_64              8/11 
  Running scriptlet: mariadb-cracklib-password-check-3:10.5.23-1.fc38.x86_64              8/11 
  Installing       : mariadb-gssapi-server-3:10.5.23-1.fc38.x86_64                        9/11 
  Running scriptlet: mariadb-server-3:10.5.23-1.fc38.x86_64                              10/11 
  Installing       : mariadb-server-3:10.5.23-1.fc38.x86_64                              10/11 
  Running scriptlet: mariadb-server-3:10.5.23-1.fc38.x86_64                              10/11 
  Installing       : mariadb-server-utils-3:10.5.23-1.fc38.x86_64                        11/11 
  Running scriptlet: mysql-selinux-1.0.10-1.fc38.noarch                                  11/11 
  Running scriptlet: mariadb-server-utils-3:10.5.23-1.fc38.x86_64                        11/11 
  Verifying        : perl-DBD-MariaDB-1.22-4.fc38.x86_64                                  1/11 
  Verifying        : perl-DBI-1.643-15.fc38.x86_64                                        2/11 
  Verifying        : mariadb-3:10.5.23-1.fc38.x86_64                                      3/11 
  Verifying        : mariadb-backup-3:10.5.23-1.fc38.x86_64                               4/11 
  Verifying        : mariadb-common-3:10.5.23-1.fc38.x86_64                               5/11 
  Verifying        : mariadb-cracklib-password-check-3:10.5.23-1.fc38.x86_64              6/11 
  Verifying        : mariadb-errmsg-3:10.5.23-1.fc38.x86_64                               7/11 
  Verifying        : mariadb-gssapi-server-3:10.5.23-1.fc38.x86_64                        8/11 
  Verifying        : mariadb-server-3:10.5.23-1.fc38.x86_64                               9/11 
  Verifying        : mariadb-server-utils-3:10.5.23-1.fc38.x86_64                        10/11 
  Verifying        : mysql-selinux-1.0.10-1.fc38.noarch                                  11/11 

Installed:
  mariadb-3:10.5.23-1.fc38.x86_64                                                              
  mariadb-backup-3:10.5.23-1.fc38.x86_64                                                       
  mariadb-common-3:10.5.23-1.fc38.x86_64                                                       
  mariadb-cracklib-password-check-3:10.5.23-1.fc38.x86_64                                      
  mariadb-errmsg-3:10.5.23-1.fc38.x86_64                                                       
  mariadb-gssapi-server-3:10.5.23-1.fc38.x86_64                                                
  mariadb-server-3:10.5.23-1.fc38.x86_64                                                       
  mariadb-server-utils-3:10.5.23-1.fc38.x86_64                                                 
  mysql-selinux-1.0.10-1.fc38.noarch                                                           
  perl-DBD-MariaDB-1.22-4.fc38.x86_64                                                          
  perl-DBI-1.643-15.fc38.x86_64                                                                

Complete!
[/home/gregory]$ sudo systemctl start mariadb.service
[/home/gregory]$ sudo mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.5.23-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
3 rows in set (0.001 sec)

MariaDB [(none)]> quit;
Bye
[/home/gregory]$ date
Sat Dec 23 12:28:17 PM CST 2023
[/home/gregory]$

Perhaps you are connecting to a bad mirror?

alciregi · December 23, 2023, 9:17pm

The issue seems related to mysql.com repository.

https://bugs.mysql.com/bug.php?id=113432

Do you really need mysql-community-server? Otherwise you can install mariadb from the Fedora repository. (In this case you have to remove mysql80-community repository).

Topic		Replies	Views
How to remove expired GPG key installed by MySQL? Ask Fedora f39 , server , workstation	13	2890	January 8, 2024
Fedora Upgrade to 39 Failed Ask Fedora f38 , f39	6	1515	November 16, 2023
Unable to upgrade to F37 with dnf due to some public keys missing Ask Fedora	4	2347	November 26, 2022
Can't update expired-pgp-keys.conf Ask Fedora workstation	2	95	March 8, 2025
Problem with gpg keys after 41 -> 42 upgrade Ask Fedora upgrades	2	214	April 17, 2025

MySQL repo: expired gpg key

Related topics