[pkg-bacula-devel] Bug#719679: bacula-director-pgsql: MySQL-specific SQL syntax included as general SQL breaking other backends.

[Jonathan Wright]

Package: bacula-director-pgsql
Version: 5.2.6+dfsg-9
Severity: normal

Recent changes in Bacula to fix the issues with counters in MySQL 5.5 have introduced MySQL-specific syntax into general SQL statements which breaks other backends, including PostgreSQL. This breaks both counter creation and counter updates.

-- System Information:
Debian Release: 7.1
  APT prefers stable-updates
  APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 3.2.0-4-amd64 (SMP w/8 CPU cores)
Locale: LANG=en_GB.UTF8, LC_CTYPE=en_GB.UTF8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages bacula-director-pgsql depends on:
ii  bacula-common                              5.2.6+dfsg-9
ii  bacula-common-pgsql                        5.2.6+dfsg-9
ii  bacula-director-common                     5.2.6+dfsg-9
ii  dbconfig-common                            1.8.47+nmu1
ii  debconf [debconf-2.0]                      1.5.49
ii  libc6                                      2.13-38
ii  libcap2                                    1:2.22-1.2
ii  libgcc1                                    1:4.7.2-5
ii  libpython2.7                               2.7.3-6
ii  libssl1.0.0                                1.0.1e-2
ii  libstdc++6                                 4.7.2-5
ii  libwrap0                                   7.6.q-24
ii  postgresql-client                          9.1+140-we7.1
ii  postgresql-client-9.1 [postgresql-client]  9.1.9-1
ii  postgresql-client-9.2 [postgresql-client]  9.2.4-1
ii  ucf                                        3.0025+nmu3
ii  zlib1g                                     1:1.2.7.dfsg-13

Versions of packages bacula-director-pgsql recommends:
pn  postgresql  <none>

Versions of packages bacula-director-pgsql suggests:
ii  gawk                1:4.0.1+dfsg-2.1
pn  postgresql-contrib  <none>
pn  postgresql-doc      <none>

-- debconf information:
  bacula-director-pgsql/app-password-confirm: (password omitted)
  bacula-director-pgsql/password-confirm: (password omitted)
  bacula-director-pgsql/pgsql/admin-pass: (password omitted)
  bacula-director-pgsql/pgsql/app-pass: (password omitted)
* bacula-director-pgsql/pgsql/method: unix socket
* bacula-director-pgsql/pgsql/authmethod-admin: ident
  bacula-director-pgsql/passwords-do-not-match:
  bacula-director-pgsql/pgsql/no-empty-passwords:
  bacula-director-pgsql/upgrade-backup: true
  bacula-director-pgsql/install-error: abort
  bacula-director-pgsql/internal/reconfiguring: false
* bacula-director-pgsql/db/app-user: bacula
  bacula-director-pgsql/dbconfig-reinstall: false
  bacula-director-pgsql/dbconfig-remove:
* bacula-director-pgsql/db/dbname: bacula
  bacula-director-pgsql/remote/host:
* bacula-director-pgsql/pgsql/admin-user: postgres
* bacula-director-pgsql/pgsql/authmethod-user: ident
  bacula-director-pgsql/upgrade-error: abort
  bacula-director-pgsql/internal/skip-preseed: false
  bacula-director-pgsql/purge: false
  bacula-director-pgsql/database-type: pgsql
  bacula-director-pgsql/remote/port:
  bacula-director-pgsql/pgsql/changeconf: false
  bacula-director-pgsql/remote/newhost:
  bacula-director-pgsql/unsafe-director-password-was-changed:
  bacula-director-pgsql/pgsql/manualconf:
* bacula-director-pgsql/dbconfig-install: true
  bacula-director-pgsql/dbconfig-upgrade: true
  bacula-director-pgsql/missing-db-package-error: abort
  bacula-director-pgsql/remove-error: abort