Hello,
unfortunately this not a solution to the problem itself, but rather the error output is “hidden” in the more verbose output of the script. Under the hood, the backup script executes the exact same command that leads to the same behavior. See the output of the backup script:
$ sudo ./backup.sh
+------------------------------------------------------------------------------------------+
Docker not detected
+------------------------------------------------------------------------------------------+
Taking database backup and storing in /tmp/backup-2023-11-13--06-15-26
+------------------------------------------------------------------------------------------+
____ __ ____
/ __ \____ _____ ____/ /_ ____ / / /_
/ /_/ / __ `/ ___/ ___/ __ \/ __ \/ / __/
/ ____/ /_/ (__ |__ ) /_/ / /_/ / / /
/_/ \__,_/____/____/_.___/\____/_/\__/
Open source password manager for teams
-------------------------------------------------------------------------------
Saving backup file: /tmp/backup-2023-11-13--06-15-26/backup_1699856126.sql
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
Success: the database was saved on file!
+------------------------------------------------------------------------------------------+
Copying /etc/passbolt/passbolt.php to /tmp/backup-2023-11-13--06-15-26
+------------------------------------------------------------------------------------------+
Copying /etc/passbolt/gpg/serverkey_private.asc to /tmp/backup-2023-11-13--06-15-26
+------------------------------------------------------------------------------------------+
Copying /etc/passbolt/gpg/serverkey.asc to /tmp/backup-2023-11-13--06-15-26
+------------------------------------------------------------------------------------------+
Creating archive of /tmp/backup-2023-11-13--06-15-26
+------------------------------------------------------------------------------------------+
./
./passbolt.php
./serverkey.asc
./backup_1699856126.sql
./serverkey_private.asc
+------------------------------------------------------------------------------------------+
Cleaning up /tmp
+------------------------------------------------------------------------------------------+
Backup completed you can find the file as /tmp/backup-2023-11-13--06-15-26.tar.gz
+------------------------------------------------------------------------------------------+
My system is similar to the OP’s one, I installed on a Ubuntu 22 server with the deb installation method, and I let the installer create the db tables as well as the user for me. I would prefer to not manually change settings that the installer chose for me; I’d expect it to end in a consistent state.
To my understanding, the error itself is not related to the webserver user, but rather to the tablespaces options, see https://dba.stackexchange.com/questions/271981/access-denied-you-need-at-least-one-of-the-process-privileges-for-this-ope
So I’d expect
- either the installer to assign correct permissions to the db user
- or the backup routine to pass the parameter if this feature is not required
Unfortunately, from the Github tour document (https://github.com/passbolt) it is not clear to me in which repository to file an issue for that, because there is none mentioned that is responsible for the deb package creation. Some help here would be appreciated.
Regards