You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Platform and Target:
-- Operating system: Ubuntu Server 22.04
-- PHP: 8.1.2-1ubuntu2.14 (cli) (built: Aug 18 2023 11:41:11) (NTS)
-- Web server: nginx/1.18.0 (Ubuntu)
-- Database server: /usr/sbin/mysqld Ver 8.0.35-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))
In both cases a mysql error was written to the console:
Saving backup file: /var/lib/passbolt/backups/backup-2023-12-05--12-00-42/backup_1701774042.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!
According to the last statement the dump succeeded and indeed the SQL dump looks correct.
In case of a successful backup I expect no error message in the output. With contradicting information ("error"/"success"), I don't know if the backup really succeeded.
While that will clear the error from appearing that permission isn't required for passbolt to function properly so I would recommend against that to keep with the principle of least privilege. As mentioned the backup will still be successful despite that error message.
Error message with mysql backup task
-- Operating system: Ubuntu Server 22.04
-- PHP: 8.1.2-1ubuntu2.14 (cli) (built: Aug 18 2023 11:41:11) (NTS)
-- Web server: nginx/1.18.0 (Ubuntu)
-- Database server: /usr/sbin/mysqld Ver 8.0.35-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))
What you did
I used both the cake backup task from https://help.passbolt.com/hosting/backup/package.html and the backup wrapper script from https://github.com/passbolt/lab-passbolt-admin-scripts to create a passbolt backup
What happened
In both cases a mysql error was written to the console:
According to the last statement the dump succeeded and indeed the SQL dump looks correct.
This error was observed by several users and is also discussed in the forum: https://community.passbolt.com/t/backup-database-error/8646/8
What you expected to happen
In case of a successful backup I expect no error message in the output. With contradicting information ("error"/"success"), I don't know if the backup really succeeded.
See also
zero error policy
for backups e.g. https://nsrd.wordpress.com/2009/08/11/what-is-a-zero-error-policy/.The text was updated successfully, but these errors were encountered: