Bug 691562 - SELinux is preventing /usr/bin/postgres from 'open' accesses on the directory postgres_data.
Summary: SELinux is preventing /usr/bin/postgres from 'open' accesses on the directory...
Keywords:
Status: CLOSED DUPLICATE of bug 691546
Alias: None
Product: Fedora
Classification: Fedora
Component: selinux-policy
Version: 14
Hardware: x86_64
OS: Linux
unspecified
medium
Target Milestone: ---
Assignee: Miroslav Grepl
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard: setroubleshoot_trace_hash:446cdf50a73...
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-03-28 20:22 UTC by roland
Modified: 2011-03-29 11:05 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-03-29 11:05:11 UTC
Type: ---


Attachments (Terms of Use)

Description roland 2011-03-28 20:22:48 UTC
SELinux is preventing /usr/bin/postgres from 'open' accesses on the directory postgres_data.

*****  Plugin file (36.8 confidence) suggests  *******************************

If you think this is caused by a badly mislabeled machine.
Then you need to fully relabel.
Do
touch /.autorelabel; reboot

*****  Plugin file (36.8 confidence) suggests  *******************************

If you think this is caused by a badly mislabeled machine.
Then you need to fully relabel.
Do
touch /.autorelabel; reboot

*****  Plugin catchall_labels (23.2 confidence) suggests  ********************

If you want to allow postgres to have open access on the postgres_data directory
Then you need to change the label on postgres_data
Do
# semanage fcontext -a -t FILE_TYPE 'postgres_data'
where FILE_TYPE is one of the following: var_log_t, abrt_var_run_t, samba_var_t, avahi_var_run_t, net_conf_t, sysctl_crypto_t, setrans_var_run_t, sysctl_kernel_t, cron_spool_t, dirsrv_var_run_t, openct_var_run_t, nscd_var_run_t, nslcd_var_run_t, var_lib_t, sysctl_t, pcscd_var_run_t, abrt_t, slapd_var_run_t, bin_t, sssd_var_lib_t, lib_t, mnt_t, root_t, tmp_t, usr_t, var_t, device_t, system_dbusd_var_lib_t, etc_t, system_dbusd_var_run_t, postgresql_var_run_t, proc_t, var_lock_t, sysctl_t, bin_t, cert_t, selinux_config_t, textrel_shlib_t, tmp_t, usr_t, var_t, winbind_var_run_t, rpm_script_tmp_t, mail_spool_t, sssd_public_t, sysctl_type, autofs_t, device_t, devpts_t, security_t, locale_t, etc_t, postgresql_tmp_t, proc_t, sysfs_t, tmpfs_t, likewise_var_lib_t, default_t, hugetlbfs_t, rpm_tmp_t, var_run_t, krb5_conf_t, postgresql_db_t, postgresql_t, httpd_sys_content_t, postgresql_etc_t, postgresql_log_t, auth_cache_t, security_t, udev_tbl_t, var_spool_t, rpm_log_t, var_log_t, var_t, var_lib_t, var_run_t, dbusd_etc_t, logfile, proc_net_t, file_context_t, nscd_var_run_t, pcscd_var_run_t, selinux_config_t, tmp_t, var_t, var_t, default_context_t, etc_t, security_t, cgroup_t, root_t, var_run_t, var_run_t, sysfs_t, tmpfs_t. 
Then execute: 
restorecon -v 'postgres_data'


*****  Plugin catchall (5.04 confidence) suggests  ***************************

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

Additional Information:
Source Context                unconfined_u:system_r:postgresql_t:s0
Target Context                unconfined_u:object_r:file_t:s0
Target Objects                postgres_data [ dir ]
Source                        postmaster
Source Path                   /usr/bin/postgres
Port                          <Unknown>
Host                          (removed)
Source RPM Packages           postgresql-server-8.4.7-1.fc14
Target RPM Packages           
Policy RPM                    selinux-policy-3.9.7-37.fc14
Selinux Enabled               True
Policy Type                   targeted
Enforcing Mode                Enforcing
Host Name                     (removed)
Platform                      Linux (removed)
                              2.6.35.11-83.fc14.x86_64 #1 SMP Mon Feb 7 07:06:44
                              UTC 2011 x86_64 x86_64
Alert Count                   1
First Seen                    Mon 28 Mar 2011 03:20:22 PM CDT
Last Seen                     Mon 28 Mar 2011 03:20:22 PM CDT
Local ID                      76b8264d-892b-4ae7-ac39-c58953dca967

Raw Audit Messages
type=AVC msg=audit(1301343622.75:26216): avc:  denied  { open } for  pid=3305 comm="postmaster" name="postgres_data" dev=sda7 ino=32769 scontext=unconfined_u:system_r:postgresql_t:s0 tcontext=unconfined_u:object_r:file_t:s0 tclass=dir


type=SYSCALL msg=audit(1301343622.75:26216): arch=x86_64 syscall=open success=no exit=EACCES a0=203afb0 a1=90800 a2=3d8 a3=10 items=0 ppid=2504 pid=3305 auid=500 uid=26 gid=26 euid=26 suid=26 fsuid=26 egid=26 sgid=26 fsgid=26 tty=(none) ses=1 comm=postmaster exe=/usr/bin/postgres subj=unconfined_u:system_r:postgresql_t:s0 key=(null)

Hash: postmaster,postgresql_t,file_t,dir,open

audit2allow

#============= postgresql_t ==============
allow postgresql_t file_t:dir open;

audit2allow -R

#============= postgresql_t ==============
allow postgresql_t file_t:dir open;

Comment 1 Miroslav Grepl 2011-03-29 11:05:11 UTC

*** This bug has been marked as a duplicate of bug 691546 ***


Note You need to log in before you can comment on or make changes to this bug.