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: -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
