Current User: Guest Login
Please consider registering


Lost Your Password?

Search Forums:


 






Minimum search word length is 4 characters – Maximum search word length is 84 characters
Wildcard Usage:
*  matches any number of characters    %  matches exactly one character

Log File Input in AWStats…

Reply to Post Add a New Topic
UserPost

8:20 am
December 18, 2009


x-plicit2009

Member

posts 14

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 1125

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

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 1125

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

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

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

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 1125

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

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 1125

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

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

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

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

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

posts 14

Got it working in the cgi.

Reply to Post

Reply to Topic:
Log File Input in AWStats…

Guest Name (Required):

Guest Email (Required):

NOTE: New Posts are subject to administrator approval before being displayed

Smileys
Confused Cool Cry Embarassed Frown Kiss Laugh Smile Surprised Wink Yell
Post New Reply

Guest URL (required)

Math Required!
What is the sum of:
4 + 6
   


About the InternetOfficer.com Forum

Forum Timezone: UTC 1

Most Users Ever Online: 302

Currently Online:
8 Guests

Currently Browsing this Topic:
1 Guest

Forum Stats:

Groups: 2
Forums: 9
Topics: 638
Posts: 2709

Membership:

There are 257 Members
There have been 302 Guests

There is 1 Admin
There is 1 Moderator

Top Posters:

cssfsu – 55
deepakgupta – 34
albert_newton – 30
cosminpana – 20
DTNMike – 19
ahtshun83 – 17

Recent New Members: raju, todd2taylor, sbdcunha, mansigill1987, ThomasDuh, ThomasKic

Administrators: Jean-Luc (1125 Posts)

Moderators: Jean-Luc (1125 Posts)