A PHP frontend to apache logs stored with mod_log_sql (aka mod_log_mysql)
Be the first to post a text review of logViewSQL. Rate and review a project by clicking thumbs up or thumbs down in the right column.
I know it has been a long time since this project saw some activity so I have decided that there will be a maintenance release in the next few months. Some changes will include filtering of non-matching table structures to avoid errors, removal of the Register_Globals PHP requirement, small bug fixes and testing with mod_log_sql 1.9+ on Apache 2.
The next release of my log analysis tool for mod_log_mysql has been released. Get it from the download page as there are some very useful additions.
2003-03-20 * Added the custom filtering code to all pages. There are probably issues with sensible filters and this code when sensible filters are switched OFF. * Main summary page now will tell you the total connections after filtering has taken place. 2003-02-24 * Added custom filtering settings and preliminary code. Yet to add to working queries. 2003-02-20 * Spotted bug which caused a division by zero error if there were no entries in tables. Still needs to be tested. (Thanks to foozball for spotting this)
After a long period (due to a few events in my life), there has been a bit of a delay getting this release out. This release adds intelligent table handling, date limiting on results (not global yet), summary stats and a few other enhancments.
2002-11-27 * Expanded main summary screen added - Totals for connections, virus', todays connections, yesterdays connections - Added columns for connections made yesterday and today (to configure this output depending on preference see timeIs24 in the config file) - Added % calculated against virus requests to real requests (note that real requests may still show certain virus requests that look like legitamate requests) 2002-11-16 * Modified date range methods to generate SQL code based on 24hr periods or on a midnight to midnight range (added config option timeIs24) 2002-11-10 * Added methods for creating date ranges 2002-10-28 * Added a summary page that displays the top stats for the current database table * Added the 'Summary' link next to the Search link. This allows you to go to the new summary page * Altered the database navlist with auto submit javascript (don't have to press the 'Go' button any more) 2002-10-22 * Added 3 table based filtering methods for determining if tables meet the minimum fields required for Apache-logViewSQL to work reliably (thanks to Jens for this idea) * Changed the virtual host links to filter based on that host on the main access screen (apache.php)
Be the first person to add a text review.
Copyright © 2009 Geeknet, Inc. All rights reserved. Terms of Use
Thanks for your rating!
Would you also like to write a review?