[pkg-bacula-devel] Bug#674809: bacula-director-mysql: failure with mysql 5.5: MaxValue is now a keyword
Corey Hickey
bugfood-c at fatooh.org
Sun May 27 21:00:54 UTC 2012
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:
More information about the pkg-bacula-devel
mailing list