Hello,

It seems the mysqldump failed due to access denied to the Bacula mysql
database. But only when trying to dump tablespaces, strange.
You can check if you can dump the bacula database manually using the
mysqldump program. And fix the error.
The backup finished ok because the job was able to backup the bacula.sql
file generated in the /opt/bacula/working directory, but you may have
problems to recover the Catalog if the dump hasn't finished successfully.
You should have this job configured to fail if the script fails to run, it
is the best to do.
Hope this helps.
Best,
Ana

On Tue, Dec 13, 2022 at 3:12 PM <d...@bornfree.org> wrote:

> I'm wondering if the following is an erroneous error because the
> "BackupCatalog" job says it completed successfully:
>
> ------------
> 02-Dec 23:10 bacula.hq-dir JobId 635: shell command: run BeforeJob
> "/opt/bacula/scripts/make_catalog_backup.pl MyCatalog"
>
> 02-Dec 23:10 bacula.hq-dir JobId 635: BeforeJob: mysqldump: Error:
> 'Access denied; you need (at least one of) the PROCESS privilege(s) for
> this operation' when trying to dump tablespaces
> ------------
>
> If it is in fact an error that needs attention, please help.  Thanks.
>
>
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to