package mysql-server-5.1 5.1.37-1ubuntu5 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1

Do you still encounter this error while trying to install mysql-server ?

no.
not anymore

Regards,
Amit Gore

> Date: Wed, 20 Jan 2010 16:38:54 +0000
> From: <email address hidden>
> To: <email address hidden>
> Subject: [Bug 509736] Re: package mysql-server-5.1 5.1.37-1ubuntu5 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1
>
> Do you still encounter this error while trying to install mysql-server ?
>
> ** Changed in: mysql-dfsg-5.1 (Ubuntu)
> Importance: Undecided => Low
>
> ** Changed in: mysql-dfsg-5.1 (Ubuntu)
> Status: New => Incomplete
>
> --
> package mysql-server-5.1 5.1.37-1ubuntu5 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1
> https://bugs.launchpad.net/bugs/509736
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in “mysql-dfsg-5.1” package in Ubuntu: Incomplete
>
> Bug description:
> just while installing some packages i got this crash.
>
> ProblemType: Package
> Architecture: amd64
> Date: Tue Jan 19 22:22:56 2010
> DistroRelease: Ubuntu 9.10
> ErrorMessage: subprocess new pre-installation script returned error exit status 1
> InstallationMedia: Ubuntu 9.10 "Karmic Koala" - Release amd64 (20091027)
> MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
> [mysqld_safe]
> syslog
> MySQLVarLibDirListing: ['debian-5.1.flag', 'mysql', 'mysql_upgrade_info', 'ib_logfile1', 'ib_logfile0', 'ibdata1']
> Package: mysql-server-5.1 5.1.37-1ubuntu5
> ProcVersionSignature: Ubuntu 2.6.31-17.54-generic
> SourcePackage: mysql-dfsg-5.1
> Title: package mysql-server-5.1 5.1.37-1ubuntu5 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1
> Uname: Linux 2.6.31-17-generic x86_64
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.1/+bug/509736/+subscribe

_________________________________________________________________
Windows 7: Simplify what you do everyday. Find the right PC for you.
http://windows.microsoft.com/shop

mysql-server was already installed when I encountered this problem.

The problem was the mysql server wouldn't stop. I killed all mysqld processed and then tried again; it worked.

AFAIK and Understand the installation or upgrade script must first check for the running instance of the program, prompt for closing it or close/kill it forcibly. I used to write RPM scripts and hope that must have been done in .deb too. The issue was last time when the upgrade went ok and my MySQL tables were corrupted and I could not login to MySQL server, all my apps stopped working. Some how I managed to re install MySQL but that didnt help either and at then end some one in IRC suggested me to run "mysql_upgrade" script and restart MySQL. It helped and I did loose my data in all this.

I got the same error... just tried to manually run '/etc/init.d/mysql stop' and it fails.

killing mysql processes before the upgrade worked for me too

This bug may also be related to: Bug #501655

Tried stopping the mysql service, it was stopped, but didn't solve the problem.

I cannot stop the server by hand either. I found out the script must run

/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf shutdown

...and when I sudo this by hand, I get:

/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'

So, there must be a mismatch between the password in debian.cnf and the password actually in use for debian-sys-maint.

I ran the following SQL-statement under the MySQL-root user:

UPDATE mysql.user SET Password=PASSWORD([The password found in /etc/mysql/debian.cnf]) WHERE User="debian-sys-maint";

And after I flushed the privileges, the update of 5.1 was successful.

Marking as invalid since the original bug reporter doesn't have the problem anymore.