Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> 9ias / 6iserver reports

9ias / 6iserver reports

From: Frank <franks_at_eng.dowjones.com>
Date: 7 Apr 2003 21:04:09 -0700
Message-ID: <84fdb9cd.0304072004.638b298b@posting.google.com>


(posted to the wrong group earlier today - reposting)

I just started working with Oracle IAS and report server recently but have worked with Apache in the past.
In particular, I am having trouble with the Oracle Report Server CGI. We are using Oracle Application Server 9i with the 6iserver reports server; our platform is Solaris 8.

The problem seems related to the configuration change I made to Apache so it listens on port 80 instead of 7777. Because of security restrictions on Solaris, I must start apachectl with the root user, then use the httpd.conf User directive to run the server as my lesser ias user.
When I try to view a report
(http://homer/dev60cgi/rwcgi60/getjobid1?server=repserv), instead of the PDF file being displayed, the following message appears:

RWCGI Get Job Ouput
Cannot Get Output of Job ID 1 you requested on April , 07 2003, 14:36:47.
Cannot access the report output.

If I check the Oracle Report Server Queue Status (http://homer/dev60cgi/rwcgi60/showjobs?server=repserv), my job status is displayed as finished, but the job owner is set to root instead of ias. Also, the output type is "cache" but the output name is empty, if that matters.

The report (in PDF format) does indeed get generated and placed in the cache directory. The report file is owned by the ias user, but as long as apache is started by user root, the cgi script cannot obtain the output (I assume it is a permissions problem between root and ias). If I change the port from 80 to 7777 and restart apache as user ias, the cgi script can successfully display the report output.

Digging a little further I noticed that when I use root to start apache via apachectl, three java processes startup as user root instead of ias. I suppose apache starts the java servlets as root before switching the user id to ias. I believe this is the problem but don't know how to address it:

/usr/ucb/ps -auxww | grep -i jserv | grep root
root 1978 0.0 0.76228024936 ? S 16:27:30 0:00
/export/home/oracle/product/9ias/Apache/jdk/bin/../bin/sparc/native_threads/java
-mx256M-Dorg.omg.CORBA.ORBClass=com.visigenic.vbroker.orb.ORB -Dorg.omg.CORBA.ORBSingletonClass=com.visigenic.vbroker.orb.ORB org.apache.jserv.JServ -opmpropfile
/export/home/oracle/product/9ias/Apache/Jserv/etc/jserv.properties
-opmhost homer -opmport 3339 -opmgrp group1 -opmindex 0 -opmprocid 1 root 1979 0.0 0.54211218104 ? S 16:27:30 0:00
/export/home/oracle/product/9ias/Apache/jdk/bin/../bin/sparc/native_threads/java
org.apache.jserv.JServ -opmpropfile
/export/home/oracle/product/9ias/Apache/Jserv/etc/jservSoap.properties
-opmhost homer -opmport 3339 -opmgrp group2 -opmindex 0 -opmprocid 2 root 1982 0.0 0.56090419312 ? S 16:27:30 0:00
/usr/j2se/bin/../bin/sparc/native_threads/java
-mx256M-Dorg.omg.CORBA.ORBClass=com.visigenic.vbroker.orb.ORB -Dorg.omg.CORBA.ORBSingletonClass=com.visigenic.vbroker.orb.ORB org.apache.jserv.JServ -opmpropfile
/export/home/dst/conf/jserv.properties -opmhost homer -opmport 3339
-opmgrp dstm -opmindex 0 -opmprocid 3

There is also one java process that runs as ias: ias 1908 0.0 0.44179214752 pts/5 S 16:20:14 0:00
/export/home/oracle/product/9ias/Apache/jdk/bin/../bin/sparc/native_threads/java
-classpath /export/home/oracle/product/9ias/Apache/jdk/lib/tools.jar:/export/home/oracle/product/9ias/Apache/Jserv/libexec/ApacheJServ.jar:/export/home/oracle/product/9ias/Apache/Jserv/libexec/dms2Server.jar:/export/home/oracle/product/9ias/Apache/Jsdk/lib/jsdk.jar:/export/home/oracle/product/9ias/lib/servlet.jar:/export/home/oracle/product/9ias/jdbc/lib/classes12.zip:/export/home/oracle/product/9 as/soap/webapps/soap/WEB-INF/lib/xmlparserv2-soap.jar:/export/home/oracle/product/9ias/soap/webapps/soap/WEB-INF/lib/soap.jar:/export/home/oracle/product/9ias/soap/webapps/soap/WEB-INF/lib/samples.jar:. org.apache.jserv.JServ -opmpropfile
/export/home/oracle/product/9ias/Apache/Jserv/etc/jserv.properties

The report server is running as ias:
bash-2.03$ /usr/ucb/ps -auxww | grep rep ias 1550 0.0 0.210432 7320 pts/3 S 15:02:39 0:00 rwmts60 name=repserv
ias 1551 0.0 0.64063222200 pts/3 S 15:02:39 0:00 rwrun60 ora_rw20_3tng repserv repserv JCfiRGxuh
ias 1553 0.0 0.43814416656 pts/3 S 15:02:39 0:00 rwrun60 ora_rw20_3tng repserv repserv nDxoNqko0I9

And lastly, I expected to see one Apache process running as root and the rest running as user ias, but there are two processes running as root:
bash-2.03$ /usr/ucb/ps -auxwwl | grep http  8 0 1975 1 0 59 2018928 9576 mutex_ex S ? 0:00
/export/home/oracle/product/9ias/Apache/Apache/bin/httpd -d
/export/home/oracle/product/9ias/Apache/Apache
 8 0 1977 1975 0 59 2016264 2224 mutex_ex S ? 0:00
/export/home/oracle/product/9ias/Apache/Apache/bin/httpd -d
/export/home/oracle/product/9ias/Apache/Apache
 8 100 2007 1975 0 58 2019176 5264 mutex_ex S ? 0:00
/export/home/oracle/product/9ias/Apache/Apache/bin/httpd -d
/export/home/oracle/product/9ias/Apache/Apache
 8 100 2008 1975 0 53 2019176 5256 mutex_ex S ? 0:00
/export/home/oracle/product/9ias/Apache/Apache/bin/httpd -d
/export/home/oracle/product/9ias/Apache/Apache
 8 100 2009 1975 0 58 2019176 5264 mutex_ex S ? 0:00
/export/home/oracle/product/9ias/Apache/Apache/bin/httpd -d
/export/home/oracle/product/9ias/Apache/Apache
 8 100 2010 1975 0 58 2019216 5256 mutex_ex S ? 0:00
/export/home/oracle/product/9ias/Apache/Apache/bin/httpd -d
/export/home/oracle/product/9ias/Apache/Apache
 8 100 2011 1975 0 58 2019176 5248 mutex_ex S ? 0:00
/export/home/oracle/product/9ias/Apache/Apache/bin/httpd -d
/export/home/oracle/product/9ias/Apache/Apache
 8 100 2014 1975 0 58 2019216 5256 mutex_ex S ? 0:00
/export/home/oracle/product/9ias/Apache/Apache/bin/httpd -d
/export/home/oracle/product/9ias/Apache/Apache
 8 100 2015 1975 0 58 2019224 5264 mutex_ex S ? 0:00
/export/home/oracle/product/9ias/Apache/Apache/bin/httpd -d
/export/home/oracle/product/9ias/Apache/Apache
 8 100 2016 1975 0 58 2019224 5272 mutex_ex S ? 0:00
/export/home/oracle/product/9ias/Apache/Apache/bin/httpd -d
/export/home/oracle/product/9ias/Apache/Apache

If anyone has gone through this before, I would really appreciate any solutions you might have.
We really want to run the web server on port 80, but the report server is being quite stubborn about that and just can't access the report output from the servlet that runs as root.

Thank you for your time.
Regards,
Frank Received on Mon Apr 07 2003 - 23:04:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US