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
