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. -- 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