Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces #6

Open
itvexesme opened this issue Mar 31, 2024 · 0 comments

Comments

@itvexesme
Copy link
Contributor

itvexesme commented Mar 31, 2024

Whem I'm running backup.sh, at some point it says about issue for mysqldump with message:
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
I'm using $webserver_user set as www-data.
I also tried various ways of running /usr/share/php/passbolt/bin/cake passbolt mysql_export --dir ./ <username> directly, with
root and app sql account user (set during installation of passbolt) - the result is the same.

I have Passbolt 4.6.0 on Ubuntu 22.04.

I'm aware of losing information from Passbolt database required for correct backup creation with this issue.
Can you check it or advise about this issue?

Below you can find complete log from backup.sh:

/tmp# ./backup.sh
+------------------------------------------------------------------------------------------+
Docker not detected
+------------------------------------------------------------------------------------------+
Taking database backup and storing in /tmp/backup-2024-03-31--12-08-15
+------------------------------------------------------------------------------------------+

     ____                  __          ____
    / __ \____  _____ ____/ /_  ____  / / /_
   / /_/ / __ `/ ___/ ___/ __ \/ __ \/ / __/
  / ____/ /_/ (__  |__  ) /_/ / /_/ / / /
 /_/    \__,_/____/____/_.___/\____/_/\__/

 Open source password manager for teams
-------------------------------------------------------------------------------
Saving backup file: /tmp/backup-2024-03-31--12-08-15/backup_1711876095.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-2024-03-31--12-08-15
+------------------------------------------------------------------------------------------+
Copying /etc/passbolt/gpg/serverkey_private.asc to /tmp/backup-2024-03-31--12-08-15
+------------------------------------------------------------------------------------------+
Copying /etc/passbolt/gpg/serverkey.asc to /tmp/backup-2024-03-31--12-08-15
+------------------------------------------------------------------------------------------+
Creating archive of /tmp/backup-2024-03-31--12-08-15
+------------------------------------------------------------------------------------------+
./
./serverkey.asc
./backup_1711876095.sql
./serverkey_private.asc
./passbolt.php
+------------------------------------------------------------------------------------------+
Cleaning up /tmp
+------------------------------------------------------------------------------------------+
Backup completed you can find the file as /tmp/backup-2024-03-31--12-08-15.tar.gz
+------------------------------------------------------------------------------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant