[Bug 382785] Re: package mysql-server-5.0 5.1.30really5.0.75-0ubuntu10 failed to install/upgrade: subprocess new pre-removal script returned error exit status 1

[jakyra]

I tried that and when I did the upgrade I got this: 
:~$ sudo apt-get upgrade -y
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following packages will be upgraded:
  mysql-server-5.0
1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
14 not fully installed or removed.
Need to get 0B/23.6MB of archives.
After this operation, 0B of additional disk space will be used.
Preconfiguring packages ...
(Reading database ... 122045 files and directories currently installed.)
Preparing to replace mysql-server-5.0 5.1.30really5.0.75-0ubuntu10 (using .../mysql-server-5.0_5.1.30really5.0.75-0ubuntu10.2_i386.deb) ...
 * Stopping MySQL database server mysqld                                                   [fail] 
invoke-rc.d: initscript mysql, action "stop" failed.
dpkg: warning - old pre-removal script returned error exit status 1
dpkg - trying script from the new package instead ...
 * Stopping MySQL database server mysqld                                                   [fail] 
invoke-rc.d: initscript mysql, action "stop" failed.
dpkg: error processing /var/cache/apt/archives/mysql-server-5.0_5.1.30really5.0.75-0ubuntu10.2_i386.deb (--unpack):
 subprocess new pre-removal script returned error exit status 1
 * Stopping MySQL database server mysqld                                                   [fail] 
invoke-rc.d: initscript mysql, action "stop" failed.
 * Starting MySQL database server mysqld                                                   [ OK ] 
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
Errors were encountered while processing:
 /var/cache/apt/archives/mysql-server-5.0_5.1.30really5.0.75-0ubuntu10.2_i386.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
joelle at w200951416:~$ sudo /etc/init.d/mysql start
 * Starting MySQL database server mysqld                                                   [ OK ] 
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'


I did some searching and found this thread http://ubuntuforums.org/archive/index.php/t-112505.html
So I went to /etc/mysql/debian.cnf to get the password. Then I updated the password using
UPDATE user SET password=PASSWORD('***password from file goes here****') WHERE user='debian-sys-maint';
 FLUSH PRIVILEGES;

Then I ran the update and it went fine. even without it being disabled.
Since I didn't do them independently I don't know if it was the password
that was the problem all along or if shutting the mysql server was
necessary. The server was not off when I ran the second upgrade.

Hope this helps.

-- 
package mysql-server-5.0 5.1.30really5.0.75-0ubuntu10 failed to install/upgrade: subprocess new pre-removal script returned error exit status 1
https://bugs.launchpad.net/bugs/382785
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.