Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » USERID details not captured in access_log, pls help (Oracle 9i AS)
USERID details not captured in access_log, pls help [message #295824] Wed, 23 January 2008 11:04
syedashfaq2
Messages: 12
Registered: July 2005
Location: India
Junior Member

Hi,

We have a mod pl/sql application with Oracle 9i database and Oracle 9i AS on two different UNIX boxes.
This application is web based and authentication of users is done by database.

Now we are required to prepare a report of the userids that have accessed this web application, for this we are looking into access_log file of Oracle 9iAS but we are not able to see the USERID details in access_log.
And the access_log details from our Oracle 9iAS looks as shown below,

10.140.84.71 - - [23/Jan/2008:09:37:00 +0000] "HEAD / HTTP/1.1" 200 0
10.140.84.71 - - [23/Jan/2008:09:37:10 +0000] "HEAD / HTTP/1.1" 200 0
10.140.84.71 - - [23/Jan/2008:09:37:20 +0000] "HEAD / HTTP/1.1" 200 0
10.140.84.71 - - [23/Jan/2008:09:37:30 +0000] "HEAD / HTTP/1.1" 200 0

From the above, we can see in place of userid, it is just displaying "-" i.e 3rd parameter from left.

Also we have check httpd.conf file for logformat and it is set as follows,

# The following directives define some format nicknames for use with
# a CustomLog directive (see below).
#
LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined
LogFormat "%h %l %u %t \"%r\" %>s %b" common
LogFormat "%{Referer}i -> %U" referer
LogFormat "%{User-agent}i" agent
#
# The location and format of the access logfile (Common Logfile Format).
# If you do not define any access logfiles within a <VirtualHost>
# container, they will be logged here.  Contrariwise, if you *do*
# define per-<VirtualHost> access logfiles, transactions will be
# logged therein and *not* in this file.
#
CustomLog /opt/oracle/product/ias903/Apache/Apache/logs/access_log common
#
# If you would like to have agent and referer logfiles, uncomment the
# following directives.
#
#CustomLog /opt/oracle/product/ias903/Apache/Apache/logs/referer_log referer
#CustomLog /opt/oracle/product/ias903/Apache/Apache/logs/agent_log agent


Would anyone please help as to configure the access_log to display userid details?

Many Thanks in Advance,
SA
Previous Topic: FRM-40031
Next Topic: Failed to startup OC4J_BI_Forms instance in OAS 10gr2 Forms & Reports Services environment
Goto Forum:
  


Current Time: Thu Aug 21 23:07:39 CDT 2014

Total time taken to generate the page: 0.11432 seconds