mysql failed to configure while upgrading to 10.04

[TJ Kolev]

I was upgrading from 9.10 to 10.04 LTS via console. Mysql server failed to be configured because at one point I was asked to use an account called debian-sys-maint, which I don't remember seeing ever. I tried it by entering the password found in /etc/mysql/debian.cnf with no luck. I also tried using root - no luck. Further into the upgrade, I was offered to submit a report, and follow an url to here.

tjk :)

ProblemType: Package
DistroRelease: Ubuntu 10.04
Package: mysql-server-5.1 5.1.41-3ubuntu12.6
ProcVersionSignature: Ubuntu 2.6.31-22.65-server
Uname: Linux 2.6.31-22-server x86_64
NonfreeKernelModules: nvidia
Architecture: amd64
Date: Sat Oct 9 10:04:32 2010
ErrorMessage:
 ErrorMessage: subprocess installed post-installation script returned error exit status 1
Logs.var.log.kern.log:
 Oct 9 09:08:20 karma kernel: [59213.435050] type=1503 audit(1286633300.173:25): operation="open" pid=22252 parent=22251 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
 Oct 9 09:08:24 karma kernel: [59217.499056] type=1503 audit(1286633304.233:26): operation="open" pid=22269 parent=22268 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
 Oct 9 09:08:24 karma kernel: [59218.055767] type=1503 audit(1286633304.793:27): operation="open" pid=22320 parent=22319 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
 Oct 9 09:08:24 karma kernel: [59218.072306] type=1503 audit(1286633304.813:28): operation="open" pid=22329 parent=22328 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
 [mysqld_safe]
 syslog
MySQLConf.etc.mysql.conf.d.mythtv.cnf:
 [mysqld]
 bind-address=0.0.0.0
MySQLVarLibDirListing: False
SourcePackage: mysql-dfsg-5.1
Title: package mysql-server-5.1 5.1.41-3ubuntu12.6 failed to install/upgrade:
mtime.conffile..etc.apparmor.d.usr.sbin.mysqld: 2010-02-20T17:04:26.988584

[Dave Walker (davewalker)]

Adding a task against mythbuntu, it may be invalid - but i felt it was worth raising attention to this.

[Mathias Gug (mathiaz)]

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

According to the log file:

Installing new version of config file /etc/logrotate.d/mysql-server ...

mkdir: cannot create directory `/var/lib/mysql/mysql': No such file or directory

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.

Does /var/lib/mysql/ exist?

[TJ Kolev (tjkolev)]

I think I have found the problem with my installation. /var/lib/mysql is a link to a location on an iscsi target. I am fairly certain the iscsi targets were not connected, because eth1, my iscsi interface wasn't brought up. eth1 didn't come up when I rebooted after the upgrade, Now eth1 and iscsi are fine, and I updated mysql successfully.

I'd consider this a non-issue at this point.

Thank you.
tjk :)

[C de-Avillez (hggdh2)]

Thank you for your feedback. As such, I am closing this bug. Please do report any new issues you find.

[C de-Avillez (hggdh2)]

Closing the mythubuntu task as well.