On 12/26/21 07:47, Graham Dicker wrote:
I see that my attempts to paste messages copied from a console window into an
email are not working as I expect. Trying again...The message above should
have read:
26-Dec 09:39 bacula-dir JobId 0: Fatal error: Could not open Catalog
"MyCatalog", database "bacula".
26-Dec 09:39 bacula-dir JobId 0: Fatal error: mysql.c:293 Unable to connect to
MySQL server.
Database=bacula User=bacula
MySQL connect failed either server not running or your authorization is
incorrect.
26-Dec 09:39 bacula-dir ERROR TERMINATION
Please correct configuration file: /opt/bacula/etc/bacula-dir.conf
From all of the above it appears that your MySQL credentials are
incorrectly configured.
You say you can log into the mysql instance as root. Do this:
mysql> select user, host from mysql.user;
See if there is a bacula user or another such user that you created for
your catalog database. You should see something like:
+-------------+-------------+
| User | Host |
+-------------+-------------+
| alaric | 10.24.32.% |
| bacula | 10.24.32.% |
| books | 10.24.32.% |
...
If so:
mysql> GRANT ALL PRIVILEGES ON bacula.* TO 'bacula'@'localhost' (or
whatever DB user you want bacula to connect as) IDENTIFIED BY 'bacula
password goes here';
mysql> FLUSH PRIVILEGES;
If there is not an existing user for bacula, run the same command, but
make up a new username. (For sanity's sake I suggest using 'bacula',
then you'll never be in any doubt what it is.)
Then go back into your Bacula director config, set the mysql credentials
to what you just set above, restart the Director, and try again.
KMail/akonadi is a separate issue. I'm not a fan of services that set
up their own embedded mysql instances. Multiple mysql (or most other
database) instances running on the same host will ALWAYS, *ALWAYS*,
perform worse, for all services, than a single properly tuned instance
utilizing the same resources.
--
Phil Stracchino
Babylon Communications
ph...@caerllewys.net
p...@co.ordinate.org
Landline: +1.603.293.8485
Mobile: +1.603.998.6958
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
