MYSQL fails to install due to incorrect GPG Key

[potiuk]

Discussed in #36230

^{Originally posted by furquan39 December 14, 2023}

Apache Airflow version

Other Airflow 2 version (please specify below)

If "Other Airflow 2 version" selected, which one?

2.4.1

What happened?

When attempting to rebuild an apache airflow image, we are getting failures during our builds when trying to run apt-get update.

The error we see:

What you think should happen instead?

The airflow image should build successfully without any errors.

How to reproduce

Create a Dockerfile. Add the following lines to the Dockerfile:

`FROM apache/airflow:2.4.1-python3.8

ENV SSH_PASSWD "root:Docker!"

RUN pip3 install msal Authlib flask_oauthlib azure-storage-file-datalake apache-airflow-providers-databricks==3.1.0

USER root

RUN apt-get update
&& apt-get install -y --no-install-recommends
openssh-server
&& apt-get autoremove -yqq --purge
&& apt-get clean
&& rm -rf /var/lib/apt/lists/*`

Operating System

Debian 11

Versions of Apache Airflow Providers

No response

Deployment

Docker-Compose

Deployment details

No response

Anything else?

Seems like a similar issue to this: #20911

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[potiuk]

Looks like Oracle did it again and changed their key.

[potiuk]

Similar to #20912

[potiuk]

A quick workaround that should fix if anyone sees the problem (I can't reproduce it - likely due to timezone). I will come with some better fix also for historical images but this should fix it for now (add it to your Dockerfile).

USER root 
RUN sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys A8D3785C
RUN apt-get update ...

[mycaule]

A quick workaround that should fix if anyone sees the problem (I can't reproduce it - likely due to timezone). I will come with some better fix also for historical images but this should fix it for now (add it to your Dockerfile).

I added both the lines suggested in the issues and keep getting the error with this image apache/airflow:slim-2.7.3-python3.10.

RUN sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys A8D3785C
RUN sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 467B942D3A79BD29

Even this which is not recommended doesn't pass the error

RUN apt update --allow-unauthenticated

[potiuk]

A quick workaround that should fix if anyone sees the problem (I can't reproduce it - likely due to timezone). I will come with some better fix also for historical images but this should fix it for now (add it to your Dockerfile).

Is time set properly on your host ?

[mycaule]

I am in Europe just like you.

[potiuk]

How about this:

RUN sudo gpg --recv-keys 3A79BD29

[potiuk]

( and I am talking about time not timezone) - whether your time is set properly on your machine

[ltken123]

RUN sudo gpg --recv-keys 3A79BD29

This isn't working for me either, no so great workaround to get my builds to continue is just to remove mysql for now

[potiuk]

Can anyone post the full log of failing installation in text form, please?