PGP critical issue when trying to install mysql2 in rails project

Question

I'm trying to install all the gems for a Rails project locally.

I have a problem with mysql2. When I try to install it I get the following error:

Fetching mysql2-0.5.5.gem
Temporarily enhancing PATH for MSYS/MINGW...
Installing required msys2 packages: mingw-w64-x86_64-libmariadbclient
error: mingw32: key "5F944B027F7FE2091985AA2EFA11531AA0AA7F57" is unknown
error: key "5F944B027F7FE2091985AA2EFA11531AA0AA7F57" could not be looked up remotely
error: mingw64: key "5F944B027F7FE2091985AA2EFA11531AA0AA7F57" is unknown
error: key "5F944B027F7FE2091985AA2EFA11531AA0AA7F57" could not be looked up remotely
error: msys: key "5F944B027F7FE2091985AA2EFA11531AA0AA7F57" is unknown
error: key "5F944B027F7FE2091985AA2EFA11531AA0AA7F57" could not be looked up remotely
error: database 'mingw32' is not valid (invalid or corrupted database (PGP signature))
error: database 'mingw64' is not valid (invalid or corrupted database (PGP signature))
error: database 'msys' is not valid (invalid or corrupted database (PGP signature))
pacman failed with the following output:
Building native extensions with: '--with-mysql-lib="C:\Program Files\MySQL\MySQL Server 8.0\lib" --with-mysql-include="C:\Program Files\MySQL\MySQL Server 8.0\include"'
This could take a while...
ERROR: Error installing mysql2:
        ERROR: Failed to build gem native extension.

Then I tried running pacman -Syu but I got the same error and was not asked to import the PGP key.

So I tried manually importing the key based on pacman-key --add from the MSI keyring GitHub. I then changed the trust to Ultimate using pacman-key --edit-key.

But now, I'm getting another error:

Installing required msys2 packages: mingw-w64-x86_64-libmariadbclient
error: could not open file /var/lib/pacman/sync/mingw32.db: Child process exited with status 127
error: could not open file /var/lib/pacman/sync/mingw64.db: Child process exited with status 127
error: could not open file /var/lib/pacman/sync/msys.db: Child process exited with status 127
error: target not found: mingw-w64-x86_64-libmariadbclient
pacman failed with the following output:
Building native extensions with: '--with-mysql-lib="C:\Program Files\MySQL\MySQL Server 8.0\lib" --with-mysql-include="C:\Program Files\MySQL\MySQL Server 8.0\include"'
This could take a while...
ERROR: Error installing mysql2:
        ERROR: Failed to build gem native extension.

I don't know if I'm adding the wrong key this way, or if the error comes from something else. I've been struggling with this for a few days now and I'm a little lost. Can anyone help?

Answer 1

It seems there may be a problem with the MSYS2 or pacman package manager you installed. Child processes exiting with status 127 can indicate a variety of problems.

Here are some things we can try to resolve this error:

1. You can first update your MSYS2 installation using the following command:

pacman -Syu

2. If this doesn't work, we can try reinstalling MSYS2.

3. Another approach might be to delete the pacman cache and try again. You can do this via:

pacman -Scc

Please note that there is an error with mingw-w64-x86_64-libmariadbclient, you should confirm that all required development packages are installed.

sudo pacman -S mysql

There may also be a development package. On Ubuntu it's "sudo apt install libmariadb-dev" or something similar, but I'm not sure about Arch Linux.