Bug 1593639

Summary: SELinux is preventing mysqld from using the 'sys_nice' capabilities.
Product: [Fedora] Fedora Reporter: blu.vishal
Component: selinux-policyAssignee: Jakub Jančo <jjanco>
Status: CLOSED ERRATA QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 28CC: al.atrash.wael, dwalsh, lvrabec, mgrepl, mschorm, plautrba, pmoore, rolandjamesaskew37
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Unspecified   
Whiteboard: abrt_hash:041e04b306406a6ba642b3875b5aa1f16f0ccc66b29572fb1f603dc6a647d20c;VARIANT_ID=workstation;
Fixed In Version: selinux-policy-3.14.1-42.fc28 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of:
: 1629041 (view as bug list) Environment:
Last Closed: 2018-09-11 16:55:40 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1540946, 1628814, 1628815, 1629041    
Attachments:
Description Flags
File: screencast-06-21-2018-01:43:49 PM.webm none

Description blu.vishal 2018-06-21 09:47:29 UTC
Description of problem:
1: Started MySQL server: systemctl start mysqld
2. Got error message: Job for mysqld.service failed because the control process exited with error code.
See "systemctl status mysqld.service" and "journalctl -xe" for details.
3. SELinux also displayed error message: SELinux is preventing mysqld from using the 'sys_nice' capabilities.
SELinux is preventing mysqld from using the 'sys_nice' capabilities.

*****  Plugin catchall (100. confidence) suggests   **************************

If you believe that mysqld should have the sys_nice capability 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:
# ausearch -c 'mysqld' --raw | audit2allow -M my-mysqld
# semodule -X 300 -i my-mysqld.pp

Additional Information:
Source Context                system_u:system_r:mysqld_t:s0
Target Context                system_u:system_r:mysqld_t:s0
Target Objects                Unknown [ capability ]
Source                        mysqld
Source Path                   mysqld
Port                          <Unknown>
Host                          (removed)
Source RPM Packages           
Target RPM Packages           
Policy RPM                    selinux-policy-3.14.1-32.fc28.noarch
Selinux Enabled               True
Policy Type                   targeted
Enforcing Mode                Permissive
Host Name                     (removed)
Platform                      Linux (removed) 4.16.14-300.fc28.x86_64 #1 SMP Tue
                              Jun 5 16:23:44 UTC 2018 x86_64 x86_64
Alert Count                   54
First Seen                    2018-06-20 13:27:43 +04
Last Seen                     2018-06-21 13:38:53 +04
Local ID                      353f9c01-0c75-4109-9f05-2b567275546c

Raw Audit Messages
type=AVC msg=audit(1529573933.201:286): avc:  denied  { sys_nice } for  pid=3169 comm="mysqld" capability=23  scontext=system_u:system_r:mysqld_t:s0 tcontext=system_u:system_r:mysqld_t:s0 tclass=capability permissive=1


Hash: mysqld,mysqld_t,mysqld_t,capability,sys_nice

Version-Release number of selected component:
selinux-policy-3.14.1-32.fc28.noarch

Additional info:
component:      selinux-policy
reporter:       libreport-2.9.5
hashmarkername: setroubleshoot
kernel:         4.16.14-300.fc28.x86_64
type:           libreport

Potential duplicate: bug 1540946

Comment 1 blu.vishal 2018-06-21 09:47:38 UTC
Created attachment 1453391 [details]
File: screencast-06-21-2018-01:43:49 PM.webm

Comment 2 Jakub Jančo 2018-08-29 15:09:53 UTC
PR sent.

Comment 3 Fedora Update System 2018-09-06 21:57:01 UTC
selinux-policy-3.14.1-42.fc28 has been submitted as an update to Fedora 28. https://bodhi.fedoraproject.org/updates/FEDORA-2018-2d1b09d217

Comment 4 Fedora Update System 2018-09-07 17:12:26 UTC
selinux-policy-3.14.1-42.fc28 has been pushed to the Fedora 28 testing repository. If problems still persist, please make note of it in this bug report.
See https://fedoraproject.org/wiki/QA:Updates_Testing for
instructions on how to install test updates.
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2018-2d1b09d217

Comment 5 Fedora Update System 2018-09-11 16:55:40 UTC
selinux-policy-3.14.1-42.fc28 has been pushed to the Fedora 28 stable repository. If problems still persist, please make note of it in this bug report.