Bug 1391525

Summary: MySQL context for /var/lib/mysql-files
Product: Red Hat Enterprise Linux 6 Reporter: Honza Horak <hhorak>
Component: selinux-policyAssignee: Lukas Vrabec <lvrabec>
Status: CLOSED ERRATA QA Contact: Milos Malik <mmalik>
Severity: medium Docs Contact:
Priority: medium    
Version: 6.9CC: dwalsh, lvrabec, mgrepl, mmalik, plautrba, pvrabec, qe-baseos-security, ssekidde
Target Milestone: rc   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: selinux-policy-3.7.19-299.el6 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: 1391521 Environment:
Last Closed: 2017-03-21 09:48:47 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Bug Depends On: 1391521    
Bug Blocks: 1391947    

Description Honza Horak 2016-11-03 13:27:53 UTC 
+++ This bug was initially created as a clone of Bug #1391521 +++

Description of problem:

In Fedora we have this rule for mysql directories:
  /var/lib/mysql(-files|-keyring)?(/.*)?    mysqld_db_t

In RHEL we only have:
  /var/lib/mysql(/.*)?                      mysqld_db_t

For RHSCL packages (rh-mysql56 specifically) we now started to use /var/opt/rh/rh-mysql56/lib/mysql-files (because of bz #1384962) and we also define this rule:
  /var/opt/rh/rh-mysql56 = /var (using semanage fcontext -a -e ...)

Since selinux's "equality" cannot be defined twice for given directory, we cannot define something like the following in mysql packge:
  /var/lib/mysql = /var/lib/mysql-files
or something like
  /var/opt/rh/rh-mysql56/lib/mysql-files = /var/lib/mysql

So I think we should change the definition in selinux-policy to be the same as in Fedora:
  /var/lib/mysql(-files|-keyring)?(/.*)?    mysqld_db_t

This would help in all packages we ship, so it wouldn't require us to fix particular packages.

Version-Release number of selected component (if applicable):
selinux-policy-3.13.1-102.el7.noarch

Steps to Reproduce:
1. ls -lZd /var/opt/rh/rh-mysql56/lib/mysql-files

Actual results:
drwxr-x---. mysql mysql system_u:object_r:var_lib_t:s0   /var/opt/rh/rh-mysql56/lib/mysql-files/

Expected results:
drwxr-x---. mysql mysql system_u:object_r:mysqld_db_t:s0   /var/opt/rh/rh-mysql56/lib/mysql-files/
Comment 10 errata-xmlrpc 2017-03-21 09:48:47 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://rhn.redhat.com/errata/RHBA-2017-0627.html