InternetOfficer.com

Hi

 We've recently started using Awstats to analyse logfiles on our clustered servers. All is working fine except when the merged log file from the 2 servers is created using the logresolve tool I have to paste the following at the top of the merged log file for Awstats to proces the log:

 #Software: Microsoft Internet Information Services 6.0
#Version: 1.0
#Fields: date time cs-method cs-uri-stem cs-uri-query cs-username c-ip cs-version cs(User-Agent) cs(Referer) sc-status sc-bytes

This means that I cannot set up a scheduled task to run the job automatically, which is a shame!

Has anyone any ideas which might help?

 Cheers in advance

 Jim

Jean-Luc

Thank you very much for your quick reply!

This has done the trick!

I no longer need to paste that information into the combiuned log which means I can now automate the process and save myself lots of time.

Thank you very much for your help, I'm very grateful.

Cheers

Jim

You write that you use: 

This LogFormat does not match the fields specification in your first post:

For example, according to your first post, the field after the date and time is cs-method  which AWStats calls %method.

Did you try the LogFormat I suggested ?

At the end of the database update, AWStats prints a report like this one:

Create/Update database for config "/path_to_awstats/awstats.my_domainconf" by AWStats version 6.7 (build 1.892)
From data in log file "/path_to_log_file/log_file_name"…
Phase 1 : First bypass old records, searching new record…
Searching new records from beginning of log file…
Phase 2 : Now process new records (Flush history on disk after 20000 hosts)…
Jumped lines in file: 0
Parsed lines in file: 3693
 Found 520 dropped records,
 Found 12 corrupted records,
 Found 0 old records,
 Found 3161 new qualified records.

This information helps understand what happened when there is a problem.

Jean-Luc

In batch files, the percent sign is a special character.

Try to replace each percent sign by two percent signs, like this:

Jean-Luc

Two questions:

1. What error message did you get first with D:/LogFiles/W3SVC1725568973/ex%YY-0%MM-0%DD-24" ?

2. What is the complete line calling logresolvemerge.pl   in your batch file ?

Jean-Luc

Did you replace all six original percent signs (% => %%) in the command line ? The .bat  file should contain:

At execution time, this should give:

And logresolvemerge.pl  should then replace %YY-0, %MM-0,… by the appropriate values.

Can you try again and let me know how the command looks like at execution time (ie. when you run the batch file). Thank you.

Jean-Luc

Jim,

It's getting clear ! The point is that logresolvemerge.pl  is not processing file names like awstats.pl  does.

You cannot use these %YY-xx%MM-xx%DD-xx  with logresolvemerge.pl. I am afraid you will have to use tricks around the DATE function in the batch file to automate things as you want.

Also note that %YY-0%MM-0%DD-24  is not going to do what you expect. On January 1, 2008, %YY-0%MM-0%DD-24  will return 080131. You should use %YY-24%MM-24%DD-24  that would return 071231.

Jean-Luc