IIS6 log formats, cant get it working...

IIS6 log formats, cant get it working…

Print this Post

Page: 1

Reply to Post

Add a New Topic

User

Post

3:28 am
October 17, 2008

Henrik Sandeberg

Guest

Quote and Reply

Print this Post

Hi,

I cant get my log file working, i have th following string in awstats.conf:

#Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status

How should i write it in the awstats.conf, because when i run it, it will come an error that says i dont have %sdbytes in it. But I dont have that check in my IIS config.

Anyone?

3:33 pm
October 17, 2008

Jean-Luc

Admin

posts 1063

Quote and Reply

Print this Post

Hi,

Your log format is not compatible with AWStats. You need to add the sc-bytes (%bytesd ) field to make it compatible.

In the mean time, you can try to use :

LogFormat=”%time2 %other %other %method %url %query %other %logname %host %ua %code %other %bytesd”

The value of %bytesd will not be real and the bandwidth and other data related to the number of bytes will be wrong in the AWStats reports, but all other data (visitors, pages, hits,…) in the reports will be valid.

7:45 am
November 11, 2008

Henrik Sandeberg

Guest

Quote and Reply

Print this Post

Hello again, i get it working, but now i want to have this fields, can you help me with this one too, please:

#Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) cs(Cookie) cs(Referer) sc-status c-substatus sc-win32-status sc-bytes cs-bytes time-taken

I found it hard to get the right values in the awstats.coonf file.

Please help me, only one more time.

Regards Henrik Sandeberg

8:03 am
November 11, 2008

Jean-Luc

Admin

posts 1063

Quote and Reply

Print this Post

Hi Henrik,

Try this :

LogFormat = "%time2 %other %other %method %url %query %other %logname %host %ua %other %referer %code %other %other %bytesd %other %other"

9:10 am
November 11, 2008

Henrik Sandeberg

Guest

Quote and Reply

Print this Post

Thanks, it worked, but i have one more problem, and thats my Google server which doesnt shows up as a host. It has a 10.199.x.x IP adress. I can see the server in the logfile, but awstat doesnt show it in the logged hosts.

Regards

Henrik

9:23 am
November 11, 2008

Jean-Luc

Admin

posts 1063

Quote and Reply

Print this Post

If iit is not excluded in SkipHosts , I guess that it uses a user agent that AWStats considers as belonging to a robot and not to a visitor. Check the user agent and edit the robots.pm file accordingly.

1:28 am
November 12, 2008

Henrik Sandeberg

Guest

Quote and Reply

Print this Post

Ok, thanks, i will check it out. We dont have it in the skipHosts.

2:05 am
May 8, 2009

Henrik Sandeberg

Guest

Quote and Reply

Print this Post

Hello again, i have one question,

How can i check that my order of logformat is correct, i mean if i have typed in wrong order will the logfile show wrong data then? in awstat?

Are there anywhere i can read about the order of the logfile, i find it hard to change it.

I have this logfile now:

date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) cs(Referer) sc-status c-substatus sc-win32-status sc-bytes cs-bytes time-taken

Could you help with it, i have removed the cs (cookie) cause the logfiles grown too big. Or can i just "take away" one %other?

Regards

Henrik

2:56 am
May 8, 2009

Jean-Luc

Admin

posts 1063

Quote and Reply

Print this Post

Hello Henrik,

If the AWStats LogFormat parameter does not match the format defined in the #Fields: line, AWStats will not "understand" the log file: either it will give an error message or it will generate invalid statistics.

For the log file you have now, use:

LogFormat = "%time2 %other %other %method %url %query %other %logname %host %ua %referer %code %other %other %bytesd %other %other"

7:16 am
May 28, 2009

Roumania

Guest

Quote and Reply

Print this Post

Hello World,

In order to complete this post, il have the same issue when i try to analyse IIS 6 log file, i explain :

I have an error regarding %sdbytes in my log format and i understood that i need to include sc-bytes in my log format.

In my IIS 6 log file, i have now :

#Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) cs(Referer) sc-status c-substatus sc-win32-status sc-bytes

and in my awstat conf file, i put :

LogFormat= "date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) cs(Referer) sc-status c-substatus sc-win32-status sc-bytes"

When i run my cmd file, i have this error now :

Jumped lines in file: 0
Parsed lines in file: 15276
Found 1 dropped records,
Found 15275 corrupted records,
Found 0 old records,
Found 0 new qualified records.

I dont know what to do now

could you please help me ?

7:39 am
May 28, 2009

Jean-Luc

Admin

posts 1063

Quote and Reply

Print this Post

Hi,

I would try this:

LogFormat = "%time2 %other %other %method %url %query %other %logname %host %ua %referer %code %other %other %bytesd"

Page: 1