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

Apalogretrieve Ranking & Summary

Apalogretrieve Tags

log log analyzer Apache analyzer Apache logs retrieve data

Apalogretrieve Description

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".

Apalogretrieve Related Software