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.
- Mysql DB Support
- PHP Web-Based Monitoring
- Formated Reporting
- Live Updating Via Cron
- On Demand Updates Via The Web
- Best Of All Its FREE
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
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.
- 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 openwebstats.zip
Latest Releases:- http://sourceforge.net/project/showfiles.php?group_id=143030
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.