Apalogretrieve program retrieves data from an Apache logfile with a syntax, that is derived (a subset of) the SQL language.
Version: 0.9.6Apalogretrieve program retrieves data from an Apache logfile with a syntax, that is derived (a subset of) the SQL language.
Operating System: Linux
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).
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".