[pkg-bacula-devel] Bug#674809: bacula-director-mysql: failure with mysql 5.5: MaxValue is now a keyword

[Corey Hickey]

Package: bacula-director-mysql
Version: 5.0.3+dfsg-0.1
Severity: important
Tags: patch

Hi,

I've been getting some errors from bacula like:

You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near
'MaxValue,CurrentValue,WrapCounter FROM Counters WHERE Counter='serial''
at line 1

This is due to MAXVALUE becoming a keyword in mysql 5.5. Upstream has
patched this some time ago:

http://www.bacula.org/git/cgit.cgi/bacula/patch/?id=448cd337f99cdc43aef9431d4194fc792bd08271

The patch is applicable to bacula-5.0.3+dfsg, but I couldn't build that
without first downgrading mysql from 5.5 to 5.1 (undefined references
when linking). I can file a separate bug for that if anyone wants.

After rebuilding the package, I was able to get it to work with mysql
5.5.

Thanks,
Corey


-- System Information:
Debian Release: wheezy/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (1, 'experimental')
Architecture: amd64 (x86_64)

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

Versions of packages bacula-director-mysql depends on:
ii  bacula-common                    5.0.3+dfsg-0.1
ii  bacula-common-mysql              5.0.3+dfsg-0.1
ii  bacula-director-common           5.0.3+dfsg-0.1
ii  dbconfig-common                  1.8.47+nmu1
ii  debconf [debconf-2.0]            1.5.43
ii  libc6                            2.13-32
ii  libgcc1                          1:4.7.0-8
ii  libmysqlclient16                 5.1.62-1
ii  libpython2.7                     2.7.3~rc2-2.1
ii  libssl1.0.0                      1.0.1c-1
ii  libstdc++6                       4.7.0-8
ii  libwrap0                         7.6.q-23
ii  mysql-client-5.5 [mysql-client]  5.5.23-2
ii  zlib1g                           1:1.2.7.dfsg-1

Versions of packages bacula-director-mysql recommends:
pn  mysql-server  <none>

bacula-director-mysql suggests no packages.

-- debconf information:
  bacula-director-mysql/mysql/admin-user: root
  bacula-director-mysql/purge: false
  bacula-director-mysql/remove-error: abort
  bacula-director-mysql/internal/skip-preseed: false
* bacula-director-mysql/dbconfig-install: true
  bacula-director-mysql/db/app-user: bacula
  bacula-director-mysql/upgrade-backup: true
  bacula-director-mysql/install-error: abort
  bacula-director-mysql/db/dbname: bacula
  bacula-director-mysql/remote/host:
  bacula-director-mysql/upgrade-error: abort
  bacula-director-mysql/remote/port:
  bacula-director-mysql/passwords-do-not-match:
  bacula-director-mysql/dbconfig-upgrade: true
  bacula-director-mysql/missing-db-package-error: abort
  bacula-director-mysql/remote/newhost:
  bacula-director-mysql/database-type: mysql
  bacula-director-mysql/mysql/method: unix socket
  bacula-director-mysql/internal/reconfiguring: false
  bacula-director-mysql/dbconfig-reinstall: false
  bacula-director-mysql/dbconfig-remove: