OpenWebStats - PHP Web Stats for Everyone

Open-Creations Demo Features Configure Requirements Download Support Live Support

OpenWebStats is a php stats application that reads apache log files and imports the data to a mysql db. Then you have a awstats style reporting tool so you can review stats on demand from the database. Stats updates are available through cronjobs or through the web interface.
Inspired by AWstats, OpenWebStats aims to be your one stop shop for web stats through php. OpenWebStats was designed to be easily installed on any Apache webserver running php and mysql. The current version has been tested on Fedora Core 1-3 and Redhat Advanced Server. It has also been tested using mysql 3.23 -4.1. If you are interested in testing the script on a windows platform please let us know. This application is brought to you by David Mathews of Open-Creations.com. If you are in need of assistance or would like to tell us how you are using our product please let us know.

Features:

    - Apache Log File Reader
    - Mysql DB Support
    - PHP Web-Based Monitoring
    - Formated Reporting
    - Live Updating Via Cron
    - On Demand Updates Via The Web
    - Best Of All Its FREE

Configure:

1. Edit the config.php file giving your db info and log file locations
    Note: Make sure you can read the logfiles and have created a db for the database
    Database information variables:
       $databaselocation = 'localhost';
       $databaseport = '3306';
       $databasename = 'testdb';
       $databaseuser = 'testuser';
       $databasepass = 'testpass';
    And for the webdir, logfile, and logformat:
       $openstats_web_dir = '/openwebstats';
       $logfile = "/etc/httpd/logs/access_log";
       $logformat = ""; //example: $logformat = logformat_combined_vhost;

2. Import the db table sturcture via openwebstats.sql
    Example: mysqlimport -h yourhost -u youruser -pyour_pass databasename openwebstats.sql
    Example2: mysql -h yourhost -u youruser -pyour_pass databasename < openwebstats.sql

3. Test the setup:
    shell: php class_apache_logs_import.php
    browser: http://yourserver.com/yourpath/openwebstats/class_apache_logs_import.php
    If all goes as planned and no errors you can move on otherwise check the errors
    and try to fix them. Check the FAQ or Help/Troubleshooting.

4. Set your crontab to allow the updating of the db
    Example: 59 * * * * /usr/bin/php /$yourpath/openwebstats/class_apache_logs_import.php >/$yourpath/openwebstats/apache_log_import.log 2>&1

5. Set your browser to the location of the stats dir there you go.
    You can also test that the web update works by clicking the "Stats Update Now" link.

Requirements:

    - Server Tested on Apache/1.3.12 (Unix)
    - PHP >= 4.1.2
    - MySQL (tested with 3.23.23 and above)
    - Must have the read priviledge to the logfile on the server host in order to use this script
    - A web-browser

Download Latest Version:

- Download openwebstats-1.1.tar.gz
- Download openwebstats.zip

Latest Releases:

- http://sourceforge.net/project/showfiles.php?group_id=143030

Support:

If you are having problems getting OpenWebStats setup, the first place to look is the README file in the archive.

If you are still having difficulty installing or configuring OpenWebSats, you can post a message to the Help/Troubleshooting forum hosted on SourceForge.net. Typically, forum postings get a response within anywhere between a couple of hours to a day or two.

If you think you may be encountering a bug in OpenWebStats, take a look at the Bugs listed on SourceForge.net. Note that you can enter a keyword and search the bug database at the top of the form on that page. If you do not find a match then please enter the new bug information into the system and we will get it resolved.