OK, it looks like this user needs to be in MySQL's user table. b...@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 ba...@apollo:/etc/mysql$ sudo /etc/init.d/mysql stop * Stopping MySQL database server mysqld [ OK ] ba...@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 Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
