[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 at lifeintegrity.com
Tue Jan 8 16:46:57 UTC 2008
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.
> 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
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
And the first sign of problem is here:
Jan 8 10:06:12 input at vent /etc/mysql/debian-start: Upgrading
MySQL tables if necessary.
Jan 8 10:06:12 input at vent /etc/mysql/debian-start: ERROR 1045
(28000): Access denied for user 'debian-sys-maint'@'localhost' (using
Jan 8 10:06:12 input at vent /etc/mysql/debian-start: Error
--no-auto-rehash --batch --user=debian-sys-maint mysql <
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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 189 bytes
Desc: Digital signature
Url : http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20080108/d815297e/attachment-0001.pgp
More information about the pkg-mysql-maint