Monday, March 19, 2007

Reading Apache Access Logs

There are many scripts out there that read the Apache access log. More recently Jesse Kornblum posted his script for parsing the logs for search queries. Well here is my attempt at doing this, as always there is a database involved.

All this script does is read in the apache log file, parse it and save it to the database. You can then write sql to get back the data for you, IE:

select * from apache_log where access_dttm = '10/Mar/2007';

Now to run the program just type access_log. The program and table creates can be downloaded here.

For users of X-ways Forensics you can define this program as an external program and load the database right from x-ways as you are doing your analysis. Just make sure you change the spot where your database points to.



Anonymous said...

Well, what does it all mean? Simply put, an illegal Viagra UK hawker, who provides you nothing about the drug mechanisms, benefits, side effects, dosages, storage information and other vital information that are a 'must-know' for a Viagra online user can occupy the top rank in Viagra pills search for google, yahoo or msn, by employing the search engine optimization techniques. said...

Hey, there's a lot of helpful information here!

sports handicapping software said...

Wow, nice post,there are many person searching about that now they will find enough resources by your post