Ok, there are a couple issues now.
The issue with the “groups” error you last mentioned is because MySQL 8.x uses “GROUPS” as a reserved word. Here is a discussion about what to do: https://github.com/passbolt/passbolt_api/issues/325
The commands for keys needto run via the webserver user. (It appears from above you are running as root? Or basic user?
I was also going through Putty, and was using Nginx (with www-data user). I created a home directory for www-data. My script was owned by www-data first, and then I ran the script but the contents were only this:
keydetails file contents:
%echo Generating a basic OpenPGP key
Key-Type: default
Subkey-Type: default
Name-Real: {my key name was here}
Name-Email: {my email address was here}
Expire-Date: 0
%no-ask-passphrase
%no-protection
# Do a commit here, so that we can later print "done" :-)
%commit
%echo done
sudo su -s /bin/bash -c "gpg --verbose --batch --gen-key keydetails" www-data
That put the key in the webserver keyring. Then, whatever commands I needed to run on that key in the keyring, I used this:
sudo su -s /bin/bash -c "gpg --batch --no-tty --homedir /home/www-data --yes --{gpg command here} {fingerprint here}" www-data
The --no-tty was needed for reasons you already have discovered.
Exporting would be something like:
sudo su -s /bin/bash -c "gpg --batch --no-tty --homedir /home/www-data --yes --armor --export-secret-keys {fingerprint, or email}" www-data
and it will export to current folder. Rename, and copy it where you need it.
If this doesn’t work, I’m thinking it just needs to be tweaked. I’m working off of notes I used across two projects…one was Passbolt, and the other used keys as well (same server, incidentally).