On 08/09/2018 01:59 PM, Bill Arlofski wrote:
> Hi Steve,
>
> There is a "comment" field in the db for media table. This might be useful
> for your case.
>
>
> In bconsole, you can:
>
> * update volume=xxxxx comment="Files restored from this volume on 20180809"
>
> can also be scripted: (sorry, will wrap in email)
>
> echo "update volume=xxxxx comment=\"Files restored from this volume on
> 20180809\"" | bconsole
>
>
> Hope this helps,
>
> Bill
Hi Steve,
This question was interesting to me so it motivated me to start writing a nice
how-to and a script to do this automatically after a restore job. ;)
I instantly ran into the fact that the bconsole "update volume" command does
not seem to accept comment="xxxxxx" for a volume in the same way a run job=xxx
comment="yyyy zzzz" does.
I will make a feature request for this - both for the Community version and
internally for the Bacula Enterprise version.
But... In the mean time I am 99% finished with a nice automated way that will
allow you to:
- Run a restore job
- Automatically call my shell script in a Runscript { RunsWhen = After }
stanza of the restore job
- The script checks to see if the restore job terminated "Restore OK" because
this is
(RunsOnFail=no would make this additional check unnecessary of course :)
- If the Restore job was OK, then the script will determine the volumes that
were read during the restore
- Next, with this list of volumes, it will check each volume to see if it has
a comment already.
- If no, it will just add a new comment like:
"A test restore from this volume was done ${now} using restore jobid xxxx"
- If yes, it will append the new comment to the current comment
Now, there is one other minor issue I am dealing with and that is when using
bconsole's "sql" command to add the comment, it seems like it is sanitizing
the input because I cannot seem to insert a line feed so that comments look
nice like:
----8<----
A test restore from this volume was done 20180810195703 with restore jobid 100
A test restore from this volume was done 20180810195714 with restore jobid 101
----8<---
Instead, I have to currently just append/separate each additional comment with
a " **** " so it looks like:
----8<----
A test restore from this volume was done 20180810195703 with restore jobid 100
**** A test restore from this volume was done 20180810195714 with restore
jobid 101 **** A test restore from this volume was done 20180810195809 using
restore jobid 102 ****
----8<----
Currently not pretty, but the important information is retained in the comment.
:)
I could easily just use direct database 'psql' or 'mysql' commands, but I'd
rather keep this simple and just use bconsole for all the modifications to the
db in this case - hence the feature request for the "comment=" option for the
"update volume" command too. ;)
This script just needs a little bit of clean-up and some error checking added
and I will release it ASAP.
Hope this helps!
Bill
--
Bill Arlofski
http://www.revpol.com/bacula
-- Not responsible for anything below this line --
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
