Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1180251

Summary: tomcat on Sat with PG is started with library path set to oracle driver
Product: Red Hat Satellite 5 Reporter: Tomas Lestach <tlestach>
Component: ServerAssignee: Jan Dobes <jdobes>
Status: CLOSED CURRENTRELEASE QA Contact: Ales Dujicek <adujicek>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 570CC: adujicek, cperry, jdobes
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: spacewalk-setup-2.3.0-16 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-05-29 21:50:30 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:
Bug Depends On:    
Bug Blocks: 1095841, 1162131, 1198708    

Description Tomas Lestach 2015-01-08 17:27:54 UTC
Description of problem:
Tomcat on Sat5.7 with PG database is run with ld library path pointing to oracle driver location.

Version-Release number of selected component (if applicable):
Satellite-5.7.0-RHEL6-re20150108.0
spacewalk-setup-2.3.0-15.el6sat.noarch

How reproducible:
always

Steps to Reproduce:
1. Install a clean Sat5.7 with EmbPG
2. Run:
# ps aux | grep tomcat
and search for: 
-Djava.library.path=${system_property:java.library.path}:/usr/lib:/usr/lib/oracle/10.2.0.4/client64/lib 


Actual results:
# ps aux | grep tomcat
tomcat   15802  0.6 16.1 1451160 362464 ?      Sl   17:30   0:16 /usr/lib/jvm/java/bin/java -ea -Xms256m -Xmx256m -Djava.awt.headless=true -Dorg.xml.sax.driver=org.apache.xerces.parsers.SAXParser -Dorg.apache.tomcat.util.http.Parameters.MAX_COUNT=1024 -XX:MaxNewSize=256 -XX:-UseConcMarkSweepGC -Dnet.sf.ehcache.skipUpdateCheck=true -Dcom.ibm.tools.attach.enable=no -Djavax.sql.DataSource.Factory=org.apache.commons.dbcp.BasicDataSourceFactory -Djava.library.path=${system_property:java.library.path}:/usr/lib:/usr/lib/oracle/10.2.0.4/client64/lib -classpath :/usr/share/tomcat6/bin/bootstrap.jar:/usr/share/tomcat6/bin/tomcat-juli.jar:/usr/share/java/commons-daemon.jar -Dcatalina.base=/usr/share/tomcat6 -Dcatalina.home=/usr/share/tomcat6 -Djava.endorsed.dirs= -Djava.io.tmpdir=/var/cache/tomcat6/temp -Djava.util.logging.config.file=/usr/share/tomcat6/conf/logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager org.apache.catalina.startup.Bootstrap start
...

Expected results:
Tomcat does not need to link oracle driver, if runs against PG database.

Additional info:
# rpm -q oracle-instantclient-basic
oracle-instantclient-basic-10.2.0-47.el6sat.x86_64

Comment 1 Tomas Lestach 2015-01-09 11:14:17 UTC
Note:
* the reason is:
   # rpm -qf /etc/ld.so.conf.d/oracle-instantclient64.conf 
   oracle-instantclient-basic-10.2.0-47.el6sat.x86_64
* we need to use a file from oracle-instantclient-sqlplus package instead
* not a regression, similar faulty tomcat setup on Sat5.6 as well

Comment 2 Jan Dobes 2015-03-04 17:58:32 UTC
fixed in spacewalk master:

92eeba843faa1f0f65d1444057ef55429e6f6c22

Comment 5 Clifford Perry 2015-05-29 21:50:30 UTC
https://rhn.redhat.com/errata/RHEA-2015-0802.html