Skip to content
This repository was archived by the owner on Aug 12, 2025. It is now read-only.
This repository was archived by the owner on Aug 12, 2025. It is now read-only.

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

@itvexesme

Description

@itvexesme

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
+------------------------------------------------------------------------------------------+

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions