Welcome to the BBOGAK

Nice to see you here

LET's GET it Dev. Knowledge

AWS/설치오류

[AWS] mysql 설치 오류 - GPG 키 검색 실패: "/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022 파일을 열 수 없습니다"

IT뽀각 2022. 8. 15. 15:17
반응형

1. 현상

Centos 7.9 install mysql 예외가 있습니까? GPG 키 검색 실패: [Errno 14] curl#37 - "/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022 파일을 열 수 없습니다"

이유: 위 프롬프트의 이유는 Mysql Of GPG 업그레이드, 다시 획득해야 합니다.

[root@localhost /]# yum install mysql-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:8.0.29-1.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 8.0.29-1.el7 for package: mysql-community-server-8.0.29-1.el7.x86_64
--> Processing Dependency: mysql-community-icu-data-files = 8.0.29-1.el7 for package: mysql-community-server-8.0.29-1.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 8.0.11 for package: mysql-community-server-8.0.29-1.el7.x86_64
--> Processing Dependency: net-tools for package: mysql-community-server-8.0.29-1.el7.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:8.0.29-1.el7 will be installed
--> Processing Dependency: mysql-community-client-plugins = 8.0.29-1.el7 for package: mysql-community-client-8.0.29-1.el7.x86_64
--> Processing Dependency: mysql-community-libs(x86-64) >= 8.0.11 for package: mysql-community-client-8.0.29-1.el7.x86_64
---> Package mysql-community-common.x86_64 0:8.0.29-1.el7 will be installed
---> Package mysql-community-icu-data-files.x86_64 0:8.0.29-1.el7 will be installed
---> Package net-tools.x86_64 0:2.0-0.25.20131004git.el7 will be installed
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.68-1.el7 will be obsoleted
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-9.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-9.el7.x86_64
---> Package mysql-community-client-plugins.x86_64 0:8.0.29-1.el7 will be installed
---> Package mysql-community-libs.x86_64 0:8.0.29-1.el7 will be obsoleting
--> Running transaction check
---> Package mysql-community-libs-compat.x86_64 0:8.0.29-1.el7 will be obsoleting
--> Finished Dependency Resolution

Dependencies Resolved

============================================================================================================================================================================================================================== Package                                                         Arch                                    Version                                                     Repository                                          Size
==============================================================================================================================================================================================================================Installing:
 mysql-community-libs                                            x86_64                                  8.0.29-1.el7                                                mysql80-community                                  1.5 M
     replacing  mariadb-libs.x86_64 1:5.5.68-1.el7
 mysql-community-libs-compat                                     x86_64                                  8.0.29-1.el7                                                mysql80-community                                  667 k
     replacing  mariadb-libs.x86_64 1:5.5.68-1.el7
 mysql-community-server                                          x86_64                                  8.0.29-1.el7                                                mysql80-community                                   53 M
Installing for dependencies:
 mysql-community-client                                          x86_64                                  8.0.29-1.el7                                                mysql80-community                                   14 M
 mysql-community-client-plugins                                  x86_64                                  8.0.29-1.el7                                                mysql80-community                                  2.5 M
 mysql-community-common                                          x86_64                                  8.0.29-1.el7                                                mysql80-community                                  633 k
 mysql-community-icu-data-files                                  x86_64                                  8.0.29-1.el7                                                mysql80-community                                  2.1 M
 net-tools                                                       x86_64                                  2.0-0.25.20131004git.el7                                    base                                               306 k

Transaction Summary
==============================================================================================================================================================================================================================Install  3 Packages (+5 Dependent packages)

Total size: 75 M
Total download size: 70 M
Is this ok [y/d/N]: y
Downloading packages:
warning: /var/cache/yum/x86_64/7/mysql80-community/packages/mysql-community-icu-data-files-8.0.29-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY                  ] 2.2 MB/s |  11 MB  00:00:27 ETA 
Public key for mysql-community-icu-data-files-8.0.29-1.el7.x86_64.rpm is not installed
(1/4): mysql-community-icu-data-files-8.0.29-1.el7.x86_64.rpm                                                                                                                                          | 2.1 MB  00:00:03     
(2/4): mysql-community-client-8.0.29-1.el7.x86_64.rpm                                                                                                                                                  |  14 MB  00:00:03     
(3/4): net-tools-2.0-0.25.20131004git.el7.x86_64.rpm                                                                                                                                                   | 306 kB  00:00:03     
(4/4): mysql-community-server-8.0.29-1.el7.x86_64.rpm                                                                                                                                                  |  53 MB  00:00:08     
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Total                                                                                                                                                                                         6.0 MB/s |  70 MB  00:00:11     
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022


GPG key retrieval failed: [Errno 14] curl#37 - "Couldn't open file /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022"

2, 솔루션

명령을 수행:

 rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

그런 다음 mysql을 다시 다운로드하십시오.

