[Bug 614320] [NEW] bacula awk script for sqlite catalog backup broken

[David Stenglein]

Public bug reported:

Binary package hint: bacula-director-sqlite3

When I try to run a catalog backup it appears to be endlessly looping
and recreating the sqlite dump. It is not quite endless though, just a
bug in the awk script.

The script /etc/bacula/scripts/make_catalog_backup_awk contains:

system("echo '.dump' | /usr/bin/sqlite3 /var/lib/bacula/bacula.db >
/var/lib/bacula/bacula.sql")

This gets run as part of:

/usr/bin/awk -f /etc/bacula/scripts/make_catalog_backup_awk -v
cat1=MyCatalog /etc/bacula/bacula-dir.conf

which essentially does the sqlite dump for every line in bacula-
dir.conf.

The simplest way to solve this and maintain compatibility with other
versions of this script for other databases is to use:

BEGIN {system("echo '.dump' | /usr/bin/sqlite3 /var/lib/bacula/bacula.db
> /var/lib/bacula/bacula.sql")}

This may have gone unnoticed since the sqlite3 back-end is not the
default for bacula installs.

** Affects: bacula
     Importance: Undecided
         Status: New

** Affects: bacula (Ubuntu)
     Importance: Undecided
         Status: New

** Also affects: bacula
   Importance: Undecided
       Status: New

-- 
bacula awk script for sqlite catalog backup broken
https://bugs.launchpad.net/bugs/614320
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to bacula in ubuntu.