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
