다음을 통해 VirtualBox설치됨Fedora Workstation 39. 이제 MySQL 8 서버를 설치하려고 합니다. mysql80-community-release-fc39-1.noarch.rpm거기에서 파일을 받았어요https://dev.mysql.com/downloads/이 MySQL Yum Repository섹션 정보
처형되서 좋다
sudo rpm -Uvh mysql80-community-release-fc39-1.noarch.rpm
warning: mysql80-community-release-fc39-1.noarch.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Updating / installing...
1:mysql80-community-release-fc39-1 ################################# [100%]
그리고
sudo dnf install mysql-community-server
MySQL 8.0 Community Server 310 kB/s | 209 kB 00:00
MySQL Connectors Community 60 kB/s | 12 kB 00:00
MySQL Tools Community 60 kB/s | 81 kB 00:01
Dependencies resolved.
============================================================================================================================================================
Package Architecture Version Repository Size
============================================================================================================================================================
Installing:
mysql-community-server x86_64 8.0.35-10.fc39 mysql80-community 20 M
replacing mariadb-connector-c-config.noarch 3.3.5-2.fc39
Installing dependencies:
mecab x86_64 0.996-5.fc39 fedora 356 k
mysql-community-client x86_64 8.0.35-10.fc39 mysql80-community 3.7 M
mysql-community-client-plugins x86_64 8.0.35-10.fc39 mysql80-community 1.3 M
mysql-community-common x86_64 8.0.35-10.fc39 mysql80-community 557 k
mysql-community-icu-data-files x86_64 8.0.35-10.fc39 mysql80-community 2.3 M
mysql-community-libs x86_64 8.0.35-10.fc39 mysql80-community 1.5 M
Installing weak dependencies:
mecab-ipadic x86_64 2.7.0.20070801-28.fc39 fedora 10 M
mecab-ipadic-EUCJP x86_64 2.7.0.20070801-28.fc39 fedora 9.6 M
Transaction Summary
============================================================================================================================================================
Install 9 Packages
Total download size: 50 M
Is this ok [y/N]: y
Downloading Packages:
(1/9): mecab-0.996-5.fc39.x86_64.rpm 231 kB/s | 356 kB 00:01
(2/9): mecab-ipadic-2.7.0.20070801-28.fc39.x86_64.rpm 3.7 MB/s | 10 MB 00:02
(3/9): mysql-community-client-8.0.35-10.fc39.x86_64.rpm 2.3 MB/s | 3.7 MB 00:01
(4/9): mysql-community-common-8.0.35-10.fc39.x86_64.rpm 2.7 MB/s | 557 kB 00:00
(5/9): mysql-community-client-plugins-8.0.35-10.fc39.x86_64.rpm 1.8 MB/s | 1.3 MB 00:00
(6/9): mysql-community-icu-data-files-8.0.35-10.fc39.x86_64.rpm 3.8 MB/s | 2.3 MB 00:00
(7/9): mysql-community-libs-8.0.35-10.fc39.x86_64.rpm 2.9 MB/s | 1.5 MB 00:00
(8/9): mecab-ipadic-EUCJP-2.7.0.20070801-28.fc39.x86_64.rpm 2.2 MB/s | 9.6 MB 00:04
(9/9): mysql-community-server-8.0.35-10.fc39.x86_64.rpm 8.1 MB/s | 20 MB 00:02
------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 6.8 MB/s | 50 MB 00:07
MySQL 8.0 Community Server 3.0 MB/s | 3.1 kB 00:00
Importing GPG key 0xA8D3785C:
Userid : "MySQL Release Engineering <[email protected]>"
Fingerprint: BCA4 3417 C3B4 85DD 128E C6D4 B7B3 B788 A8D3 785C
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2023
Is this ok [y/N]: y
Key imported successfully
MySQL 8.0 Community Server 365 kB/s | 3.1 kB 00:00
Importing GPG key 0x3A79BD29:
Userid : "MySQL Release Engineering <[email protected]>"
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.fc39.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.fc39.x86_64.rpm is not installed. Failing package is: mysql-community-client-plugins-8.0.35-10.fc39.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.fc39.x86_64.rpm is not installed. Failing package is: mysql-community-common-8.0.35-10.fc39.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.fc39.x86_64.rpm is not installed. Failing package is: mysql-community-icu-data-files-8.0.35-10.fc39.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.fc39.x86_64.rpm is not installed. Failing package is: mysql-community-libs-8.0.35-10.fc39.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.fc39.x86_64.rpm is not installed. Failing package is: mysql-community-server-8.0.35-10.fc39.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
이 상황을 해결하는 방법은 무엇입니까?
답변1
이 오류는 인증서가 만료되었기 때문에 저장소의 GPG 키가 유효하지 않음을 나타냅니다 /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2022. 2022년 10월에 만료됩니다.
어떤 이유로 2023년 11월 이후 유효한 최신 버전은 y명령 중에 응답했을 때 올바르게 가져왔더라도 유효하지 않은 것으로 간주됩니다./etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2023
이것은 버그인 것 같습니다. 첫 번째 섹션 아래 줄을 다음과 같이 편집하여 /etc/yum.repos.d/mysql-community.repoGPG 체크인을 비활성화하면 이 문제를 해결할 수 있습니다.gpgcheck0[mysql80-community]
[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/fc/$releasever/$basearch
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql-2023
1문제가 해결되어 다시 설정할 때까지 비활성화됩니다 .
패키지를 설치할 수도 있습니다
dnf --nogpgcheck install mysql-community-server
--nogpgcheck그러나 이 방법을 사용하려면 매번 스위치를 사용하여 개별적으로 업데이트 해야 합니다 .
이는 저장소 에서 설치하려는 경우 에만 mysql-community필요합니다 .
다음 명령을 사용하여 리포지토리를 추가하지 않고 Fedora 리포지토리에서 설치할 수도 있습니다.
dnf install community-mysql-server
이는 동일한 기능을 갖춘 동일한 주요 버전이며 GPG 키에 대한 정보가 필요하지 않습니다. 일부 구성 파일은 다를 수 있지만 큰 문제는 아닙니다.