libreport version: 2.0.8 executable: /usr/bin/python hashmarkername: setroubleshoot kernel: 3.3.1-5.fc16.x86_64 reason: SELinux is preventing /usr/libexec/mysqld from 'read' accesses on the file /home/mysql/mysql/wikidb/db.opt. time: Wed 18 Apr 2012 06:03:20 PM PDT description: :SELinux is preventing /usr/libexec/mysqld from 'read' accesses on the file /home/mysql/mysql/wikidb/db.opt. : :***** Plugin catchall (100. confidence) suggests *************************** : :If you believe that mysqld should be allowed read access on the db.opt file by default. :Then you should report this as a bug. :You can generate a local policy module to allow this access. :Do :allow this access for now by executing: :# grep mysqld /var/log/audit/audit.log | audit2allow -M mypol :# semodule -i mypol.pp : :Additional Information: :Source Context system_u:system_r:mysqld_t:s0 :Target Context system_u:object_r:user_home_t:s0 :Target Objects /home/mysql/mysql/wikidb/db.opt [ file ] :Source mysqld :Source Path /usr/libexec/mysqld :Port <Unknown> :Host (removed) :Source RPM Packages mysql-server-5.5.22-1.fc16.x86_64 :Target RPM Packages :Policy RPM selinux-policy-3.10.0-80.fc16.noarch :Selinux Enabled True :Policy Type targeted :Enforcing Mode Permissive :Host Name (removed) :Platform Linux (removed) 3.3.1-5.fc16.x86_64 #1 SMP Tue : Apr 10 19:56:52 UTC 2012 x86_64 x86_64 :Alert Count 4 :First Seen Fri 06 Apr 2012 07:01:02 PM PDT :Last Seen Wed 18 Apr 2012 06:02:20 PM PDT :Local ID 1a611280-4ad5-4728-8414-355934a3e586 : :Raw Audit Messages :type=AVC msg=audit(1334797340.938:159): avc: denied { read } for pid=10015 comm="mysqld" name="db.opt" dev="sdb4" ino=34078959 scontext=system_u:system_r:mysqld_t:s0 tcontext=system_u:object_r:user_home_t:s0 tclass=file : : :type=AVC msg=audit(1334797340.938:159): avc: denied { open } for pid=10015 comm="mysqld" name="db.opt" dev="sdb4" ino=34078959 scontext=system_u:system_r:mysqld_t:s0 tcontext=system_u:object_r:user_home_t:s0 tclass=file : : :type=SYSCALL msg=audit(1334797340.938:159): arch=x86_64 syscall=open success=yes exit=EPIPE a0=7fb80c56fd80 a1=0 a2=1b0 a3=f6ce6c items=0 ppid=1 pid=10015 auid=4294967295 uid=27 gid=27 euid=27 suid=27 fsuid=27 egid=27 sgid=27 fsgid=27 tty=(none) ses=4294967295 comm=mysqld exe=/usr/libexec/mysqld subj=system_u:system_r:mysqld_t:s0 key=(null) : :Hash: mysqld,mysqld_t,user_home_t,file,read : :audit2allow : :#============= mysqld_t ============== :allow mysqld_t user_home_t:file { read open }; : :audit2allow -R : :#============= mysqld_t ============== :allow mysqld_t user_home_t:file { read open }; :
If you want to put a mysql database in your homedirs you will have to either setup labeling for ot or allow the access by building a custom policy. # semanage fcontext -a -t mysql_db_t '/home/mysql/mysq(/.*)?' # restorecon -R -v /home/mysql/mysq Or # grep mysqld /var/log/audit/audit.log | audit2allow -M mymysql # semodule -i mymysql.pp
*** Bug 814030 has been marked as a duplicate of this bug. ***