>>>>> On Tue, 1 Sep 2020 13:59:01 -0400, Phil Stracchino said: > > On 2020-09-01 10:54, Russell DeFlavia wrote: > > Greetings and good day all! > > > > Regarding Bacula, ever since I migrated my database from sqlite3 to > > mysql, the LogText element in the Log table is no longer populated. > > > > +-----------------+ > > | From "bconsole" | > > +-----------------+ > > *list joblog jobid=121 > > No results to list. > > +-------+---------------+---------------------+------+-------+----------+-------------+-----------+ > > > > | JobId | Name | StartTime | Type | Level | JobFiles | JobBytes | > > JobStatus | > > +-------+---------------+---------------------+------+-------+----------+-------------+-----------+ > > > > | 121 | BackupCatalog | 2020-08-26 23:28:59 | B | F | 1 | 234,509,651 | T | > > +-------+---------------+---------------------+------+-------+----------+-------------+-----------+ > > > > > > +------------+ > > | From MySQL | > > +------------+ > > mysql> SELECT Time, LogText FROM Log WHERE JobId='121' order by Time; > > Empty set (0.00 sec) > > > > mysql> select * from Log where JobID='121'; > > Empty set (0.00 sec) > > > > Does anyone have an idea as to what may be causing this to happen? > > > What I can tell you is that I have been using Bacula with a MySQL > backend for almost as long as Bacula has been around, and my Log table > is empty as well. So it's not just you. The MySQL backend just does > not appear to ever use that table. > > Whether this is *intentional* is another question, which I am unable to > answer.
It only writes to the Log table if you include a catalog option in the Messages config in bacula-dir.conf. __Martin _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users