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.
Comments
RSS All comments on ALF: Apache log filter
Privacy note: This form will forward your IP address, user agent and referrer to the Akismet, StopForumSpam and Botscout spam filtering services. I don't log these details. Those services will. I do log everything you type into the form. Full privacy statement.