On 2021-12-26 18:19, Phil Stracchino wrote:
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;
When using MySQL roles and grant statement to change privileges, the
command "flush privileges" is not necessary but it doesn't hurt.
When modifying mysql/user and similar tables then it is necessary to
issue "flush privileges" in order to re-read and apply changes made to
the tables.
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.
Unfortunately, many years ago KDE PIM application suite moved to
akonadi which uses and manages its own mysql instance. That made
it awfully slow and unstable, hard to debug and understand and even
harder to trace the problem and fix but the wheel of "progress"
doesn't care much about functionality.
Also, you mentioned "embedded instance" but I am not sure if this
can be called embedded instance because the there is an actual
mysql daemon running. It just uses dedicated config file and datadir.
MySQL used to support embedded instance which meant that you could
access your data without daemon running. This was a long time ago
and I don't know if such support still exists in MySQL. I remember
that the data file needed to be preallocated to about 32MB which was
too much for my purposes.
That's when I learned about SQLite and moved in different direction.
Regards!
--
Josip Deanovic
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
