Bug 636368

Summary: SELinux is preventing /usr/lib/oracle/10.2.0.4/client/bin/sqlplus "search" access on /home.
Product: [Community] Spacewalk Reporter: Frank Ybanez <fybanez>
Component: ServerAssignee: Jan Pazdziora <jpazdziora>
Status: CLOSED CURRENTRELEASE QA Contact: Red Hat Satellite QA List <satqe-list>
Severity: medium Docs Contact:
Priority: low    
Version: 1.1CC: akozlenko.kz, dwalsh, jpazdziora, mgrepl, msuchy, slukasik
Target Milestone: ---   
Target Release: ---   
Hardware: i386   
OS: Linux   
Whiteboard: setroubleshoot_trace_hash:bd5208f7799fda04ec5b3420d2ce65006509ffba0e28ac6fb28df459348a3565
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2010-11-19 16:16:13 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: 623772    

Description Frank Ybanez 2010-09-22 00:24:43 UTC
Summary:

SELinux is preventing /usr/lib/oracle/10.2.0.4/client/bin/sqlplus "search"
access on /home.

Detailed Description:

SELinux denied access requested by sqlplus. It is not expected that this access
is required by sqlplus and this access may signal an intrusion attempt. It is
also possible that the specific version or configuration of the application is
causing it to require additional access.

Allowing Access:

You can generate a local policy module to allow this access - see FAQ
(http://docs.fedoraproject.org/selinux-faq-fc5/#id2961385) Please file a bug
report.

Additional Information:

Source Context                unconfined_u:unconfined_r:oracle_sqlplus_t:s0-s0:c
                              0.c1023
Target Context                system_u:object_r:home_root_t:s0
Target Objects                /home [ dir ]
Source                        sqlplus
Source Path                   /usr/lib/oracle/10.2.0.4/client/bin/sqlplus
Port                          <Unknown>
Host                          (removed)
Source RPM Packages           oracle-instantclient-sqlplus-10.2.0.4-1
Target RPM Packages           filesystem-2.4.31-1.fc13
Policy RPM                    selinux-policy-3.7.19-54.fc13
Selinux Enabled               True
Policy Type                   targeted
Enforcing Mode                Enforcing
Plugin Name                   catchall
Host Name                     (removed)
Platform                      Linux (removed) 2.6.34.6-54.fc13.i686.PAE #1 SMP
                              Sun Sep 5 17:33:43 UTC 2010 i686 i686
Alert Count                   110
First Seen                    Tue 21 Sep 2010 03:11:46 PM MST
Last Seen                     Tue 21 Sep 2010 03:11:46 PM MST
Local ID                      700b827f-a950-4006-a58d-68d9e5da6cc6
Line Numbers                  

Raw Audit Messages            

node=(removed) type=AVC msg=audit(1285107106.803:632): avc:  denied  { search } for  pid=16255 comm="sqlplus" name="home" dev=dm-0 ino=1572865 scontext=unconfined_u:unconfined_r:oracle_sqlplus_t:s0-s0:c0.c1023 tcontext=system_u:object_r:home_root_t:s0 tclass=dir

node=(removed) type=SYSCALL msg=audit(1285107106.803:632): arch=40000003 syscall=33 success=no exit=-13 a0=bf8ced90 a1=0 a2=3addf64 a3=3a0678c items=0 ppid=16251 pid=16255 auid=500 uid=0 gid=0 euid=0 suid=0 fsuid=0 egid=0 sgid=0 fsgid=0 tty=pts4 ses=1 comm="sqlplus" exe="/usr/lib/oracle/10.2.0.4/client/bin/sqlplus" subj=unconfined_u:unconfined_r:oracle_sqlplus_t:s0-s0:c0.c1023 key=(null)



Hash String generated from  catchall,sqlplus,oracle_sqlplus_t,home_root_t,dir,search
audit2allow suggests:

#============= oracle_sqlplus_t ==============
allow oracle_sqlplus_t home_root_t:dir search;

Comment 1 Jan Pazdziora 2010-09-27 15:27:56 UTC
Taking.

Comment 2 Jan Pazdziora 2010-09-27 15:28:50 UTC
When does this AVC happen? What actions were you doing when it happened?

Comment 3 Frank Ybanez 2010-09-27 19:24:29 UTC
This occurs immediately following a complete installation of Spacewalk on F13. 

https://fedorahosted.org/spacewalk/wiki/OracleXeSetup#KnownIssues

I'm betting the following packages need revision/to be updated to deal with this AVC exception:

oracle-xe-selinux 
oracle-instantclient-selinux 
oracle-instantclient-sqlplus-selinux

Or maybe Oracle is really doing something it shouldn't.

Comment 4 Jan Pazdziora 2010-09-27 20:15:05 UTC
(In reply to comment #3)
> This occurs immediately following a complete installation of Spacewalk on F13. 
> 
> https://fedorahosted.org/spacewalk/wiki/OracleXeSetup#KnownIssues

I'm confused. Is it after you've finished the steps at the OracleXeSetup page (but before you've installed the Spacewalk bits), or after all Spacewalk packages were installed? Or is it after the spacewalk-setup was run?

Comment 5 Jan Pazdziora 2010-10-29 06:31:46 UTC
Anyway, I believe that the issue was addressed in Spacewalk master ec440206d21021c2ba8fdedf3dc9e2b6f1f31386, when we fixed bug 626420 (it's actually a dupe thereof).

Comment 7 Jan Pazdziora 2010-11-15 19:31:39 UTC
Oops, append $basearch/os to the paths to get correct baseurl.

Comment 8 Jan Pazdziora 2010-11-19 16:16:13 UTC
With Spacewalk 1.2 released, marking as CLOSED CURRENTRELEASE.

https://www.redhat.com/archives/spacewalk-list/2010-November/msg00111.html