On Saturday, 25 December 2021 17:18:56 GMT Josip Deanovic wrote:
> On Friday 2021-12-24 13:32:42 Graham Dicker wrote:
> > Thanks for the tip Phil, which I will bear in mind if I ever get Bacula
> > working again as it should (and has done for the past 10 years or more).
> > Up until about a year ago my workstation would boot itself up when
> > woken by the motherboard timer and Bacula would start running as a
> > service and do the necessary backups. The first thing that stopped
> > working was the service. There seemed to be some problem with timing
> > between Bacula and mysql. I got around it by dropping the service and
> > using crontab to start mysql and Bacula in that order. Then a few
> > months ago that started failing due to some disagreement between
> > akonadi, Bacula and mysql as to where the mysql socket was and which
> > port was to be used. I solved that by total surrender to akonadi and
> > told Bacula to use the socket created by akonadi. Now I don't know
> > what's gone wrong. KMail behaviour has also changed in the last few day
> > also; I have to click on it twice to make it start up. I think OpenSuse
> > 15.3 must have had some dodgy updates recently.
> 
> That would explain why your database disappeared. It seems that you
> have been using mysql instance dedicated to akonadi service.
> 
> I don't know how things are setup on Suse but on Centos/RHEL, akonadi
> service would by default bring up its own mysql instance, with its own
> mysql config file and data directory. It would also use its own socket.
> 
> I wouldn't use that mysql instance for anything else but akonadi.
> 
> I strongly suggest that you configure and bring up normal mysql service
> which can safely be used for bacula and other services as you se fit.
> If configured correctly you will not lose your databases any more.
> 
> The timing between mysql and Bacula you have mentioned is likely caused
> by the akonadi which starts its mysql instance and that happens only
> during the graphical login or even after you start the "kontact" or
> similar application such as "kmail".
> 
> 
> Regards!

Thank you Josip this is very helpful. I have restored everything I had tinkered 
with back to 
what it was, that is:

Removed specification of port and socket from /etc/my.cnf
Removed specification of port and socket from bacula-dir.conf

both of this were previously specifying the akonadi socket and port 3306

now './bacula' start from a console as root puts this message in the log:

26-Dec 09:40 bacula-dir JobId 0: Fatal error: Could not open Catalog 
"MyCatalog", 
database "bacula". 

If I run mysql from a console as root then 'use bacula' succeeds and I can 
access the tables 
but if i try the same thing as a normal user I get:

MariaDB [(none)]> use bacula; 

KMail/akonadi behaviour is still not normal. I have to click the Kmail icon, 
then the 
desktop, then KMail icon again to get it to start, and at least the first time 
of collecting my 
POP3 email takes a lot longer than usual.

Graham
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to