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

[John Lyon]

I changed my socket setting for mysql to /var/lib/mysqld/mysqld.sock, and now automatic updates to mysql do not seem to function. I believe that the socket was set to /usr/bin originally, and I tried to change the location in order to install mysql, but the installation was unsuccessful. Well, I am learning more everyday....

ProblemType: Package
Architecture: i386
Date: Sat Sep 4 00:23:30 2010
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: ['ib_logfile1', 'mysql', 'ibdata1', 'debian-5.1.flag', 'mysql_upgrade_info', 'test', 'ib_logfile0']
NonfreeKernelModules: wl
Package: mysql-server-5.1 5.1.37-1ubuntu5.4
ProcVersionSignature: Ubuntu 2.6.31-22.64-generic
SourcePackage: mysql-dfsg-5.1
Title: package mysql-server-5.1 5.1.37-1ubuntu5.4 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1
Uname: Linux 2.6.31-22-generic i686

[Mathias Gug (mathiaz)]

Thank you for taking the time to report this bug and helping to make Ubuntu better. It seems that you're using a non-standard location for your socket. However mysqld apparmor profile (in /etc/apparmor.d/usr.sbin.mysqld) hasn't been updated to allow access to the custom directory.

See https://wiki.ubuntu.com/DebuggingApparmor#Debugging%20procedure for more information on how to update mysqld apparmor profile.