[debian-mysql] Bug#459764: Bug#459764: mysql-server: mysqld fails to stop and start after upgrade (5.0.32-7etch3 -> 5.0.32-7etch4)

[Allan Wind]

On 2008-01-08T17:33:26+0100, Norbert Tretkowski wrote:
> Am Dienstag, den 08.01.2008, 10:50 -0500 schrieb Allan Wind:
> > I tried to connect to mysql using the information in 
> > /etc/mysql/debian.cnf and it did not work.
> 
> That's the problem. Did you modify the password of the debian-sys-maint
> user or the file /etc/mysql/debian.cnf in the past?

No, although I did have a password commented out in /etc/mysql/my.cnf:

...
#password = ...
password = ...
...

and neither of them worked.

> Starting mysqld manually and setting a new password for the mentioned
> user (which you have to set in /etc/mysql/debian.cnf as well) should fix
> this problem.

It did.

> I'm quite sure it's not related to the security update, something else
> much have gone wrong on your system.

The log provided shows the server starting up and shutting down just 
fine prior to the upgrade.  Here's the aptitude log with the timestamp 
of the upgrade:

Tue, Jan  8 2008 10:05:43 -0500

IMPORTANT: this log only lists intended actions; actions which fail due 
to
dpkg problems may not be completed.

Will install 6 packages, and remove 0 packages.
4096B of disk space will be used
===============================================================================
[UPGRADE] libfreetype6 2.2.1-5+etch1 -> 2.2.1-5+etch2
[UPGRADE] libmysqlclient15off 5.0.32-7etch3 -> 5.0.32-7etch4
[UPGRADE] mysql-client-5.0 5.0.32-7etch3 -> 5.0.32-7etch4
[UPGRADE] mysql-common 5.0.32-7etch3 -> 5.0.32-7etch4
[UPGRADE] mysql-server 5.0.32-7etch3 -> 5.0.32-7etch4
[UPGRADE] mysql-server-5.0 5.0.32-7etch3 -> 5.0.32-7etch4
===============================================================================

Log complete.

And the first sign of problem is here:

Jan  8 10:06:12 input at vent /etc/mysql/debian-start[3560]: Upgrading 
MySQL tables if necessary.
Jan  8 10:06:12 input at vent /etc/mysql/debian-start[3565]: ERROR 1045 
(28000): Access denied for user 'debian-sys-maint'@'localhost' (using 
password: YES)
Jan  8 10:06:12 input at vent /etc/mysql/debian-start[3565]: Error 
executing '/usr/bin/mysql 
--defaults-extra-file=/var/lib/mysql/mysql_upgrade_defaults --force 
--no-auto-rehash --batch --user=debian-sys-maint mysql < 
/usr/share/mysql/mysql_fix_privilege_tables.sql'

This was not a production machine, so the only loss was the time to 
troubleshoot and share this knowledge.  Others may have more important 
stuff in mysql.


/Allan
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20080108/d815297e/attachment-0001.pgp