Home :: Apache-logViewSQL
2004-09-28 - Almost 2 years after the last message I've updated the site.
Currently I have removed the restrictions to running php with the registerglobals,
fixed a few bugs and will be adding a few extra table checking features.
Future enhancements will probably involve integration with with some Authentication mechanisms to limit
table views (ideal for ISP accounts) and more detail in the drill down view.
Currently I have done the following
2002-09-30 - First release of Apache-logViewSQL get the pre-alpha
- Fixed some menu links
- Removed register globals requirement for PHP
- Verified against current versions of PHP, and the mod
- Added extra details for individual links
Current version screenshot (28/09/2004)
This is my first serious PHP/MySQL project and it involves
interfacing with logs created using mod_log_mysql.
It relies on the user choosing to use this apache module with the MassVirtualHosting directive with
MySQLCreateTables enabled. Of course it will work without these directives/module IF the database has the
following format: Format to be shown.
To this end it is possible to create a perl script that will convert apache logs into this database
format for use by this project. If there is enough demand I may provide a sample script to do this.
screenshot of pre-alpha table
Currently the pre-Alpha interface does the following:
Log database view
Table space view
- Provides a list of all database tables belonging to the logging process (i.e. in an environment with
multiple tables acting as multiple logs)
- Summary of total connections/4xx type errors/Total transferred/last request time:date and the
number of attempted virus hits from each log table
- Number of unique status recorded in this log
- Number and name of (virtual)hosts serviced by the log
- Number of unique remote hosts
- Host with the most requests
- Country code of remote host
- Summary of last 10 connections including requestURI, host address, status returned, bytes sent and
date/time it occured
- Number of requests
- Remote host
- First request from host
- Last request from host
- Request URI
- Status returned
- Bytes sent
- Request time
|MySQL (tested with 3.23)
PHP (tested with 4.1.2)
mod_log_sql style databases (tested with mod_log_sql 1.16)