Apalogretrieve 0.9.6

Apalogretrieve program retrieves data from an Apache logfile with a syntax, that is derived (a subset of) the SQL language.
Apalogretrieve program retrieves data from an Apache logfile with a syntax, that is derived (a subset of) the SQL language.

The idea to make such an implementation came up at 17th of July 2007. I just started it then.

The basic idea of using an SQL-like dialect for logfile-analysis I had many years ago, but as there was no necessity, I didn't started a project like this.

The reason why I started to implement it now is, that the idea about SQL-querying of a logfile was now of interest to me, because I hated the way, how webalizer does it: you have graphical results very easy, but how to make detailed lookups to certain information? And: what about the delay until the (averaging) data can be seen in the graphs, and other problems, when changing a webalizer.conf-file?

So, this was the reason to start it.

As I not every day have the time to implement it, and only do it in a spare time window, it might need some time to make it ready, but reading Apache's common logfile-format as well as parsing simple SQL-like SELECT statements already works (19th of July 2007).

Usage Example:

SELECT host,date FROM "apache-commonlog.log" where size > 2000;
SELECT host,date,client,referrer FROM "apache-commonlog.log" where host = "foobar.host.net";

What's New in This Release:

Reading from gzipped logfiles transparently is possible now.
Output can be redirected to a file.
The output format was changed to aligned ASCII (with blanks between the entries), HTML (table), or LATEX (tabular).
An error was corrected in the documentation and logscanner and language-parser: the Combined Logfile Format is now parsed completely, even with the seldom used fields "logname" and "userid".

last updated on:
January 8th, 2008, 18:44 GMT
price:
FREE!
developed by:
Oliver Bandel
homepage:
www.first.in-berlin.de
license type:
GPL (GNU General Public License) 
category:
ROOT \ Internet \ Log Analyzers

FREE!

In a hurry? Add it to your Download Basket!

user rating 16

3.4/5
 

0/5

Rate it!

Add your review!

SUBMIT