MySQL package fails to update on Plesk server: The GPG keys listed for the “MySQL 5.7 Community Server” repository are already installed but they are not correct for this package.

Dmitry Bystrov

8 months ago

Symptoms

Unable to update MySQL package on Plesk server with the folllwing error:

warning: /var/cache/yum/x86_64/7/mysql57-community/packages/mysql-community-server-5.7.37-1.el7.x86_64.rpm:
Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY

ERROR: The GPG keys listed for the "MySQL 5.7 Community Server" repository are already installed but they are not correct for this package.
Check that the correct key URLs are configured for this repository.

Failing package is: mysql-community-server-5.7.37-1.el7.x86_64
GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

Cause

MySQL bug #106188 where GPG key used by MySQL has expired.

Resolution

1. Connect to Plesk server via SSH.

2. Import the correct key:

RHEL-based (CentOS, AlmaLinux, etc.):

# rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
Debian-based (Ubuntu, Debian):

# wget -q -O https://repo.mysql.com/RPM-GPG-KEY-mysql-2022 | apt-key add -

0 Shares