How to resolve the GPG Signature Verification error when building tml-sql image?

How to resolve the GPG Signature Verification error when building tml-sql image?

book

Article ID: KB0072653

calendar_today

Updated On:

Products Versions
TIBCO Cloud API Management - Local Edition 5.5.0 and below

Description

GPG key for the official MySQL repository has been updated for MySQL 5.7.37 or higher, causing a signature verification error during installation or update of MySQL packages. During APIM ML 5.5 quick start installation I faced the error “Public key for mysql-community-common-5.7.37-1.el7.x86_64.rpm is not installed”, this was solved using this key https://repo.mysql.com/RPM-GPG-KEY-mysql-2022 to update the RPM-GPG-KEY-mysql file which is included in the installation files from eDelivery.

 

Issue/Introduction

This article provides inputs to resolve this error and successfully build the tml-sql image.

Environment

All Supported Platforms

Resolution

Below are the steps to update the GPGKey:

1) Navigate to the Source of GPG Key
https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

2) Dowload GPG Key and save it
3) Start tml-installer
4) Copy new GPG-Key

5) Edit /var/jenkins_home/docker-build/tmgc-sql/install-mysql/RPM-GPG-KEY-mysql
a. Replace GPG Key in the above file with the new copied GPG Key
6) Build Images
 

Additional Information

https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-28.html#mysqld-8-0-28-packaging Section Packaging Notes
https://bugs.mysql.com/bug.php?id=106188