First of all, I wanted to say that Passbolt is one hell of a application. It works beautifully, great support and very clear documentation. Despite that I do run into a issue, but I think it’s something that I’m not getting, haha.
I want to backup the database only to a remote location. I followed this: https://help.passbolt.com/hosting/backup/package.html. I copied the command from the above linkt, but even though it says it’s a success, I get the following error every time:
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
I think it has something to do with the WEB_SERVER_USER that you need to enter, but no matter what user I put in, the error remains. This is the list of users I tried:
root
passbolt_db_user
nginx
passbolt
mysql
When I use the user mysql or passbolt, I got the following error:
PHP Warning: require(/etc/passbolt/requirements.php): Failed to open stream: Permission denied in /usr/share/php/passbolt/bin/cake.php on line 4
PHP Fatal error: Uncaught Error: Failed opening required '/etc/passbolt/requirements.php' (include_path='.:/usr/share/php') in /usr/share/php/passbolt/bin/cake.php:4
Stack trace:
#0 {main}
thrown in /usr/share/php/passbolt/bin/cake.php on line 4
What am I missing or can I exclude tablespaces like I can if I used the mysqldump command? I already searched the forum, but couldn’t find a similar issue.
Hello @Salazar, thanks for your kind message, it means a lot to all of our community!
Since you tried nginx as the webserver user, can you confirm that you are using a rpm distribution? Also, could you share a screenshot from the output where it says “success” after running the command?
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.
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.