Adding "catalog = all" to the Catalog resource is wrong. Also, check for
other Messages resources. The one you posted with name = Daemon is usually
only used for background messages.
If that doesn't help, then you could try the bconsole command:
setdebug director level=500 trace=1
This will create a trace file in the working directory which should contain
messages about "INSERT INTO Log".
__Martin
>>>>> On Fri, 4 Sep 2020 18:00:28 -0400 (EDT), Russell DeFlavia said:
>
> Hello all,
>
> Thank you again to Phil, Martin, and to all on this excellent list!
>
> I meant to send this to the list; so, I am forwarding this reply that I sent
> to Martin with hopes of benefiting others on the list.
>
> With kind regards,
> Russell
>
> > ---------- Original Message ----------
> > From: Russell DeFlavia <rdefla...@comcast.net>
> > To: Martin Simmons <mar...@lispworks.com>
> > Date: 09/04/2020 12:39 PM
> > Subject: Re: [Bacula-users] Bacula / MySQL Question
> >
> >
> > Hi Martin,
> >
> > I hope you are doing well and thank you for your reply!
> >
> > I am seeing the job output in root's email; but, not from the "select"
> > statement in "mysql" or from the BAT gui when I double-click on a job
> > number. This all occurred "after" I converted from "sqlite3" to "mysql"
> > which was an overall success except for this issue.
> >
> > I have "catalog = all" in my "Catalog" block and also in my "Messages"
> > block in the "/etc/bacula/bacula-dir.conf" file; but, the "LogText DB
> > element" is still not being populated with the same output I used to see
> > before, yet the dialogue is contained in root's email. This is also why
> > "list joblog jobid={jubnum}" returns "No results to list".
> >
> > Am I missing something with my syntax or placement of the "catalog = all"
> > statement? Is the "catalog" option I am using correct? Can you recommend
> > any debug methods? This is the last piece of the puzzle that I am hopeful
> > to resolve.
> >
> > # Generic catalog service
> > Catalog {
> > . . .
> > catalog = all
> > }
> >
> > Messages {
> > Name = Daemon
> > mailcommand = "/usr/sbin/bsmtp -h localhost -f \"\(Bacula\) \<%r\>\" -s
> > \"Bacula daemon message\" %r"
> > mail = root = all, !skipped
> > console = all, !skipped, !saved
> > append = "/var/log/bacula/bacula.log" = all, !skipped
> > catalog = all
> > }
> >
> > Thanks and regards,
> > Russ
> >
> > > On 09/02/2020 9:56 AM Martin Simmons <mar...@lispworks.com> wrote:
> > >
> > >
> > > >>>>> 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
>
>
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