[root@localhost /]# rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
[root@localhost /]# yum install mysql-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:8.0.29-1.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 8.0.29-1.el7 for package: mysql-community-server-8.0.29-1.el7.x86_64
--> Processing Dependency: mysql-community-icu-data-files = 8.0.29-1.el7 for package: mysql-community-server-8.0.29-1.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 8.0.11 for package: mysql-community-server-8.0.29-1.el7.x86_64
--> Processing Dependency: net-tools for package: mysql-community-server-8.0.29-1.el7.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:8.0.29-1.el7 will be installed
--> Processing Dependency: mysql-community-client-plugins = 8.0.29-1.el7 for package: mysql-community-client-8.0.29-1.el7.x86_64
--> Processing Dependency: mysql-community-libs(x86-64) >= 8.0.11 for package: mysql-community-client-8.0.29-1.el7.x86_64
---> Package mysql-community-common.x86_64 0:8.0.29-1.el7 will be installed
---> Package mysql-community-icu-data-files.x86_64 0:8.0.29-1.el7 will be installed
---> Package net-tools.x86_64 0:2.0-0.25.20131004git.el7 will be installed
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.68-1.el7 will be obsoleted
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-9.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-9.el7.x86_64
---> Package mysql-community-client-plugins.x86_64 0:8.0.29-1.el7 will be installed
---> Package mysql-community-libs.x86_64 0:8.0.29-1.el7 will be obsoleting
--> Running transaction check
---> Package mysql-community-libs-compat.x86_64 0:8.0.29-1.el7 will be obsoleting
--> Finished Dependency Resolution

Dependencies Resolved

============================================================================================================================================================================================================================== Package                                                         Arch                                    Version                                                     Repository                                          Size
==============================================================================================================================================================================================================================Installing:
mysql-community-libs                                            x86_64                                  8.0.29-1.el7                                                mysql80-community                                  1.5 M
    replacing  mariadb-libs.x86_64 1:5.5.68-1.el7
mysql-community-libs-compat                                     x86_64                                  8.0.29-1.el7                                                mysql80-community                                  667 k
    replacing  mariadb-libs.x86_64 1:5.5.68-1.el7
mysql-community-server                                          x86_64                                  8.0.29-1.el7                                                mysql80-community                                   53 M
Installing for dependencies:
mysql-community-client                                          x86_64                                  8.0.29-1.el7                                                mysql80-community                                   14 M
mysql-community-client-plugins                                  x86_64                                  8.0.29-1.el7                                                mysql80-community                                  2.5 M
mysql-community-common                                          x86_64                                  8.0.29-1.el7                                                mysql80-community                                  633 k
mysql-community-icu-data-files                                  x86_64                                  8.0.29-1.el7                                                mysql80-community                                  2.1 M
net-tools                                                       x86_64                                  2.0-0.25.20131004git.el7                                    base                                               306 k

Transaction Summary
==============================================================================================================================================================================================================================Install  3 Packages (+5 Dependent packages)

Total size: 75 M
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
 Installing : mysql-community-common-8.0.29-1.el7.x86_64                                                                                                                                                                 1/9 
 Installing : mysql-community-client-plugins-8.0.29-1.el7.x86_64                                                                                                                                                         2/9 
 Installing : mysql-community-libs-8.0.29-1.el7.x86_64                                                                                                                                                                   3/9 
 Installing : mysql-community-client-8.0.29-1.el7.x86_64                                                                                                                                                                 4/9 
 Installing : net-tools-2.0-0.25.20131004git.el7.x86_64                                                                                                                                                                  5/9 
 Installing : mysql-community-icu-data-files-8.0.29-1.el7.x86_64                                                                                                                                                         6/9 
 Installing : mysql-community-server-8.0.29-1.el7.x86_64                                                                                                                                                                 7/9 
 Installing : mysql-community-libs-compat-8.0.29-1.el7.x86_64                                                                                                                                                            8/9 
 Erasing    : 1:mariadb-libs-5.5.68-1.el7.x86_64                                                                                                                                                                         9/9 
 Verifying  : mysql-community-icu-data-files-8.0.29-1.el7.x86_64                                                                                                                                                         1/9 
 Verifying  : mysql-community-libs-compat-8.0.29-1.el7.x86_64                                                                                                                                                            2/9 
 Verifying  : net-tools-2.0-0.25.20131004git.el7.x86_64                                                                                                                                                                  3/9 
 Verifying  : mysql-community-client-8.0.29-1.el7.x86_64                                                                                                                                                                 4/9 
 Verifying  : mysql-community-client-plugins-8.0.29-1.el7.x86_64                                                                                                                                                         5/9 
 Verifying  : mysql-community-server-8.0.29-1.el7.x86_64                                                                                                                                                                 6/9 
 Verifying  : mysql-community-common-8.0.29-1.el7.x86_64                                                                                                                                                                 7/9 
 Verifying  : mysql-community-libs-8.0.29-1.el7.x86_64                                                                                                                                                                   8/9 
 Verifying  : 1:mariadb-libs-5.5.68-1.el7.x86_64                                                                                                                                                                         9/9 

Installed:
 mysql-community-libs.x86_64 0:8.0.29-1.el7                            mysql-community-libs-compat.x86_64 0:8.0.29-1.el7                            mysql-community-server.x86_64 0:8.0.29-1.el7                           

Dependency Installed:
 mysql-community-client.x86_64 0:8.0.29-1.el7       mysql-community-client-plugins.x86_64 0:8.0.29-1.el7       mysql-community-common.x86_64 0:8.0.29-1.el7       mysql-community-icu-data-files.x86_64 0:8.0.29-1.el7      
 net-tools.x86_64 0:2.0-0.25.20131004git.el7       

Replaced:
 mariadb-libs.x86_64 1:5.5.68-1.el7                                                                                                                                                                                          

Complete!
[root@localhost /]# 
반응형