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
