Bug 1585328

Summary: SELinux prevents zoneminder from connecting to remote mysql database
Product: Red Hat Enterprise Linux 7 Reporter: Orion Poplawski <orion>
Component: selinux-policyAssignee: Lukas Vrabec <lvrabec>
Status: CLOSED ERRATA QA Contact: Milos Malik <mmalik>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 7.5CC: lvrabec, mgrepl, mmalik, plautrba, ssekidde
Target Milestone: rc   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2018-10-30 10:05:00 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:
Embargoed:
Attachments:
Description Flags
audit messages none

Description Orion Poplawski 2018-06-01 21:16:14 UTC 
Description of problem:

type=AVC msg=audit(1527885499.561:8959): avc:  denied  { name_connect } for  pid=27925 comm="zmpkg.pl" dest=3306 scontext=system_u:system_r:zoneminder_t:s0 tcontext=system_u:object_r:mysqld_port_t:s0 tclass=tcp_socket


Also:

type=AVC msg=audit(1527887521.109:9301): avc:  denied  { getattr } for  pid=31771 comm="df" name="/" dev="vda2" ino=64 scontext=system_u:system_r:zoneminder_t:s0 tcontext=system_u:object_r:fs_t:s0 tclass=filesystem


Haven't noticed anything else so far while in permissive mode.

Version-Release number of selected component (if applicable):
selinux-policy-3.13.1-192.el7_5.3.noarch
Comment 2 Orion Poplawski 2018-06-01 22:30:34 UTC 
after setting up a camera, ended up with:

#============= httpd_t ==============
allow httpd_t zoneminder_var_lib_t:lnk_file create;
allow httpd_t zoneminder_var_lib_t:sock_file { create unlink };

#============= zoneminder_script_t ==============
allow zoneminder_script_t cert_t:dir search;
allow zoneminder_script_t httpd_t:unix_dgram_socket sendto;
allow zoneminder_script_t mysqld_port_t:tcp_socket name_connect;
allow zoneminder_script_t sysfs_t:dir read;
allow zoneminder_script_t sysfs_t:file { getattr open read };
allow zoneminder_script_t tmpfs_t:dir { add_name create read remove_name rmdir write };
allow zoneminder_script_t tmpfs_t:file { create getattr open read unlink write };
allow zoneminder_script_t zoneminder_var_lib_t:file { create lock open unlink write };

#============= zoneminder_t ==============

allow zoneminder_t fs_t:filesystem getattr;
allow zoneminder_t mysqld_port_t:tcp_socket name_connect;
allow zoneminder_t rtsp_port_t:tcp_socket name_connect;

and enabling nis_enabled.
Comment 3 Orion Poplawski 2018-06-01 22:31:42 UTC 
Created attachment 1446874 [details]
audit messages
Comment 7 errata-xmlrpc 2018-10-30 10:05:00 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://access.redhat.com/errata/RHBA-2018:3111