Your message dated Tue, 17 Jan 2006 14:34:58 -0800
with message-id <[EMAIL PROTECTED]>
and subject line Bug#345895: fixed in mysql-dfsg-5.0 5.0.18-6
has caused the attached Bug report 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 I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--------------------------------------
Received: (at submit) by bugs.debian.org; 4 Jan 2006 04:46:45 +0000
>From [EMAIL PROTECTED] Tue Jan 03 20:46:45 2006
Return-path: <[EMAIL PROTECTED]>
Received: from sccrmhc13.comcast.net ([204.127.202.64])
by spohr.debian.org with esmtp (Exim 4.50)
id 1Eu0Xt-0007wg-5s
for [EMAIL PROTECTED]; Tue, 03 Jan 2006 20:46:45 -0800
Received: from zona.someotherplace.org (zona.afraid.org[69.243.114.36])
by comcast.net (sccrmhc13) with ESMTP
id <20060104044613013008u8dfe>; Wed, 4 Jan 2006 04:46:14 +0000
Received: by zona.someotherplace.org (Postfix, from userid 1001)
id B52AC7D039; Tue, 3 Jan 2006 23:45:59 -0500 (EST)
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: David Coe <[EMAIL PROTECTED]>
To: Debian Bug Tracking System <[EMAIL PROTECTED]>
Subject: mysql-server-5.0: fails to start after upgrade from 4.1;
README.Debian not helpful...
Message-ID: <[EMAIL PROTECTED]>
X-Mailer: reportbug 3.18
Date: Tue, 03 Jan 2006 23:45:59 -0500
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Level:
X-Spam-Status: No, hits=-7.5 required=4.0 tests=BAYES_00,HAS_PACKAGE,
RCVD_IN_SORBS autolearn=no version=2.60-bugs.debian.org_2005_01_02
Package: mysql-server-5.0
Version: 5.0.18-1
Severity: important
I don't know much about mysql, so I'm writing this from a naive user's
perspective. This may or may not be similar to what's described in
#330624 "Why does install not configure passwords?" -- I haven't yet
determined what the problem is.
I had mysql 4.1 installed and working, only because some stupid perl
script (not from a debian package) would only log to a mysql table;
everything was working fine, and I don't remember what I had to do
(if anything) after installing 4.1 to get it working, but that was
quite some time ago.
Tonight I upgraded from:
libmysqlclient14_4.1.15-1_i386.deb
libmysqlclient15_5.0.16-1_i386.deb
mysql-client-4.1_4.1.15-1_i386.deb
mysql-common_5.0.16-1_i386.deb
mysql-server-4.1_4.1.15-1_i386.deb
to:
ii libmysqlclient15 5.0.18-1 mysql database client library
ii mysql-client-4.1 5.0.18-1 empty transitional package
ii mysql-client-5.0 5.0.18-1 mysql database client binaries
ii mysql-common 5.0.18-1 mysql database common files (e.g.
/etc/mysql
ii mysql-server-4.1 5.0.18-1 empty transitional package
ii mysql-server-5.0 5.0.18-1 mysql database server binaries
In case it matters, I also have these installed (not changed tonight):
ii libdbd-mysql-perl 3.0002-2 A Perl5 database interface to the
MySQL data
ii libmysqlclient12 4.0.24-10sarge1 mysql database client library
During the postinst, and manually afterwards, mysql start fails as follows:
# /etc/init.d/mysql start
Starting MySQL database server: mysqld...failed or took more than 6s.
Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock'
exists!
syslog:
Jan 3 20:22:35 zona mysqld_safe[7369]: started
Jan 3 20:22:36 zona mysqld[7372]: 060103 20:22:36 InnoDB: Started; log
sequence number 0 51804
Jan 3 20:22:36 zona mysqld[7372]: 060103 20:22:36 [Note] Recovering after a
crash using /var/log/mysql/mysql-bin
Jan 3 20:22:36 zona mysqld[7372]: 060103 20:22:36 [Note] Starting crash
recovery...
Jan 3 20:22:36 zona mysqld[7372]: 060103 20:22:36 [Note] Crash recovery
finished.
Jan 3 20:22:36 zona mysqld[7372]: 060103 20:22:36 [ERROR] Fatal error: Can't
open and lock privilege tables: Can't find file: 'host' (errno: 2)
Jan 3 20:22:36 zona mysqld_safe[7383]: ended
Jan 3 20:22:42 zona /etc/init.d/mysql[7446]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jan 3 20:22:42 zona /etc/init.d/mysql[7446]: ^G/usr/bin/mysqladmin: connect to
server at 'localhost' failed
Jan 3 20:22:42 zona /etc/init.d/mysql[7446]: error: 'Can't connect to local
MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jan 3 20:22:42 zona /etc/init.d/mysql[7446]: Check that mysqld is running and
that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jan 3 20:22:42 zona /etc/init.d/mysql[7446]:
During the upgrade, I had received the following "Install Hints"
warnings, and acted afterwards as described here:
On upgrades from MySQL 3.23, as shipped with Debian Woody, symlinks in
place of /var/lib/mysql or /var/log/mysql gets accidently removed and
have manually be restored.
Probably does not apply -- they're not symlinks and are valid directories:
# ls -lad /var/lib/mysql /var/log/mysql
drwxr-xr-x 5 mysql mysql 1024 Jan 3 22:44 /var/lib/mysql
drwxr-s--- 2 mysql adm 6144 Jan 3 22:44 /var/log/mysql
MySQL will only install if you have a non-numeric hostname that is
resolvable via the /etc/hosts file. E.g. if the "hostname" command returns
"myhostname" then there must be a line like "10.0.0.1 myhostname".
I didn't have such a line in my hosts file, but added one:
# hostname
zona
I tried adding '10.9.8.3 zona' (a valid ip address) and then changed
it to '127.0.0.1 zona', but in both cases mysql start still fails with
the same messages in the syslog. Because the above paragraph says
"MySQL will only install if..." I did 'apt-get install --reinstall
mysql-server-5.0', just to be sure, but it still fails in the same
way. (see "syslog from reinstall" below.)
A new mysql user "debian-sys-maint" will be created. This mysql account is
used in the start/stop and cron scripts. Don't delete.
# grep mysql /etc/passwd
mysql:x:100:104:MySQL Server:/var/lib/mysql:/bin/false
Please remember to set a PASSWORD for the MySQL root user! If you use a
/root/.my.cnf, always write the "user" and the "password" lines in there,
never only the password!
I have no /root/.my.cnf
See /usr/share/doc/mysql-server-5.0/README.Debian for more information.
syslog from reinstall:
Jan 3 23:18:40 zona mysqld_safe[11697]: PLEASE REMEMBER TO SET A PASSWORD FOR
THE MySQL root USER !
Jan 3 23:18:40 zona mysqld_safe[11697]: To do so, start the server, then issue
the following commands:
Jan 3 23:18:40 zona mysqld_safe[11697]: /usr/bin/mysqladmin -u root password
'new-password'
Jan 3 23:18:40 zona mysqld_safe[11697]: /usr/bin/mysqladmin -u root -h zona
password 'new-password'
Jan 3 23:18:40 zona mysqld_safe[11697]: See the manual for more instructions.
Jan 3 23:18:40 zona mysqld_safe[11697]:
Jan 3 23:18:40 zona mysqld_safe[11697]: NOTE: If you are upgrading from a
MySQL <= 3.22.10 you should run
Jan 3 23:18:40 zona mysqld_safe[11697]: the
/usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
Jan 3 23:18:40 zona mysqld_safe[11697]: able to use the new GRANT command!
Jan 3 23:18:40 zona mysqld_safe[11697]:
Jan 3 23:18:40 zona mysqld_safe[11697]: Please report any problems with the
/usr/bin/mysqlbug script!
Jan 3 23:18:40 zona mysqld_safe[11697]:
Jan 3 23:18:40 zona mysqld_safe[11697]: The latest information about MySQL is
available on the web at
Jan 3 23:18:40 zona mysqld_safe[11697]: http://www.mysql.com
Jan 3 23:18:40 zona mysqld_safe[11697]: Support MySQL by buying
support/licenses at https://order.mysql.com
Jan 3 23:18:41 zona mysqld_safe[11838]: started
Jan 3 23:18:42 zona mysqld[11841]: 060103 23:18:42 InnoDB: Started; log
sequence number 0 51804
Jan 3 23:18:42 zona mysqld[11841]: 060103 23:18:42 [ERROR] Fatal error: Can't
open and lock privilege tables: Can't find file: 'host' (errno: 2)
Jan 3 23:18:42 zona mysqld_safe[11861]: ended
Jan 3 23:18:47 zona /etc/init.d/mysql[11915]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jan 3 23:18:47 zona /etc/init.d/mysql[11915]: ^G/usr/bin/mysqladmin: connect
to server at 'localhost' failed
Jan 3 23:18:47 zona /etc/init.d/mysql[11915]: error: 'Can't connect to local
MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jan 3 23:18:47 zona /etc/init.d/mysql[11915]: Check that mysqld is running and
that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jan 3 23:18:47 zona /etc/init.d/mysql[11915]:
I tried a google search on that "Fatal error: Can't open and lock
privilege tables: Can't find file: 'host'" message, and got lots of
hits on "Can't find file: 'mysql.host'" -- is that the same file? --
but only a few on "host," none of which were helpful to me.
The things suggested in README.Debian (change the password? how?
where? what's the "correct" password?), run
mysql_fix_privilege_tables (fails with the same errors as described
above), don't help, or maybe I'm just too clueless to understand what
it wants me to do (particularly the change or set the password
instructions) -- does that even apply to the 4.1 - 5.0 upgrade?
(Most of the README.Debian seems to be talking about the 4.1 release,
not the 5.0 release; e.g. it warns against downgrading to 4.0. Can I
downgrade to 4.1? I didn't try, but will if you think I should.)
Please let me know what I should do or try, or what else you want to
know; I apologize for being so mysql-ignorant, but I'm sure I'm not
the only one ;)
Thanks.
-- System Information:
Debian Release: testing/unstable
APT prefers unstable
APT policy: (500, 'unstable'), (400, 'testing'), (300, 'stable')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.14zona-06033se
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Versions of packages mysql-server-5.0 depends on:
ii adduser 3.80 Add and remove users and groups
ii debconf [debconf-2.0] 1.4.67 Debian configuration management sy
ii libc6 2.3.5-11 GNU C Library: Shared libraries an
ii libdbi-perl 1.48-2 Perl5 database interface by Tim Bu
ii libgcc1 1:4.0.2-5 GCC support library
ii libmysqlclient15 5.0.18-1 mysql database client library
ii libncurses5 5.5-1 Shared libraries for terminal hand
ii libreadline5 5.1-5 GNU readline and history libraries
ii libstdc++6 4.0.2-5 The GNU Standard C++ Library v3
ii libwrap0 7.6.dbs-8 Wietse Venema's TCP wrappers libra
ii mailutils [mailx] 1:0.6.90-3 GNU mailutils utilities for handli
ii mysql-client-5.0 5.0.18-1 mysql database client binaries
ii mysql-common 5.0.18-1 mysql database common files (e.g.
ii passwd 1:4.0.13-7 change and administer password and
ii perl 5.8.7-10 Larry Wall's Practical Extraction
ii psmisc 21.8-1 Utilities that use the proc filesy
ii zlib1g 1:1.2.3-9 compression library - runtime
mysql-server-5.0 recommends no packages.
-- debconf information:
mysql-server-5.0/really_downgrade: false
mysql-server-5.0/start_on_boot: true
mysql-server-5.0/nis_warning:
mysql-server-5.0/postrm_remove_databases: false
* mysql-server-5.0/mysql_install_db_notes:
mysql-server-5.0/mysql_update_hints1:
---------------------------------------
Received: (at 345895-close) by bugs.debian.org; 17 Jan 2006 22:45:25 +0000
>From [EMAIL PROTECTED] Tue Jan 17 14:45:25 2006
Return-path: <[EMAIL PROTECTED]>
Received: from katie by spohr.debian.org with local (Exim 4.50)
id 1EyzPm-0003vL-Jp; Tue, 17 Jan 2006 14:34:58 -0800
From: Christian Hammers <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
X-Katie: $Revision: 1.65 $
Subject: Bug#345895: fixed in mysql-dfsg-5.0 5.0.18-6
Message-Id: <[EMAIL PROTECTED]>
Sender: Archive Administrator <[EMAIL PROTECTED]>
Date: Tue, 17 Jan 2006 14:34:58 -0800
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Level:
X-Spam-Status: No, hits=-6.0 required=4.0 tests=BAYES_00,HAS_BUG_NUMBER
autolearn=no version=2.60-bugs.debian.org_2005_01_02
Source: mysql-dfsg-5.0
Source-Version: 5.0.18-6
We believe that the bug you reported is fixed in the latest version of
mysql-dfsg-5.0, which is due to be installed in the Debian FTP archive:
libmysqlclient15-dev_5.0.18-6_i386.deb
to pool/main/m/mysql-dfsg-5.0/libmysqlclient15-dev_5.0.18-6_i386.deb
libmysqlclient15_5.0.18-6_i386.deb
to pool/main/m/mysql-dfsg-5.0/libmysqlclient15_5.0.18-6_i386.deb
mysql-client-5.0_5.0.18-6_i386.deb
to pool/main/m/mysql-dfsg-5.0/mysql-client-5.0_5.0.18-6_i386.deb
mysql-client_5.0.18-6_all.deb
to pool/main/m/mysql-dfsg-5.0/mysql-client_5.0.18-6_all.deb
mysql-common_5.0.18-6_all.deb
to pool/main/m/mysql-dfsg-5.0/mysql-common_5.0.18-6_all.deb
mysql-dfsg-5.0_5.0.18-6.diff.gz
to pool/main/m/mysql-dfsg-5.0/mysql-dfsg-5.0_5.0.18-6.diff.gz
mysql-dfsg-5.0_5.0.18-6.dsc
to pool/main/m/mysql-dfsg-5.0/mysql-dfsg-5.0_5.0.18-6.dsc
mysql-server-5.0_5.0.18-6_i386.deb
to pool/main/m/mysql-dfsg-5.0/mysql-server-5.0_5.0.18-6_i386.deb
mysql-server_5.0.18-6_all.deb
to pool/main/m/mysql-dfsg-5.0/mysql-server_5.0.18-6_all.deb
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.
Christian Hammers <[EMAIL PROTECTED]> (supplier of updated mysql-dfsg-5.0
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: SHA1
Format: 1.7
Date: Tue, 17 Jan 2006 19:25:59 +0100
Source: mysql-dfsg-5.0
Binary: libmysqlclient15-dev libmysqlclient15 mysql-client mysql-client-5.0
mysql-server mysql-server-5.0 mysql-common
Architecture: source all i386
Version: 5.0.18-6
Distribution: unstable
Urgency: low
Maintainer: Christian Hammers <[EMAIL PROTECTED]>
Changed-By: Christian Hammers <[EMAIL PROTECTED]>
Description:
libmysqlclient15 - mysql database client library
libmysqlclient15-dev - mysql database development files
mysql-client - mysql database client (current version)
mysql-client-5.0 - mysql database client binaries
mysql-common - mysql database common files (e.g. /etc/mysql/my.cnf)
mysql-server - mysql database server (current version)
mysql-server-5.0 - mysql database server binaries
Closes: 345895 348182
Changes:
mysql-dfsg-5.0 (5.0.18-6) unstable; urgency=low
.
* Added version comment (thanks to Daniel van Eeden).
* Added two patches to build on GNU/Hurd (thanks to Michael Bank).
Closes: #348182
* Abort upgrade if old and now unsupported ISAM tables are present
(thanks to David Coe). Closes: #345895
Files:
7b1209622b47937261b5c7e700a1d814 1088 misc optional mysql-dfsg-5.0_5.0.18-6.dsc
08c65bc2ecb9f3d54449b965d5c7c0a7 116888 misc optional
mysql-dfsg-5.0_5.0.18-6.diff.gz
5cd2d7f57ee461326ccc456942a5e68c 38742 misc optional
mysql-common_5.0.18-6_all.deb
8c7913b01289fd05d9096c60a0966302 36302 misc optional
mysql-server_5.0.18-6_all.deb
7bfa786093bde64217a131a3d2d0e83a 36296 misc optional
mysql-client_5.0.18-6_all.deb
8d98217819ee31f262e2b8b9d9fe7408 1359374 libs optional
libmysqlclient15_5.0.18-6_i386.deb
398e6af95915cdd207a837849bb17e2f 5959826 libdevel optional
libmysqlclient15-dev_5.0.18-6_i386.deb
f1212a78e2528a2c371acb313472e1b0 6467004 misc optional
mysql-client-5.0_5.0.18-6_i386.deb
32e6b3edf747df2984483115a0a873f2 14807452 misc optional
mysql-server-5.0_5.0.18-6_i386.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
iEYEARECAAYFAkPNZBIACgkQkR9K5oahGOYiUgCg1Ek5dNaQmEapl8ZNG4ZtFrLy
ABgAnRMEfOyRzbrzneFah8VsDsSIEqzV
=Hx1U
-----END PGP SIGNATURE-----
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
