Your message dated Mon, 23 Jan 2012 10:02:10 +0000
with message-id <[email protected]>
and subject line Bug#654388: fixed in automysqlbackup 2.6+debian-1
has caused the Debian Bug report #654388,
regarding automysqlbackup: Script fails with error when DBNAMES="all"
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
654388: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=654388
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: automysqlbackup
Version: 2.5-6
Severity: important
Tags: patch
I found that the automysqlbackup script (Debian version) fails to run as
expected when setting specific options in the /etc/default/automysqlbackup
configuration file.
Setting 'DBEXCLUDE' with a list of DB names that wish to be excluded.
The documentation states that for this to work you MUST set DBNAMES="all"
This combination will produce an access rights error. This is due to
MySQL being called without the debian.cnf defaults-file.
In the /usr/sbin/automysqlbackup there are already Debian customisations
checking for a configured USERNAME and PASSWORD. If these are not set
then a Debian specific override is used with a reference to the debian.cnf
MySQL config file.
In the case that DBNAMES="all" is set, there was no check and the
variables USERNAME and PASSWORD are expected to exist and be correct.
The attached patch uses the same type of check to override the call to
mysql calling it with the 'defaults-file' option.
A further check through the script did not reveal, to me, any further
issues of this nature.
Regards
Chris
-- System Information:
Debian Release: 6.0.3
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: i386 (i686)
Kernel: Linux 2.6.32-5-686 (SMP w/1 CPU core)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
--- /usr/sbin/automysqlbackup Sun May 16 18:17:52 2010
+++ /tmp/automysqlbackup Tue Dec 27 11:00:55 2011
@@ -484,7 +484,11 @@
# If backing up all DBs on the server
if [ "$DBNAMES" = "all" ]; then
+ if [ -z "${USERNAME}" -o -z "${PASSWORD}" ] ; then
+ DBNAMES="`mysql --defaults-file=/etc/mysql/debian.cnf --batch
--skip-column-names -e "show databases"| sed 's/ /%/g'`"
+ else
DBNAMES="`mysql --user=$USERNAME --password=$PASSWORD --host=$DBHOST
--batch --skip-column-names -e "show databases"| sed 's/ /%/g'`"
+ fi
# If DBs are excluded
for exclude in $DBEXCLUDE
--- End Message ---
--- Begin Message ---
Source: automysqlbackup
Source-Version: 2.6+debian-1
We believe that the bug you reported is fixed in the latest version of
automysqlbackup, which is due to be installed in the Debian FTP archive:
automysqlbackup_2.6+debian-1.debian.tar.gz
to main/a/automysqlbackup/automysqlbackup_2.6+debian-1.debian.tar.gz
automysqlbackup_2.6+debian-1.dsc
to main/a/automysqlbackup/automysqlbackup_2.6+debian-1.dsc
automysqlbackup_2.6+debian-1_all.deb
to main/a/automysqlbackup/automysqlbackup_2.6+debian-1_all.deb
automysqlbackup_2.6+debian.orig.tar.gz
to main/a/automysqlbackup/automysqlbackup_2.6+debian.orig.tar.gz
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 [email protected],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Thomas Goirand <[email protected]> (supplier of updated automysqlbackup 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 [email protected])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160
Format: 1.8
Date: Mon, 23 Jan 2012 17:02:38 +0800
Source: automysqlbackup
Binary: automysqlbackup
Architecture: source all
Version: 2.6+debian-1
Distribution: unstable
Urgency: low
Maintainer: Thomas Goirand <[email protected]>
Changed-By: Thomas Goirand <[email protected]>
Description:
automysqlbackup - daily, weekly and monthly backup for your MySQL database
Closes: 654388
Changes:
automysqlbackup (2.6+debian-1) unstable; urgency=low
.
* New upstream version. With this new Debian release, I'm deciding to
completely fork upstream work, as it's being impossible to work with
upstream (no responsiveness), that upstream branch diverged, and is still
containing the very bad security issue to save DBs dumps as world readable
after my repeated warnings.
* debian/copyright now using DEP5 format.
* Added Vcs fields and a debian/gbp.conf.
* Switching to source format 1.0 (quilt).
* Removed now useless Dm-Upload-Allowed:, and now using my @debian.org email
as maintainer.
* Now depends on mysql-client-5.1 | mysql-client (and not 5.0 anymore).
* Standards-Version: is now 3.9.2.
* Remove "a" article in short description.
* Added build-arch: and build-indep: targets in debian/rules.
* Fixes Script fails with error when DBNAMES="all", thanks to Chris Moules
<[email protected]> (Closes: #654388).
Checksums-Sha1:
a321227cf3eec9a2a76a8e45278ca64dd83605dc 1307 automysqlbackup_2.6+debian-1.dsc
7c548f70d82b9a6a9ace913d98ed22c4a0432e67 8344
automysqlbackup_2.6+debian.orig.tar.gz
d2914846b7fd9f185cab5a8506bff7c486858479 5504
automysqlbackup_2.6+debian-1.debian.tar.gz
8c7c85e7d7a6b7d06afe592335ec57affe634599 14330
automysqlbackup_2.6+debian-1_all.deb
Checksums-Sha256:
21e72183e1a03c7c91f9b8f8f9c5db18f514361999ce4625f2630bb9e9a0b4ef 1307
automysqlbackup_2.6+debian-1.dsc
f005cbe0e18eee5936f8a0658dfe0bb58023f5a7ee4e56e78b766b1c5cd6f1e1 8344
automysqlbackup_2.6+debian.orig.tar.gz
bfa9b04015931df400415ff8098b42bfecee3a380a78bb182c4abedad9951bc5 5504
automysqlbackup_2.6+debian-1.debian.tar.gz
ff82baf19454d69508d396f3c65d4723fcac28bc5e3fe4d31864166415f07789 14330
automysqlbackup_2.6+debian-1_all.deb
Files:
7864da70dfead5313583afca0abbd66a 1307 admin extra
automysqlbackup_2.6+debian-1.dsc
72ac6a36aa8cc99aefba290b149c1447 8344 admin extra
automysqlbackup_2.6+debian.orig.tar.gz
7a9440f8653643a7cbb85e13e2d1dd47 5504 admin extra
automysqlbackup_2.6+debian-1.debian.tar.gz
b4151e6209b890c1006e7d6f4f3779a8 14330 admin extra
automysqlbackup_2.6+debian-1_all.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
iEUEAREDAAYFAk8dLgsACgkQl4M9yZjvmklTagCWL7XNas8/yWAFvRfPcVLQLvs1
uQCfcmp4H8d1DsL2oqU/eMyJRbXjCTY=
=4sWV
-----END PGP SIGNATURE-----
--- End Message ---
