Hi.
I see--it's worth checking then the command that is called by the catalogue
backup job (the "BeforeJob" directive in the "Job" (or "JobDefs") resource).
On my system the catalogue job calls, in its "BeforeJob" directive, the
following: "/opt/bacula/etc/make_catalog_backup.pl MyCatalog".
According to the output of Job 65 on your server, "BeforeJob" runs "mysqldump",
which isn't what I'm expecting (but my config files are from an older version
of Bacula--so I might be wrong here).
I'd seek out the "BeforeJob =" line of bacula-dir.conf, and check the script it
executes to make sure it has the credentials it needs.
Thanks.
--
Graham Sparks
________________________________
From: Graham Dicker
Sent: 23 December 2021 16:19
To: bacula-users@lists.sourceforge.net <bacula-users@lists.sourceforge.net>
Subject: Re: [Bacula-users] make_catalog_backup stopped working
Thank you for your reply Graham.
I don't think Bacula itself has any problems, it is only the script mysqldump
that has a problem. The script is just supposed to create a dump of the
database and (if it is successful) then Bacula goes on to first back it up and
then delete it.
On Thursday, 23 December 2021 15:14:08 GMT Graham Sparks wrote:
> Hi.
>
> I'm surprised your other backups are working--if you have just one database
> server, your Bacula director should be using the same credentials to
> connect to the database, regardless of the job.
>
> In your "bacula-dir.conf" file, there will be the username and password that
> Bacula uses to connect to the catalogue database:
>
> e.g.
>
> <quote>
>
> Catalog {
> Name = MyCatalog
> dbname = "your-bacula-database-name"; dbuser = "your-bacula-user";
> dbpassword = "your-password" }
>
> </quote>
>
>
> Make sure your database name, user and password match the current catalogue
> database settings configured in your bacula-dir.conf. On your MariaDB
> server, you may need to use:
>
> mysql> grant all on your-bacula-database-name.* to your-bacula-user
> identified by 'your-password';
>
> to ensure everything is set up correctly again.
>
>
> Thanks.
> --
> Graham Sparks
>
> ________________________________
> From: Graham Dicker
> Sent: 23 December 2021 14:51
> To: bacula-users@lists.sourceforge.net <bacula-users@lists.sourceforge.net>
> Subject: [Bacula-users] make_catalog_backup stopped working
>
>
>
> Further to my previous post I notice that the user table contains the
> following. Is that what it should look like?
>
>
> MariaDB [mysql]> select host,user from user;
>
>
>
>
> ________________________________
> From: Graham Dicker
> Sent: 23 December 2021 14:42
> To: bacula-users@lists.sourceforge.net <bacula-users@lists.sourceforge.net>
> Subject: [Bacula-users] make_catalog_backup stopped working
>
>
> Hi all
>
>
> I'm running Bacula on a desk machine with OpenSuse 15.3 and Bacula 11.0.4.
>
>
> The make_catalog_backup command has stopped working following a complete
> loss and restore of my Bacula database.
>
> I don't know how the database vanished but I restored it from the last
> successful backup thus:
>
>
> ./bextract -b ../working/BackupCatalog.bsr /media/seagate4tb /tmp
>
> mysql
>
> create database bacula;
>
> use bacula;
>
> source bacula.sql;
>
> grant_mysql_privileges
>
>
> But now although my main backup works fine the backup of the catalog gets
> this error:
>
>
> 23-Dec 13:39 vivaldi-dir JobId 65: BeforeJob: mysqldump: Got error: 1044:
> "Access denied for user ''@'localhost' to database 'bacula'" when selecting
> the database
>
>
>
> Any clues? Thanks in advance.
_______________________________________________
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
