Backup mysqldump error

Question
1

When trying to make backups of the pi installation with “sudo pi-manage backup create” I get this back:
mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces

tar: Removing leading `/’ from member names

I see that there appears to have been some change in mysql lately that can cause this error. I just wonder what the recommended fix would be for the pi-manage backup command to work correctly?

Kind regards
Bengt

2

Thank you for pointing this out.

You should not run the backup with sudo. Rather change to a root shell and run the backup there

sudo su -
pi-manage backup create

It should create the backup despite the error message.

However, you could use the parameter --no-tablespaces. See https://github.com/privacyidea/privacyidea/issues/2454