Package: mysql-client-5.0 Version: 5.0.24a-9 Severity: important I'm using mysqldump to save a copy of a mysql database running on a different machine on a non-standard port (in case it matters: That's an mysql4). So I have a daily cronjob like (names changed to protect the guilty):
| mysqldump -h data.company.example.com accounts >$DUMPFILE
with a ~/.my.cnf like
| [client]
| host = data.company.example.com
| user = thatsme
| password = topsecret
| port = 14854
Now I find that the cronjob failed after an upgrade to testing:
| mysqldump: Got error: 2003: Can't connect to MySQL server on
| 'data.company.example.com' (111) when trying to connect
Using strace and similar tools I find:
- ~/.my.cnf is opened and read
- the "port" directive is ignored:
| connect(3, {sa_family=AF_INET, sin_port=htons(3306),
should be 14854 ^^^^
| sin_addr=inet_addr("192.168.4.214")}, 16) = -1 ECONNREFUSED (Connection
| refused)
- the "user" directive is read
- but: Even if I supply the port using "-P", authentification fails when
mysqldump tries to lock the table.
If this is an upgrade issue, place grim warning in all appropriate
places (postinst, README.Debian).
Christoph
-- System Information:
Debian Release: testing/unstable
APT prefers testing
APT policy: (500, 'testing')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.18.1
Locale: [EMAIL PROTECTED], [EMAIL PROTECTED] (charmap=UTF-8)
Versions of packages mysql-client-5.0 depends on:
ii debianutils 2.17 Miscellaneous utilities specific t
ii libc6 2.3.6.ds1-4 GNU C Library: Shared libraries
ii libdbd-mysql-perl 3.0007-1 A Perl5 database interface to the
ii libdbi-perl 1.52-1 Perl5 database interface by Tim Bu
ii libgcc1 1:4.1.1-13 GCC support library
ii libmysqlclient15off 5.0.24a-9 mysql database client library
ii libncurses5 5.5-3 Shared libraries for terminal hand
ii libreadline5 5.1-9 GNU readline and history libraries
ii libstdc++6 4.1.1-13 The GNU Standard C++ Library v3
ii libwrap0 7.6.dbs-11 Wietse Venema's TCP wrappers libra
ii mysql-common 5.0.24a-9 mysql database common files (e.g.
ii perl 5.8.8-6.1 Larry Wall's Practical Extraction
ii zlib1g 1:1.2.3-13 compression library - runtime
mysql-client-5.0 recommends no packages.
-- no debconf information
signature.asc
Description: Digital signature
