Repository navigation
[PB-29115] Error message with mysql backup task #502
Description
Error message with mysql backup task
- Passbolt Version: 4.4.2
- 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))
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:
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.
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/.
Activity
claytontstevenson commentedon Dec 5, 2023
Hey @bugspencor I've made a ticket for this on our internal board. It'll be tracked as PB-29115
For this particular case the backup is successful from our perspective as we don't use a tablespace with the passbolt database.
LeXwDeX commentedon Feb 27, 2024
I encountered the same error and then I had to add authorization to passboltdb's database account.
Note:
This will only not display error messages.claytontstevenson commentedon Feb 27, 2024
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.
tomh4 commentedon Sep 3, 2024
Any updates on this? :) while it is good to hear the backup works nonetheless, it is still an unwell feeling to see an error message appear when doing something as crucial as a backup...
[-]Error message with mysql backup task[/-][+][PB-29115] Error message with mysql backup task[/+]