KOA.2A and KOA.1 Installation failed at "TASK [mysql : add the mysql signing key]"

Site Operators Site Operations Help
1

Hi,

I am setting up KOA in new server. The installation stops at the following step:
TASK [mysql : add the mysql signing key] (see point A below), I have tried the same installation steps on KOA.2A and KOA.1, both stopped at the same step.

I did successfully install KOA.1 using the exactly same steps in Dec 2020, but it no longer worked from recent weeks. I believe the issue should not be from the installation script, it would be from MYSQL or Ubuntu side, please help !

A. Error found on 2020-04-01 (KOA.2A and KOA.1)

TASK [mysql : add the mysql signing key] ***************************************
fatal: [localhost]: FAILED! => {"changed": false, "cmd": "/usr/bin/apt-key adv --no-tty --keyserver keyserver.ubuntu.com --recv 8C718D3B5072E1F5", "msg": "Error fetching key 8C718D3B5072E1F5 from keyserver: keyserver.ubuntu.com", "rc": 2, "stderr": "Warning: apt-key output should not be parsed (stdout is not a terminal)\ngpg: keyserver receive failed: Connection timed out\n", "stderr_lines": ["Warning: apt-key output should not be parsed (stdout is not a terminal)", "gpg: keyserver receive failed: Connection timed out"], "stdout": "Executing: /tmp/apt-key-gpghome.gOUlOMmKL9/gpg.1.sh --no-tty --keyserver keyserver.ubuntu.com --recv 8C718D3B5072E1F5\n", "stdout_lines": ["Executing: /tmp/apt-key-gpghome.gOUlOMmKL9/gpg.1.sh --no-tty --keyserver keyserver.ubuntu.com --recv 8C718D3B5072E1F5"]}

B. Successful installation on 2020-12-29 (KOA.1)

TASK [mysql : add the mysql signing key] ***************************************
changed: [localhost]
TASK [mysql : add the mysql-5.7 repo to the sources list] **********************
changed: [localhost]
TASK [mysql : install mysql-5.7-client] ****************************************
changed: [localhost]
2

Hi @am2021, it looks like the keyserver is down or unreachable from the server on which you’re running this.

Perhaps you could try using a different keyserver? It’s defined with the MYSQL_APT_KEYSERVER ansible var.

3

Hi,

This issue if fixed now by retry, many thanks!

4

I had a similar problem. have you solved it yet?

5

here is my workaround: linux - sudo apt-key adv --keyserver keyserver.ubuntu.com --recv 7F0CEB10 command returns error - Super User