README.ORACLE - rel 1.0 - Configuring WAS/OAS logs for webalizer use. This document contains information for setting up webalizer with Oracle Web Application Server. I tested this succesfully with Oracle WAS 3.x on Solaris 2.5.1, but it should work as well with OAS 4.x. Webalizer expects by default a CLF or Combined web server log as input. If you plan to get "standard" statistics (that is, you don't need user-agent or referrer reports) WAS/OAS logs would work just fine with webalizer. Simply configure your WAS/OAS logs with CLF format. If you need (like I do) further information about your visitors, you need to hack a little with WAS/OAS. - First of all, you need to configure a combined log. So, bring up the administration listener (tipically by typing 'owsctl start admin'), and login as the administrator. Follow these links: - Web Application Server Manager - Oracle Web Listener - Choose the listener you want to monitor, and then click "Configure" - In the left frame, click "Log File" You should see all the information regarding log file generation for this listener. - Scroll down to the section named "Log Information Files" - If you don't have any log already set up, type a filename (e.g. listxxx.log), choose the CLF format for this log, and in the third field, type the following sentence: {clf cs(Referer) cs(User-Agent)} The above sentence tells WAS/OAS to log all the standard CLF fields, and to append to each log record the Referer and User-Agent fields. This is exactly what webalizer expects. - Save the configuration and restart your listener. - However, there's still a thing to do before feeding webalizer with this log. For some obscure reason, WAS/OAS use the TAB character as a field separator of the last two fields (Referer and User-Agent). So, you need to convert this tabs to a single blank. I did this in the following way: cat listxxx.log | tr '\t' ' ' > listxxx.log.clean - I run webalizer with cron, so tha above line can be executed in a shell script that cleans the logfile, and then launches webalizer. That's all. Have fun. Written by Piergiorgio Spagnolatti - piergiorgio.spagnolatti@popso.it