package mysql-server-5.5 5.5.58-0ubuntu0.14.04.1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1

[ilanchezhian]

unable to install mysql

ProblemType: Package
DistroRelease: Ubuntu 14.04
Package: mysql-server-5.5 5.5.58-0ubuntu0.14.04.1
ProcVersionSignature: Ubuntu 4.4.0-81.104~14.04.1-generic 4.4.67
Uname: Linux 4.4.0-81-generic x86_64
ApportVersion: 2.14.1-0ubuntu3.24
Architecture: amd64
Date: Fri Nov 24 13:16:14 2017
ErrorMessage: subprocess installed post-installation script returned error exit status 1
InstallationDate: Installed on 2017-06-21 (156 days ago)
InstallationMedia: Ubuntu 14.04.3 LTS "Trusty Tahr" - Beta amd64 (20150805)
Logs.var.log.daemon.log:

MySQLConf.etc.mysql.conf.d..keepme:
MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
 [mysqld_safe]
 syslog
MySQLVarLibDirListing: ['debian-5.5.flag', 'mysql']
ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-4.4.0-81-generic.efi.signed root=UUID=8ccfd8a8-fce3-42db-8b8d-1116bab1139b ro quiet splash vt.handoff=7
RelatedPackageVersions:
 dpkg 1.17.5ubuntu5.7
 apt 1.0.1ubuntu2.17
SourcePackage: mysql-5.5
SystemImageInfo: Error: [Errno 2] No such file or directory: 'system-image-cli'
Title: package mysql-server-5.5 5.5.58-0ubuntu0.14.04.1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1
UpgradeStatus: No upgrade log present (probably fresh install)
modified.conffile..etc.apparmor.d.usr.sbin.mysqld: [modified]
mtime.conffile..etc.apparmor.d.usr.sbin.mysqld: 2017-09-12T19:56:14.536651

[Seth Arnold (seth-arnold)]

Thanks for taking the time to report this bug and helping to make Ubuntu better. We appreciate the difficulties you are facing, but this appears to be a "regular" (non-security) bug. I have unmarked it as a security issue since this bug does not show evidence of allowing attackers to cross privilege boundaries nor directly cause loss of data/privacy. Please feel free to report any other bugs you may find.

[Seth Arnold (seth-arnold)]

This may be related; I can't recall seeing DENIED messages like this one before. Is this a new requirement in this version of mysql?

[275382.851642] audit: type=1400 audit(1511509566.699:41): apparmor="DENIED" operation="mknod" profile="/usr/sbin/mysqld" name="/var/lib/mysql/admin-3046.lower-test" pid=8405 comm="mysqld" requested_mask="c" denied_mask="c" fsuid=0 ouid=0

Thanks

[Andreas Hasenack (ahasenack)]

You seem to have had some other version of mysql installed:
Setting up mysql-community-server (5.6.38-1ubuntu14.04) ...
./usr/bin/mysqld_safe: 637: /usr/bin/mysqld_safe: cannot create /usr/data/admin-3046.err: Directory nonexistent
Logging to '/usr/data/admin-3046.err'.

What is this community server? Version 5.6.38 is not available for trusty in the ubuntu archive:
$ rmadison mysql-server-core-5.5
 mysql-server-core-5.5 | 5.5.22-0ubuntu1 | precise | amd64, armel, armhf, i386, powerpc
 mysql-server-core-5.5 | 5.5.35+dfsg-1ubuntu1 | trusty | amd64, arm64, armhf, i386, powerpc, ppc64el
 mysql-server-core-5.5 | 5.5.54-0ubuntu0.12.04.1 | precise-security | amd64, armel, armhf, i386, powerpc
 mysql-server-core-5.5 | 5.5.54-0ubuntu0.12.04.1 | precise-updates | amd64, armel, armhf, i386, powerpc
 mysql-server-core-5.5 | 5.5.58-0ubuntu0.14.04.1 | trusty-security | amd64, arm64, armhf, i386, powerpc, ppc64el
 mysql-server-core-5.5 | 5.5.58-0ubuntu0.14.04.1 | trusty-updates | amd64, arm64, armhf, i386, powerpc, ppc64el

Did you move from this 5.6.38 community version to the ubuntu version which is 5.5.58 and that's when the error happened?

[Launchpad Janitor (janitor)]

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