mysql fails to install

[bettlebrox]

Mysql fails to install. This is on a system that was upgraded to jaunty, and previously had mysql installed. I renamed the previously existing /etc/mysql and /var/lib/mysql which had no affect. Purging the various mysql packages failed to resolve this issue also.

ProblemType: Package
Architecture: i386
DistroRelease: Ubuntu 9.04
ErrorMessage: subprocess post-installation script returned error exit status 1
Package: mysql-server-5.0 5.1.30really5.0.75-0ubuntu10.1
SourcePackage: mysql-dfsg-5.0
Title: package mysql-server-5.0 5.1.30really5.0.75-0ubuntu10.1 failed to install/upgrade: subprocess post-installation script returned error exit status 1
Uname: Linux 2.6.28-11-generic i686

[bettlebrox (micktimony)]

Basically this fails to install or upgrade with the following error messages:

090506 0:32:37 [Warning] Can't create test file /var/lib/mysql/micks-t400.lower-test

090506 0:32:37 [Warning] Can't create test file /var/lib/mysql/micks-t400.lower-test

090506 0:32:37 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/user.frm' (errno: 13)

090506 0:32:37 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/user.frm' (errno: 13)

ERROR: 1017 Can't find file: './mysql/user.frm' (errno: 13)

090506 0:32:37 [ERROR] Aborting

The permissions on /var/lib/mysql are:

drwxr-xr-x 3 mysql mysql 4.0K 2009-05-06 00:59 /var/lib/mysql/

I'm not sure where it's trying to create the user.frm file.

[Mathias Gug (mathiaz)]

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

Could you please provide the following information:

 * content of /var/log/daemon.log related to mysql processes:

    /var/log/daemon.log

 * apparmor audit messages related to mysqld:

    /var/log/kern.log

 * mysql configuration stripped of private information (such as password):

    /etc/mysql/my.cnf

 * extra mysql configuration from the conf.d directory:

    /etc/mysql/conf.d/

[bettlebrox (micktimony)]

Problem solved!

I'd moved /var/lib to /home/var/lib (to save space) and made /var/lib a
symbolic link to that directory. This must have caused a problem with
apparmor, as per the line below:

Jun 15 19:19:02 micks-t400 kernel: [29451.814871] type=1503
audit(1245107942.002:30): operation="inode_create" requested_mask="a::"
denied_mask="a::" fsuid=0 name="/home/var/lib/mysql/micks-t400.lower-test"
pid=1895 profile="/usr/sbin/mysqld"

Copying /home/var/lib back to /var/lib (after removing the symbolic link)
fixed the problem, and mysql installed successfully.

On Mon, Jun 15, 2009 at 6:29 PM, Mathias Gug <email address hidden> wrote:

> Thank you for taking the time to report this bug and helping to make
> Ubuntu better.
>
> Could you please provide the following information:
>
> * content of /var/log/daemon.log related to mysql processes:
>
> /var/log/daemon.log
>
> * apparmor audit messages related to mysqld:
>
> /var/log/kern.log
>
> * mysql configuration stripped of private information (such as
> password):
>
> /etc/mysql/my.cnf
>
> * extra mysql configuration from the conf.d directory:
>
> /etc/mysql/conf.d/
>
> ** Changed in: mysql-dfsg-5.0 (Ubuntu)
> Status: New => Incomplete
>
> --
> mysql fails to install
> https://bugs.launchpad.net/bugs/373513
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in “mysql-dfsg-5.0” source package in Ubuntu: Incomplete
>
> Bug description:
> Mysql fails to install. This is on a system that was upgraded to jaunty,
> and previously had mysql installed. I renamed the previously existing
> /etc/mysql and /var/lib/mysql which had no affect. Purging the various mysql
> packages failed to resolve this issue also.
>
> ProblemType: Package
> Architecture: i386
> DistroRelease: Ubuntu 9.04
> ErrorMessage: subprocess post-installation script returned error exit
> status 1
> Package: mysql-server-5.0 5.1.30really5.0.75-0ubuntu10.1
> SourcePackage: mysql-dfsg-5.0
> Title: package mysql-server-5.0 5.1.30really5.0.75-0ubuntu10.1 failed to
> install/upgrade: subprocess post-installation script returned error exit
> status 1
> Uname: Linux 2.6.28-11-generic i686
>

[Mathias Gug (mathiaz)]

On Tue, Jun 16, 2009 at 12:13:33AM -0000, bettlebrox wrote:
> Problem solved!

  status invalid

--
Mathias Gug
Ubuntu Developer http://www.ubuntu.com