Log File Input in AWStats...

Log File Input in AWStats…

Print this Post

Page: 1

Reply to Post

Add a New Topic

User

Post

8:20 am
December 18, 2009

x-plicit2009

Member

posts 14

Quote and Reply

Print this Post

Hi There,

I have a log file…displayed as:

25-OCT-2009 19:29:46 * 10.65.4.16
25-OCT-2009 19:29:47 * 10.65.4.22
25-OCT-2009 19:29:48 * 10.65.4.88
25-OCT-2009 19:29:53 * 10.65.4.22

In the begging it has a space, and between date, time, * and Ip. I also have it in another format that is xml and compressed.

How can i describe my data to AWStats?

Regards,

9:14 am
December 18, 2009

Jean-Luc

Admin

posts 1042

Quote and Reply

Print this Post

Hi,

This log format is not compatible with AWStats. The date-time field is not in a format recognized by AWStats and several mandatory fileds are missing (URL, status code, number of bytes,…).

8:09 am
December 21, 2009

x-plicit2009

Member

posts 14

Quote and Reply

Print this Post

Is there any going around this issue? The date can be changed but the mandatory data i dont have, can it be empty?

9:22 am
December 21, 2009

Jean-Luc

Admin

posts 1042

Quote and Reply

Print this Post

I never tested this kind of log files, but I believe that you need at least the following:

- a date and time field (%time2 is close to what you have, but slightly different)

- an unused field (%other could be your * field)

- a host field (%host is your IP address field)

- a URL field (%url could be /)

- a status code field (%code could be 200)

- the number of bytes (%bytesd could be -)

A typical line to be processed would be:

2009-10-25 19:29:46 * 10.65.4.16 / 200 -

and your AWStats config file would include:

LogFormat="%time2 %other %host %url %code %bytesd"

9:50 am
December 21, 2009

x-plicit2009

Member

posts 14

Quote and Reply

Print this Post

Thanks very much for the feedback….

My goal for using awstat is to count the number of connection in a time frame, without, will it still produce the reports i need?

Look foward from hearing some advice….

Regards

9:55 am
December 21, 2009

x-plicit2009

Member

posts 14

Quote and Reply

Print this Post

I also have the files in another format…in XML, perhaps it is possible to use this as an input? I dont know exactly if it matches the ones that AWSTAT accepts…its a log file from oracle…

As a sample:

<msg time='2009-10-14T05:46:59.435+00:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='mtdb_a'
host_addr='UNKNOWN'>
<txt>14-OCT-2009 05:46:59 * (CONNECT_DATA=(SID=fgs)(CID=(PROGRAM=oracle)(HOST=whatever)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.112.4.24)(PORT=47455)) * establish * fas * 0

</txt>

</msg>

5:49 am
January 4, 2010

x-plicit2009

Member

posts 14

Quote and Reply

Print this Post

Hello,

I have tried to create this test data, but am getting an error when following the manual to do:

perl awstats.pl -config=mysite -update

The error says: to use %method or %methodurl in the logformat string and can also be settings of the conf file. I used it the way in the same way you put it here in the forum.

Looking foward for some feedback.

8:50 am
January 4, 2010

Jean-Luc

Admin

posts 1042

Quote and Reply

Print this Post

This message means that the %method field is mandatory. A valid value for %method is GET.

9:52 am
January 4, 2010

x-plicit2009

Member

posts 14

Quote and Reply

Print this Post

Hello, Thanks for the answer, i am trying to install AWStats… is nmake, and apache all needed?

Regards

1:34 pm
January 4, 2010

Jean-Luc

Admin

posts 1042

Quote and Reply

Print this Post

There is no need to use nmake or Apache to run AWStats under Windows. awstats.pl is a Perl script that you can run from the command line. You can use it to read the log file and generate the AWStats data files, then you use it to generate the static HTML reports that you will be able to view through a browser.

3:00 am
January 5, 2010

x-plicit2009

Member

posts 14

Quote and Reply

Print this Post

How can i run it against a log file with the file with LogFormat="%time2 %other %host %url %code %bytesd" and get the reports, where is it sent to?

Regards

3:04 am
January 5, 2010

x-plicit2009

Member

posts 14

Quote and Reply

Print this Post

I am having some difficulty in configuring the website, could you please give me some guidlines..

Regards

4:10 am
January 5, 2010

x-plicit2009

Member

posts 14

Quote and Reply

Print this Post

Hello, it is working. But now the reports i am getting, are not what i need i have some ip adresses and need it to count them, does awstat count ip hosts? In my log file i have a date attached to a ip adress, all other data is random.

Regards

8:38 am
January 5, 2010

x-plicit2009

Member

posts 14

Quote and Reply

Print this Post

Dear All, the ip adresses are being counted, but how can i for example access and display log data from last year?

Regards

11:10 am
January 7, 2010

x-plicit2009

Member