Skip navigation

Charlie Harvey charlieharvey.org.uk babylon's burning.

| Back to navigation

Pages

Index / Geekery / ALF: Apache log filter

Permalink

ALF: Apache log filter

ALF is a filter for people using Apache logging to plain text logs, who still want the flexibility of being able to search their logs like a database. It relies heavily on Jeff Zucker's DBD::AnyData to do the clever stuff, and overlays that with a simple Gtk2 interface.

You can run SQL queries and see the results in horizontal or vertical formats; open different logs; run a few everyday queries from buttons; append column names to your SQL from a dropdown box; switch between parser formats; and export your filtered results in vertical or horizontal formats.

You'll need to copy WeblogCombined.pm and WeblogVhost.pm into /path/to/AnyData/Format before ALF will play with you. AFAICS WeblogVhost.pm ought to work on all three types of logs but I don't have common format logs available to test on.

Screen shot of ALF interface

Reactions

Tweet it: 44 | Digg it: 44

Author: Charlie Harvey

Updated: 2010-08-09T15:17:50