[Bug 501655] Re: package mysql-server-5.1 5.1.37-1ubuntu5 failed to install/upgrade: subprocess installed pre-removal script returned error exit status 1

[brian]

OK, it looks like this user needs to be in MySQL's user table.

bip at apollo:/etc/mysql$ sudo cat debian.cnf
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host     = localhost
user     = debian-sys-maint
password = XXXXXXXXXX
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host     = localhost
user     = debian-sys-maint
password = XXXXXXXXXX
socket   = /var/run/mysqld/mysqld.sock
basedir  = /usr


I logged in using mysql mysql -uroot -p

mysql> GRANT ALL ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'XXXXXXXXXX';
Query OK, 0 rows affected (0.00 sec)

mysql>FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> \q
Bye
bally at apollo:/etc/mysql$ sudo /etc/init.d/mysql stop
 * Stopping MySQL database server mysqld                     [ OK ] 

bally at apollo:/etc/mysql$ sudo /etc/init.d/mysql start
 * Starting MySQL database server mysqld                     [ OK ] 
 * Checking for corrupt, not cleanly closed and upgrade needing tables.


I then ran Update Manager. This is from /var/log/dpkg.log (I can't figure out where the terminal output from Udate Manager is logged but it explicitly showed the DB being properly shut down):

-- snip --
2010-02-11 15:49:49 startup archives unpack
2010-02-11 15:49:50 upgrade mysql-server-5.1 5.1.37-1ubuntu5 5.1.37-1ubuntu5.1
2010-02-11 15:49:50 status half-configured mysql-server-5.1 5.1.37-1ubuntu5
2010-02-11 15:49:52 status unpacked mysql-server-5.1 5.1.37-1ubuntu5
2010-02-11 15:49:52 status half-installed mysql-server-5.1 5.1.37-1ubuntu5
2010-02-11 15:49:53 status triggers-pending ureadahead 0.90.3-2
2010-02-11 15:49:53 status half-installed mysql-server-5.1 5.1.37-1ubuntu5
2010-02-11 15:49:54 status triggers-pending man-db 2.5.6-2
2010-02-11 15:49:54 status half-installed mysql-server-5.1 5.1.37-1ubuntu5
2010-02-11 15:49:54 status half-installed mysql-server-5.1 5.1.37-1ubuntu5
2010-02-11 15:49:55 status unpacked mysql-server-5.1 5.1.37-1ubuntu5.1
2010-02-11 15:49:55 status unpacked mysql-server-5.1 5.1.37-1ubuntu5.1
2010-02-11 15:49:55 trigproc ureadahead 0.90.3-2 0.90.3-2
2010-02-11 15:49:55 status half-configured ureadahead 0.90.3-2
2010-02-11 15:49:55 status installed ureadahead 0.90.3-2
2010-02-11 15:49:55 trigproc man-db 2.5.6-2 2.5.6-2
2010-02-11 15:49:55 status half-configured man-db 2.5.6-2
2010-02-11 15:49:56 status installed man-db 2.5.6-2
2010-02-11 15:49:57 startup packages configure
2010-02-11 15:49:57 configure mysql-server-5.1 5.1.37-1ubuntu5.1 5.1.37-1ubuntu5.1
2010-02-11 15:49:57 status unpacked mysql-server-5.1 5.1.37-1ubuntu5.1
2010-02-11 15:49:57 status unpacked mysql-server-5.1 5.1.37-1ubuntu5.1
2010-02-11 15:49:57 status unpacked mysql-server-5.1 5.1.37-1ubuntu5.1
2010-02-11 15:49:57 status unpacked mysql-server-5.1 5.1.37-1ubuntu5.1
2010-02-11 15:49:57 status unpacked mysql-server-5.1 5.1.37-1ubuntu5.1
2010-02-11 15:49:57 status unpacked mysql-server-5.1 5.1.37-1ubuntu5.1
2010-02-11 15:49:57 status unpacked mysql-server-5.1 5.1.37-1ubuntu5.1
2010-02-11 15:49:57 status unpacked mysql-server-5.1 5.1.37-1ubuntu5.1
2010-02-11 15:49:57 status unpacked mysql-server-5.1 5.1.37-1ubuntu5.1
2010-02-11 15:49:57 status half-configured mysql-server-5.1 5.1.37-1ubuntu5.1
2010-02-11 15:50:07 status installed mysql-server-5.1 5.1.37-1ubuntu5.1
-- snip --

The upshot of it is that debian-sys-maint was missing from the
mysql.user table.

Odd OT aside: the 1st line of debian.cnf says this:
# Automatically generated for Debian scripts. DO NOT TOUCH!

But /etc/mysql/my.cnf says:
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.

Whatever.

-- 
package mysql-server-5.1 5.1.37-1ubuntu5 failed to install/upgrade: subprocess installed pre-removal script returned error exit status 1
https://bugs.launchpad.net/bugs/501655
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu.