package mysql-server-5.1 5.1.37-1ubuntu5.5 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1

[id628]

Upgrade failed. Even uninstall and reinstall of mysql-server package fails with the same error.

I have no way of running mysql-server on this machine.

ProblemType: Package
AptOrdering:
 libtiff4: Install
 mysql-server-5.1: Configure
 mysql-server: Configure
 libtiff4: Configure
Architecture: i386
Date: Tue Mar 15 07:41:02 2011
DistroRelease: Ubuntu 9.10
ErrorMessage: subprocess installed post-installation script returned error exit status 1
MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
 [mysqld_safe]
 syslog
MySQLVarLibDirListing: ['ibdata1', 'ubuntu.err', 'ib_logfile1', 'mysql', 'ib_logfile0', 'debian-5.1.flag']
Package: mysql-server-5.1 5.1.37-1ubuntu5.5
ProcVersionSignature: Ubuntu 2.6.31-22.73-generic-pae
SourcePackage: mysql-dfsg-5.1
Title: package mysql-server-5.1 5.1.37-1ubuntu5.5 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1
Uname: Linux 2.6.31-22-generic-pae i686

[James Page (james-page)]

Error from log:

Setting up mysql-server-5.1 (5.1.37-1ubuntu5.5) ...
 * Stopping MySQL database server mysqld 
[ OK ]
 * /etc/init.d/mysql: WARNING: /etc/mysql/my.cnf cannot be read. See README.Debian.gz
 * Starting MySQL database server mysqld 
[fail]
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.1 (--configure):
 subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.1; however:
  Package mysql-server-5.1 is not configured yet.
dpkg: error processing mysql-server (--configure):
 dependency problems - leaving unconfigured

[James Page (james-page)]

Looking at the kernel log it would appear that apparmor is blocking access to /etc/mysql/my.cnf. However looking at the profile not sure why this is as /etc/mysql/my.cnf has read permission.

[James Page (james-page)]

Thank you for taking the time to report this bug and helping to make Ubuntu better.

It looks like you have tried a number of things to resolve this problem; however I think that the original cause of the issue may have been that the InnoDB file locations in /etc/mysql/my.cnf where outside of the apparmor profile and hence rw access to them was denied.

If possible I think that its worth trying to purge the packages and re-install using the following commands:

  sudo apt-get purge mysql-server-5.1
  sudo apt-get install mysql-server-5.1

This should ensure that you have an up-to-date base apparmor configuration. /etc/mysql/my.cnf is installed by mysql-common so this should leave your configuration intact - however this does mean that mysql will fail to start during the setup phase of the install.

You will then need to update the apparmor profile in /etc/apparmor.d/usr.sbin.mysql to include rw access to this location; I think you will be able to complete the installation by running the following command:

  sudo dpkg-reconfigure mysql-server-5.1

Please update this bug report if this resolves your issue.

[Launchpad Janitor (janitor)]

[Expired for mysql-dfsg-5.1 (Ubuntu) because there has been no activity for 60 days.]