[MDEV-7603] MariaDB fails to install on Power8 Ubuntu because of apparmor Created: 2015-02-17  Updated: 2017-08-29  Resolved: 2017-08-29

Status: Closed
Project: MariaDB Server
Component/s: Packaging
Affects Version/s: 10.0.16-galera, 10.0.16
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Daniel Bartholomew Assignee: Daniel Bartholomew
Resolution: Cannot Reproduce Votes: 0
Labels: None


 Description   

MariaDB on Power8 Ubuntu correctly depends on the Advance Toolchain runtime but when trying to install, apparmor prevents mysqld from loading the libraries.

I was under the impression that the /etc/apparmor.d/usr.sbin.mysqld disabled apparmor for MariaDB, and that file is in place on that host, but maybe there's something with the runtime that is interfering.

Snippet from the syslog:

Feb 17 16:36:44 sovmp165 mysqld_safe[31019]: /usr/sbin/mysqld: error while loading shared libraries: libpthread.so.0: cannot open shared object file: Permission denied
 
Feb 17 16:36:44 sovmp165 kernel: [666470.582428] type=1400 audit(1424191004.946:183): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/opt/at8.0/lib64/power8/libpthread-2.20.so" pid=31018 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
 
Feb 17 16:36:44 sovmp165 kernel: [666470.582457] type=1400 audit(1424191004.946:184): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/opt/at8.0/lib64/libpthread-2.20.so" pid=31018 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
 
Feb 17 16:36:44 sovmp165 kernel: [666470.582473] type=1400 audit(1424191004.946:185): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/opt/at8.0/etc/ld.so.cache" pid=31018 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
 
Feb 17 16:36:44 sovmp165 kernel: [666470.582485] type=1400 audit(1424191004.946:186): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/opt/at8.0/lib64/power8/libpthread-2.20.so" pid=31018 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0
 
Feb 17 16:36:44 sovmp165 kernel: [666470.582496] type=1400 audit(1424191004.946:187): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/opt/at8.0/lib64/libpthread-2.20.so" pid=31018 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=0 ouid=0



 Comments   
Comment by Daniel Bartholomew [ 2015-02-18 ]

I just spun up a new IBM P8 Ubuntu image and tried installing MariaDB and it worked. So it may be that it was a fluke.

Comment by Daniel Black [ 2017-08-29 ]

seems fair enough to close this now. i've never seen it either.

Debian/Ubuntu packages have systemd now and don't use mysqld_safe.

Generated at Thu Feb 08 07:20:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.