Bug 1023610

Summary: SELinux is preventing /usr/bin/postgres from 'read' accesses on the file unix.
Product: [Fedora] Fedora Reporter: mov_ebpesp
Component: selinux-policyAssignee: Miroslav Grepl <mgrepl>
Status: CLOSED ERRATA QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 19CC: dominick.grift, dwalsh, lvrabec, mgrepl
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Unspecified   
Whiteboard: abrt_hash:d82e991de5de30c83770130ce7009bbceac0cf3c2f28b740c3c9112fe79515c9
Fixed In Version: selinux-policy-3.12.1-74.26.fc19 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-06-27 02:23:02 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:

Description mov_ebpesp 2013-10-26 00:53:49 UTC
Description of problem:
SELinux is preventing /usr/bin/postgres from 'read' accesses on the file unix.

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

If you believe that postgres should be allowed read access on the unix 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 postgres /var/log/audit/audit.log | audit2allow -M mypol
# semodule -i mypol.pp

Additional Information:
Source Context                system_u:system_r:postgresql_t:s0
Target Context                system_u:object_r:proc_net_t:s0
Target Objects                unix [ file ]
Source                        postgres
Source Path                   /usr/bin/postgres
Port                          <Unknown>
Host                          (removed)
Source RPM Packages           postgresql-server-9.2.4-7.fc19.x86_64
Target RPM Packages           
Policy RPM                    selinux-policy-3.12.1-74.10.fc19.noarch
Selinux Enabled               True
Policy Type                   targeted
Enforcing Mode                Enforcing
Host Name                     (removed)
Platform                      Linux (removed) 3.11.6-200.fc19.x86_64 #1 SMP Fri
                              Oct 18 22:34:18 UTC 2013 x86_64 x86_64
Alert Count                   6
First Seen                    2013-10-23 20:31:15 CEST
Last Seen                     2013-10-26 02:47:33 CEST
Local ID                      a7f97e53-7db4-44e0-a1eb-a3c9380face1

Raw Audit Messages
type=AVC msg=audit(1382748453.471:477): avc:  denied  { read } for  pid=1502 comm="postgres" name="unix" dev="proc" ino=4026532002 scontext=system_u:system_r:postgresql_t:s0 tcontext=system_u:object_r:proc_net_t:s0 tclass=file


type=SYSCALL msg=audit(1382748453.471:477): arch=x86_64 syscall=access success=no exit=EACCES a0=7fff6f87d2f0 a1=4 a2=7fff6f87d2fe a3=a items=0 ppid=1 pid=1502 auid=4294967295 uid=26 gid=26 euid=26 suid=26 fsuid=26 egid=26 sgid=26 fsgid=26 ses=4294967295 tty=(none) comm=postgres exe=/usr/bin/postgres subj=system_u:system_r:postgresql_t:s0 key=(null)

Hash: postgres,postgresql_t,proc_net_t,file,read

Additional info:
reporter:       libreport-2.1.8
hashmarkername: setroubleshoot
kernel:         3.11.6-200.fc19.x86_64
type:           libreport

Comment 1 Lukas Vrabec 2014-03-17 10:43:26 UTC
commit 709e479669ed50cdf57f7631a5e7399f9ebe3075
Author: Lukas Vrabec <lvrabec>
Date:   Mon Mar 17 11:41:03 2014 +0100

    Allow postgresql to read network state

Comment 2 Fedora Update System 2014-03-21 14:35:55 UTC
selinux-policy-3.12.1-74.23.fc19 has been submitted as an update for Fedora 19.
https://admin.fedoraproject.org/updates/selinux-policy-3.12.1-74.23.fc19

Comment 3 Fedora Update System 2014-03-22 05:09:16 UTC
Package selinux-policy-3.12.1-74.23.fc19:
* should fix your issue,
* was pushed to the Fedora 19 testing repository,
* should be available at your local mirror within two days.
Update it with:
# su -c 'yum update --enablerepo=updates-testing selinux-policy-3.12.1-74.23.fc19'
as soon as you are able to.
Please go to the following url:
https://admin.fedoraproject.org/updates/FEDORA-2014-4216/selinux-policy-3.12.1-74.23.fc19
then log in and leave karma (feedback).

Comment 4 Fedora Update System 2014-05-07 16:25:53 UTC
selinux-policy-3.12.1-74.26.fc19 has been submitted as an update for Fedora 19.
https://admin.fedoraproject.org/updates/selinux-policy-3.12.1-74.26.fc19

Comment 5 Fedora Update System 2014-06-27 02:23:02 UTC
selinux-policy-3.12.1-74.26.fc19 has been pushed to the Fedora 19 stable repository.  If problems still persist, please make note of it in this bug report.