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

[Steve Riddett]

Sorry if this is a dupe. I really can't tell if it is or not.

This report was semi-automatically generated.

ProblemType: Package
Architecture: i386
DistroRelease: Ubuntu 9.04
ErrorMessage: subprocess new pre-removal script returned error exit status 1
NonfreeKernelModules: nvidia
Package: mysql-server-5.0 5.1.30really5.0.75-0ubuntu10
SourcePackage: mysql-dfsg-5.0
Title: 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
Uname: Linux 2.6.28-11-generic i686

[Mathias Gug (mathiaz)]

Relevant error message:

Preparing to replace mysql-server 5.1.30really5.0.75-0ubuntu10 (using .../mysql-server_5.1.30really5.0.75-0ubuntu10.2_all.deb) ...
 * Stopping MySQL database server mysqld
   ...fail!
invoke-rc.d: initscript mysql, action "stop" failed.

Could you post the content of /var/log/daemon.log around the time of the upgrade to identify why mysqld failed to be stopped?

[Steve Riddett (tmb-steve)]

This looks relevant: Let me know if you need more.

Jun 5 15:59:09 steve-blackubu904 /etc/mysql/debian-start[2479]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Jun 5 15:59:09 steve-blackubu904 /etc/mysql/debian-start[2479]: Running 'mysqlcheck'...
Jun 5 15:59:09 steve-blackubu904 /etc/mysql/debian-start[2479]: /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) when trying to connect
Jun 5 15:59:09 steve-blackubu904 /etc/mysql/debian-start[2479]: FATAL ERROR: Upgrade failed
Jun 5 15:59:09 steve-blackubu904 /etc/mysql/debian-start[2496]: Checking for insecure root accounts.

[Mathias Gug (mathiaz)]

Relevant error message:

Jun 5 15:59:09 steve-blackubu904 /etc/mysql/debian-start[2479]: /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) when trying to connect

The debian-sys-maint user is required by the init script.

[Steve Riddett (tmb-steve)]

That's great - thanks for your help.