Debian Bug report logs - #452687
bacula: Catalog backup fails: incorrect parameters format for make_catalog_backup

Toggle useless messages

Message #5 received at submit@bugs.debian.org (full text, mbox, reply):

From: James Westby <jw+debian@jameswestby.net>

To: submit <submit@bugs.debian.org>

Subject: bacula: Catalog backup fails: incorrect parameters format for make_catalog_backup

Date: Sat, 24 Nov 2007 15:05:30 +0000

Package: bacula
Version: 2.2.5-1
Tags: patch

Hi,

In 

https://bugs.launchpad.net/ubuntu/+source/bacula/+bug/68725

it was reported that the catalog backup fails due to the wrong
parameters being passed to make_catalog_backup.

They use the following patch to correct that. Please consider
applying it.

Thanks,

James

--- 2.2.5-1/src/dird/bacula-dir.conf.in	2007-11-04 01:11:09.000000000
+0000
+++ 2.2.5-1ubuntu1/src/dird/bacula-dir.conf.in	2007-11-04 01:10:40.000000000 +0000
@@ -62,7 +62,7 @@ Job {
   FileSet="Catalog"
   Schedule = "WeeklyCycleAfterBackup"
   # This creates an ASCII copy of the catalog
-  RunBeforeJob = "@scriptdir@/make_catalog_backup bacula bacula"
+  RunBeforeJob = "@scriptdir@/make_catalog_backup <dbname> <user> <password>"
   # This deletes the copy of the catalog
   RunAfterJob  = "@scriptdir@/delete_catalog_backup"
   Write Bootstrap = "@working_dir@/BackupCatalog.bsr"

Message #10 received at 452687@bugs.debian.org (full text, mbox, reply):

From: John Goerzen <jgoerzen@complete.org>

To: 452687@bugs.debian.org

Cc: 452687-submitter@bugs.debian.org, control@bugs.debian.org

Subject: Not sure this is the right approach

Date: Wed, 30 Jan 2008 10:36:49 -0600

tags 452687 moreinfo
thanks

Hi James,

Thanks for sending this along.

I'm not sure the proposal is right.  From the source of make_catalog_backup:

# This script dumps your Bacula catalog in ASCII format
# It works for MySQL, SQLite, and PostgreSQL
#
#  $1 is the name of the database to be backed up and the name
#     of the output file (default = bacula).
#  $2 is the user name with which to access the database
#     (default = bacula).
#  $3 is the password with which to access the database or "" if no password
#     (default ""). WARNING!!! Passing the password via the command line is
#     insecure and should not be used since any user can display the command
#     line arguments and the environment using ps.  Please consult your
#     MySQL or PostgreSQL manual for secure methods of specifying the
#     password.
#  $4 is the host on which the database is located
#     (default "")

By having the first two as they are, we have a configuration that could at 
least work by default with some PostgreSQL databases.

I think that perhaps the best solution is to mention in README.Debian that 
this line will likely need to be modified during installation.

Not just that, but there are better, database-specific, ways to pass along 
passwords.

- John

Message #20 received at 452687@bugs.debian.org (full text, mbox, reply):

From: James Westby <jw+debian@jameswestby.net>

To: John Goerzen <jgoerzen@complete.org>

Cc: 452687@bugs.debian.org

Subject: Re: Bug#452687: Not sure this is the right approach

Date: Sat, 02 Feb 2008 11:41:11 +0000

On Wed, 2008-01-30 at 10:36 -0600, John Goerzen wrote:
> Hi James,
> 
> Thanks for sending this along.
> 
> I'm not sure the proposal is right.  From the source of make_catalog_backup:
> 
> # This script dumps your Bacula catalog in ASCII format
> # It works for MySQL, SQLite, and PostgreSQL
> #
> #  $1 is the name of the database to be backed up and the name
> #     of the output file (default = bacula).
> #  $2 is the user name with which to access the database
> #     (default = bacula).
> #  $3 is the password with which to access the database or "" if no password
> #     (default ""). WARNING!!! Passing the password via the command line is
> #     insecure and should not be used since any user can display the command
> #     line arguments and the environment using ps.  Please consult your
> #     MySQL or PostgreSQL manual for secure methods of specifying the
> #     password.
> #  $4 is the host on which the database is located
> #     (default "")
> 
> By having the first two as they are, we have a configuration that could at 
> least work by default with some PostgreSQL databases.
> 
> I think that perhaps the best solution is to mention in README.Debian that 
> this line will likely need to be modified during installation.
> 
> Not just that, but there are better, database-specific, ways to pass along 
> passwords.

Hi John,

It's obviously up to you whether to apply the patch, and I was simply
forwarding it, so I don't mind one way or the other. However, I think a
note in README.Debian would be a good start either way.

Thanks,

James

Message #31 received at 452687@bugs.debian.org (full text, mbox, reply):

From: jgoerzen@complete.org

To: <452687@bugs.debian.org>

Cc: <control@bugs.debian.org>

Subject: New commit

Date: Thu, 04 Feb 2010 03:38:41 +0000

tags 452687 pending
thanks

A commit relevant to this bug has occurred.

  Revision: 3254333ac1f774e2da84242373a3434bff72bef3

commit 3254333ac1f774e2da84242373a3434bff72bef3
Author: John Goerzen <jgoerzen@complete.org>
Date:   Wed Feb 3 21:38:24 2010 -0600

    Added comments to README.Debian about make_catalog_backup
    
    Closes: #452687.

Diff: http://git.debian.org/?p=users/jgoerzen/bacula;a=commitdiff_plain;h=3254333ac1f774e2da84242373a3434bff72bef3

 debian/README.Debian |    7 +++++++
 debian/changelog     |    3 ++-
 2 files changed, 9 insertions(+), 1 deletions(-)

More details are available at:
    http://git.debian.org/?p=users/jgoerzen/bacula;a=commit;h=3254333ac1f774e2da84242373a3434bff72bef3

Message #38 received at 452687-close@bugs.debian.org (full text, mbox, reply):

From: John Goerzen <jgoerzen@complete.org>

To: 452687-close@bugs.debian.org

Subject: Bug#452687: fixed in bacula 3.0.3-2

Date: Thu, 04 Feb 2010 19:32:47 +0000

Source: bacula
Source-Version: 3.0.3-2

We believe that the bug you reported is fixed in the latest version of
bacula, which is due to be installed in the Debian FTP archive:

bacula-client_3.0.3-2_all.deb
  to main/b/bacula/bacula-client_3.0.3-2_all.deb
bacula-common-mysql_3.0.3-2_i386.deb
  to main/b/bacula/bacula-common-mysql_3.0.3-2_i386.deb
bacula-common-pgsql_3.0.3-2_i386.deb
  to main/b/bacula/bacula-common-pgsql_3.0.3-2_i386.deb
bacula-common-sqlite3_3.0.3-2_i386.deb
  to main/b/bacula/bacula-common-sqlite3_3.0.3-2_i386.deb
bacula-common_3.0.3-2_i386.deb
  to main/b/bacula/bacula-common_3.0.3-2_i386.deb
bacula-console-qt_3.0.3-2_i386.deb
  to main/b/bacula/bacula-console-qt_3.0.3-2_i386.deb
bacula-console_3.0.3-2_i386.deb
  to main/b/bacula/bacula-console_3.0.3-2_i386.deb
bacula-director-common_3.0.3-2_i386.deb
  to main/b/bacula/bacula-director-common_3.0.3-2_i386.deb
bacula-director-mysql_3.0.3-2_i386.deb
  to main/b/bacula/bacula-director-mysql_3.0.3-2_i386.deb
bacula-director-pgsql_3.0.3-2_i386.deb
  to main/b/bacula/bacula-director-pgsql_3.0.3-2_i386.deb
bacula-director-sqlite3_3.0.3-2_i386.deb
  to main/b/bacula/bacula-director-sqlite3_3.0.3-2_i386.deb
bacula-director-sqlite_3.0.3-2_all.deb
  to main/b/bacula/bacula-director-sqlite_3.0.3-2_all.deb
bacula-fd_3.0.3-2_i386.deb
  to main/b/bacula/bacula-fd_3.0.3-2_i386.deb
bacula-sd-mysql_3.0.3-2_i386.deb
  to main/b/bacula/bacula-sd-mysql_3.0.3-2_i386.deb
bacula-sd-pgsql_3.0.3-2_i386.deb
  to main/b/bacula/bacula-sd-pgsql_3.0.3-2_i386.deb
bacula-sd-sqlite3_3.0.3-2_i386.deb
  to main/b/bacula/bacula-sd-sqlite3_3.0.3-2_i386.deb
bacula-sd-sqlite_3.0.3-2_i386.deb
  to main/b/bacula/bacula-sd-sqlite_3.0.3-2_i386.deb
bacula-sd_3.0.3-2_i386.deb
  to main/b/bacula/bacula-sd_3.0.3-2_i386.deb
bacula-server_3.0.3-2_all.deb
  to main/b/bacula/bacula-server_3.0.3-2_all.deb
bacula-traymonitor_3.0.3-2_i386.deb
  to main/b/bacula/bacula-traymonitor_3.0.3-2_i386.deb
bacula_3.0.3-2.diff.gz
  to main/b/bacula/bacula_3.0.3-2.diff.gz
bacula_3.0.3-2.dsc
  to main/b/bacula/bacula_3.0.3-2.dsc
bacula_3.0.3-2_all.deb
  to main/b/bacula/bacula_3.0.3-2_all.deb



A summary of the changes between this version and the previous one is
attached.

Thank you for reporting the bug, which will now be closed.  If you
have further comments please address them to 452687@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
John Goerzen <jgoerzen@complete.org> (supplier of updated bacula package)

(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmaster@debian.org)


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Format: 1.8
Date: Wed, 03 Feb 2010 21:37:56 -0600
Source: bacula
Binary: bacula bacula-common bacula-common-sqlite3 bacula-common-pgsql bacula-common-mysql bacula-director-common bacula-director-sqlite bacula-director-sqlite3 bacula-director-mysql bacula-director-pgsql bacula-client bacula-fd bacula-server bacula-sd bacula-sd-sqlite3 bacula-sd-sqlite bacula-sd-mysql bacula-sd-pgsql bacula-console bacula-console-qt bacula-traymonitor
Architecture: source all i386
Version: 3.0.3-2
Distribution: unstable
Urgency: medium
Maintainer: John Goerzen <jgoerzen@complete.org>
Changed-By: John Goerzen <jgoerzen@complete.org>
Description: 
 bacula     - network backup, recovery and verification - meta-package
 bacula-client - network backup, recovery and verification - client meta-package
 bacula-common - network backup, recovery and verification - common support files
 bacula-common-mysql - network backup, recovery and verification - MySQL common files
 bacula-common-pgsql - network backup, recovery and verification - PostgreSQL common fil
 bacula-common-sqlite3 - network backup, recovery and verification - SQLite v3 common file
 bacula-console - network backup, recovery and verification - text console
 bacula-console-qt - Bacula Administration Tool Console
 bacula-director-common - network backup, recovery and verification - Director common files
 bacula-director-mysql - network backup, recovery and verification - MySQL storage for Dir
 bacula-director-pgsql - network backup, recovery and verification - PostgreSQL storage fo
 bacula-director-sqlite - network backup, recovery and verification - SQLite 2 director tra
 bacula-director-sqlite3 - network backup, recovery and verification - SQLite 3 storage for
 bacula-fd  - network backup, recovery and verification - file daemon
 bacula-sd  - network backup, recovery and verification - storage daemon
 bacula-sd-mysql - network backup, recovery and verification - MySQL SD tools
 bacula-sd-pgsql - network backup, recovery and verification - PostgreSQL SD tools
 bacula-sd-sqlite - network backup, recovery and verification - SQLite SD tools
 bacula-sd-sqlite3 - network backup, recovery and verification - SQLite 3 SD tools
 bacula-server - network backup, recovery and verification - server meta-package
 bacula-traymonitor - network backup, recovery and verification - tray monitor
Closes: 452687 545313 545473 549081 554197
Changes: 
 bacula (3.0.3-2) unstable; urgency=medium
 .
   * Update build-dep from libmysqlclient15-dev to libmysqlclient-dev.
     Rebuild on a newer i386 sid machine; 3.0.3-1 will not migrate to testing
     due to dep on old libmysqlclient15 on i386.
   * Remove bacula-doc ln in debian/rules, correcting dpkg's idea that bacula
     has been completely removed on upgrade.
     Closes: #545473, #554197, #545313.
   * Add bpipe to built package.  Patch from Alex Bramley.  Closes: #549081.
   * Added comments about make_catalog_backup to README.Debian.  Closes: #452687.
Checksums-Sha1: 
 3b62c01e4578ad96ed1580cb9a513f250eda1b4b 1925 bacula_3.0.3-2.dsc
 4ada3556d51e0bfa3b1f29c47e5e502520b04310 54621 bacula_3.0.3-2.diff.gz
 d12af85af34d733b9108a3418fbdd90ab9bfdc39 1024 bacula_3.0.3-2_all.deb
 928b70c01c0583b0ed19bb8d984cbd870b0b921a 39796 bacula-director-sqlite_3.0.3-2_all.deb
 e8687382f7c9c6f691dc16e734d8cf8a384f8650 39824 bacula-client_3.0.3-2_all.deb
 3eb2337897a1561bd49ca07c8b7b6618774e2887 39744 bacula-server_3.0.3-2_all.deb
 e7744cadaa2242ad534d587c786fe0a79f9412d8 604778 bacula-common_3.0.3-2_i386.deb
 0ba08224dc10e196f291c0d57853f27f6b5cfa8f 81030 bacula-common-sqlite3_3.0.3-2_i386.deb
 3ee73926afe28d57a236b0ac40bd9d9e7c778f5e 85150 bacula-common-pgsql_3.0.3-2_i386.deb
 50189f6f3401490213817331e2c8a50b75f19f72 81586 bacula-common-mysql_3.0.3-2_i386.deb
 a8b2d4282cd5f3e33c93a147d9ec53310e8737ff 49974 bacula-director-common_3.0.3-2_i386.deb
 1759ead0e196e9ee0b9666921293350ee9c86ce7 279372 bacula-director-sqlite3_3.0.3-2_i386.deb
 b0817ec0aa096330d7fe42efa4af1394e183afc2 277584 bacula-director-mysql_3.0.3-2_i386.deb
 cfdb6170ea4f5f52a90b3c76b91461d98ff12594 278380 bacula-director-pgsql_3.0.3-2_i386.deb
 54ce757d38deaa0df15c1e20f49055d50d5533fd 109940 bacula-fd_3.0.3-2_i386.deb
 c24f8d4b20d89dc97bdf5a8ed8ff1a9d688f9591 434006 bacula-sd_3.0.3-2_i386.deb
 8fecee9f5233db0548af55b1c6478391b84f3495 409412 bacula-sd-sqlite3_3.0.3-2_i386.deb
 1d598094e4dfa7e4aeeccf23b64ee69c7212d6d2 39722 bacula-sd-sqlite_3.0.3-2_i386.deb
 216d4255348ada9553185facf100f0a54b7869fb 409428 bacula-sd-mysql_3.0.3-2_i386.deb
 3eee3721d2ad92148511b9b59dc580461deb7cbb 409440 bacula-sd-pgsql_3.0.3-2_i386.deb
 16f78543aaa4dfbf0c770e4519949cce5c775945 59790 bacula-console_3.0.3-2_i386.deb
 5ebd3f27f8065a4ebda9b7f66554c5340f0c08dd 521000 bacula-console-qt_3.0.3-2_i386.deb
 5622f242c01e651a081520fcdd5d0c3efbfd33d3 59770 bacula-traymonitor_3.0.3-2_i386.deb
Checksums-Sha256: 
 b0ed0ccae0962ab3cd8b64f7a258e452e98c4718a3ad199207ee7a490de096bf 1925 bacula_3.0.3-2.dsc
 46f5979c4a08636d41e6f3b316ae1f206c78f71cd4735d49ebbe6b57d9107695 54621 bacula_3.0.3-2.diff.gz
 0f5277bea04d83c8298ee15200118415a0c5e56496188a8d1aee6c8d19300ac4 1024 bacula_3.0.3-2_all.deb
 f4c050a8d36d4d95f744095a4e8782ea0cfcb060816229594dd91ea31964318b 39796 bacula-director-sqlite_3.0.3-2_all.deb
 afdba4eb5abd6d3beeb99f3ffef9f2f27451641c1baf33bb8b6b88191a44a887 39824 bacula-client_3.0.3-2_all.deb
 f7e62d30c3935e050b9df20f3f16bc6617a1e7aa0b5b00baef09b41c87c5beb1 39744 bacula-server_3.0.3-2_all.deb
 3b9d25a915bbb3631f2387842468768818c1ecce71e629aeed781e2788441ae5 604778 bacula-common_3.0.3-2_i386.deb
 b2eec6c1c5f9a32a38340f6f34b5266f1c199f1ab725195d96fd66483a1e8476 81030 bacula-common-sqlite3_3.0.3-2_i386.deb
 e024902c91a9fa4324ba2975877166d0e116322ac77e0671953014d4de45be26 85150 bacula-common-pgsql_3.0.3-2_i386.deb
 7a0ae8999a6378d690e45703da141fcf530e1ffcd1ae4f0aca9ef6572d9e4cba 81586 bacula-common-mysql_3.0.3-2_i386.deb
 6645844dbd67f9d0e493e40bd70f42944439e1cce20e7b02cfbc43ccacccfd5e 49974 bacula-director-common_3.0.3-2_i386.deb
 319bd7359c33989c8bedc8f80c9c25e7db04534bc4f71e0331036bd910709b96 279372 bacula-director-sqlite3_3.0.3-2_i386.deb
 9fe6a333868dd303596e027892e5d54d1b1285c3c5b4816e782fc3b750bf7295 277584 bacula-director-mysql_3.0.3-2_i386.deb
 488b01221076fdaeba91812c18d34e71ecba859013556fb8aa488a0023b807aa 278380 bacula-director-pgsql_3.0.3-2_i386.deb
 3223f78803b522deef9375ea38cd5808d40133ff3234b1dda4cf49d99b9d4ad8 109940 bacula-fd_3.0.3-2_i386.deb
 21d2cacf86ef4982a6e44744aa3f52d261d27cb0b5dbd0928fb949770227d482 434006 bacula-sd_3.0.3-2_i386.deb
 226595080032075f8a174b414ff9dcc64892ecf34bac410b0f862cb0eba3a9e6 409412 bacula-sd-sqlite3_3.0.3-2_i386.deb
 df8624dd4e27624402a9bf692989d87e1eadaf92931e95a3e57195740baa7ee3 39722 bacula-sd-sqlite_3.0.3-2_i386.deb
 872dfdc5467023096d5af274ff713d04a4e50315c81c7dd6372180001ccaeb56 409428 bacula-sd-mysql_3.0.3-2_i386.deb
 f6c03bf6cd06054a142871a8ee501056ff727497d5e5ad583e9bfc77b455456e 409440 bacula-sd-pgsql_3.0.3-2_i386.deb
 f2383586bf5178a4556f0d39f6a65a4853fda570f2a6bb417c84625fc9c69c94 59790 bacula-console_3.0.3-2_i386.deb
 236adde7873cfc874958d9778967dae42edf2b6d7d0aae4b1eb8c26dc7ece1e1 521000 bacula-console-qt_3.0.3-2_i386.deb
 0c918601d4a34cecf0161280e068bea0bef3ed4ec08e841ddd2b0ba46daef6bf 59770 bacula-traymonitor_3.0.3-2_i386.deb
Files: 
 e83d77e719fe81b44323cb6701338e18 1925 admin optional bacula_3.0.3-2.dsc
 7259abb99a3eb164902adcc9d25485ef 54621 admin optional bacula_3.0.3-2.diff.gz
 fc2fb3f310993fcee54c0ad43dd8ed78 1024 admin optional bacula_3.0.3-2_all.deb
 dee28734e6a2a28f276d00c400080f5e 39796 admin optional bacula-director-sqlite_3.0.3-2_all.deb
 adf6a20a05fab598c21a836c8e6f1cc2 39824 admin optional bacula-client_3.0.3-2_all.deb
 836b276696e21e5c7724b456611a8300 39744 admin optional bacula-server_3.0.3-2_all.deb
 daa6ccb045cd80abc997486f60aaec4b 604778 admin optional bacula-common_3.0.3-2_i386.deb
 f65a4dea524dca3853279e8c59bf14f3 81030 admin optional bacula-common-sqlite3_3.0.3-2_i386.deb
 1ea8e77d3a71f7d4bd0e5f8abd988c44 85150 admin optional bacula-common-pgsql_3.0.3-2_i386.deb
 ebca7364ad5bc3ace949b2dc416c6003 81586 admin optional bacula-common-mysql_3.0.3-2_i386.deb
 357cf43ce9971367598404a5fe86b79c 49974 admin optional bacula-director-common_3.0.3-2_i386.deb
 9d3f8cfba0a292580a1a3432e2c75604 279372 admin optional bacula-director-sqlite3_3.0.3-2_i386.deb
 fb1c8e451d55ba2a4289d2ad8a5c75b7 277584 admin optional bacula-director-mysql_3.0.3-2_i386.deb
 0a1640a97fa4ddb3b8bc6c92b097919c 278380 admin optional bacula-director-pgsql_3.0.3-2_i386.deb
 8942bb631d0a433b4954383d1db59675 109940 admin optional bacula-fd_3.0.3-2_i386.deb
 42c6b2efb0f322a1f694735eb6ed94d1 434006 admin optional bacula-sd_3.0.3-2_i386.deb
 e387fa74792fbfbc9a936ac978231f51 409412 admin optional bacula-sd-sqlite3_3.0.3-2_i386.deb
 61dfdb32c99d4e222166a7dfa4a148d3 39722 admin optional bacula-sd-sqlite_3.0.3-2_i386.deb
 306dfe05ac3f7802820872309575f5ea 409428 admin optional bacula-sd-mysql_3.0.3-2_i386.deb
 6f365910815c63b4cbd7c49fa1119118 409440 admin optional bacula-sd-pgsql_3.0.3-2_i386.deb
 5579929577e0199e03d992db7a3485a7 59790 admin optional bacula-console_3.0.3-2_i386.deb
 6c50801d2fd0e699626bb981b1c635f0 521000 admin optional bacula-console-qt_3.0.3-2_i386.deb
 7e838cb1b82b6bbaf12c210febadbd8f 59770 admin optional bacula-traymonitor_3.0.3-2_i386.deb

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEARECAAYFAktrHyEACgkQ3PeFtIodmh+6PgCgkBtlC0nLQULEDikFYQ9phocK
HzcAn3NiGFwrV7hFDurNuyO+nEvBlEZo
=0wsp
-----END PGP SIGNATURE-----

Send a report that this bug log contains spam.