Not a Member Yet,
Click here to Register

ID: 491
Viewed: 37369
Added: Dec 07, 2021
Version: 3.0
Snippet uploaded by: snippet
Written By: Snippet / Torrent
Demo: Sorry, no demo

User Rated at: 4 Stars4 Stars4 Stars4 Stars
Rate This:

Thank you for your vote. Please wait...

It appears you already voted for this snippet

It appears your vote value was empty

Ever wanted to see who enters your site and how? With this program you can do just that. ServerStats is a Real-Time PHP (Apache) Log Analyzer that parses your servers log file to list variable components. It lists IPs, Domains, Referrer's, OSs, Browsers, Pages visited, HTTP Errors, and Unique and Total hits in a nice easy to view page.

Install script included for easy install.
Read the Readme.txt to find out more.

php 7+
mysql 5.x+

// fixes
lots of bug fixes, new robot additions and easier to read layout. Now with graphs!!

// existing users 2.1.7 and up
can update easily, just copy over all files and folders.
found a bug or have something you want added to the stats, report it here

Screenshot 1
Screenshot 2
Screenshot 3
Please do not link from the download.php file. If you must link from this site, do it from this page ONLY. If not, you WILL get a 403 error (access denied). Also, if you have Privacy Control Software installed, you will need to let my site see your reference pages.

Subject: The script bails on lines from virus attacks.
[ Reply ]
Comment By: on 06th of December 2004 07:36 PM

When the script finds a line that does not match the proper form it bails. So on the many virus attempts on my main logs this script fils.

Subject: not a natural log file?
[ Reply ]
Comment By: snippet on 06th of December 2004 07:59 PM

what did you expect? the virus attempts is not part of a default system log. send the line(s) to me if you could and I will see what I can do to check for it. I can't fix it if I don't know about it :)

Subject: database
[ Reply ]
Comment By: on 06th of January 2005 02:18 PM

It's useless, it doesn't support MySQL >4

Subject: mysql support
[ Reply ]
Comment By: snippet on 06th of January 2005 05:52 PM

read again, serverStats supports from mysql 3.23.23 to mysql 4.0+. I have it running on mysql 4.x right now on this server, no problems. let me know what problems you have and maybe we can determine what the issues is. don't automatically say it doesn't support something without reading or asking.

Subject: Problem with MySQL
[ Reply ]
Comment By: Sander on 01st of February 2005 12:28 PM

I have the nem XAMMP (A complete server package with MySQL 4.1.x) and i says that I don't have the proper MySQL version. Gues it's a version problem then huh...

Subject: sql problems
[ Reply ]
Comment By: basti on 04th of February 2005 10:39 PM

got the same problems...

ServerStats requires Mysql version 3.23.23 or above.
Upgrade to a more recent version of Mysql

i use suse 9.2 with mysql 4.0.21

Subject: Mysql Versions
[ Reply ]
Comment By: Snippet on 04th of February 2005 11:34 PM

well, I have issues with 4.0+ since it came out. I guess I wil have to take the check out as it is unpredictable as to what version it comes back with.

sorry for the confusion. new version uploaded.

Subject: invalid default value for 'id'
[ Reply ]
Comment By: Wohtohai on 24th of April 2005 09:09 AM

I am getting this error
Invalid default value for 'id'
Check that tables stats_login does not exist from a previous installation
Environment: Win 2k Server, Apache 2, php 4.1, mysql 4.1.8
Username, password, and db name in mysql has been checked and rechecked. Any help is appreciated. Thanks.

Subject: mysql error
[ Reply ]
Comment By: snippet on 24th of April 2005 10:01 AM

what did you change? are you install it over an existing installatiion? if not try deleting the tables and try again.

Subject: invalid default value for 'id'
[ Reply ]
Comment By: Wohtohai on 24th of April 2005 05:50 PM

No changes made to your script, fresh install gives that error. MySQL gives error on "id smallint(6) DEFAULT '0' NOT NULL auto_increment". Recreated this error using phpMyAdmin and I got this result "#1067 - Invalid default value for 'id' ". If I remove DEFAULT '0' it creates the table. stats_login. Also I got error in $stTblA on " FULLTEXT KEY stats_referrer (stats_referrer)". SQL from phpMyAdmin is "MySQL said: #1214 - The used table type doesn't support FULLTEXT indexes". Thanks.

Subject: Re: invalid default value for 'id'
[ Reply ]
Comment By: snippet on 24th of April 2005 08:41 PM

thank you for the update. I have made some changes and a new version is out. the main problem is your table setup is not MyISAM by default. fulltext will only work in MyISAM table types. I have made it so this is installed with it. please let me know if you have any problems with the new version.

Subject: Im not able to download it
[ Reply ]
Comment By: Vips on 27th of April 2005 11:46 AM

can some one help me to download it

Subject: unable to install
[ Reply ]
Comment By: on 29th of April 2005 09:34 AM

It is recommended that you turn register globals to Off. You have them ON and this script and the serverStats script might not work properly. FILE ACCESS ERROR:
Unable to create config_inc.php file for writing
Ensure ServerStats has write access to the installation folder.

Subject: Re: unable to install
[ Reply ]
Comment By: snippet on 30th of April 2005 07:49 AM

you have to chmod the folders so serverStats has permissions to write to it. read the readme.txt file.

Subject: redirect loop
[ Reply ]
Comment By: on 10th of May 2005 10:31 AM

I'm having trouble with a redirect loop. I think it's caused by a bad check against the cookies, because after bypassing the login all went well. I've commented out the following

header("location: index.php");

Also the countries don't work for me. Ideeas?

Subject: Re: redirect loop
[ Reply ]
Comment By: snippet on 10th of May 2005 04:45 PM

how can that be bad? it is a default cookie by the server. what error ar eyou getting? maybe you don't accept cookies in your browser.

if countries don't work than I suspect that means your log format is not of the correct configuration. I have never heard of countries not working. what exactly is not working on the countries?

please email me.

Subject: Redirect loop
[ Reply ]
Comment By: Andrei Neagoe on 11th of May 2005 06:01 AM

Ok... I've found your problem. You set the cookie with the following lines in admin_login.php:

setcookie("AUTH_USER", $useradmin, time()+3600 ,"/");
setcookie("AUTH_PASS", $pass, time()+3600 ,"/");

but you check for it in stats.php with:

header("location: index.php");

when you should actually check for AUTH_USER and not for STATS_AUTH_USER.

Subject: Re: Redirect loop
[ Reply ]
Comment By: snippet on 11th of May 2005 06:11 AM

yes, you are correct. I missed that setting. I have made the changes and they reflect in the next version. my aplogies.

Subject: great script
[ Reply ]
Comment By: seocunsultant on 15th of May 2005 03:18 PM

Great script even I haven't test it yet.

Subject: cool
[ Reply ]
Comment By: Budi on 22nd of June 2005 05:29 AM

cool script

Subject: Problem
[ Reply ]
Comment By: Tariq on 03rd of August 2005 11:09 PM

It says:

Warning :
You don't have any data to process. Please click on "Update Now" link to make the data.

So I click "Update Now", then it says:

This script can't find the log file to process. Make sure you gave the correct
path or you put the log file in the same directory as this script.
Please fix the path or put the file in this directory and then push Refresh in your browser.

Which log file do I need to replace? Or where do i change the path?


Subject: Re: Problem
[ Reply ]
Comment By: snippet on 04th of August 2005 05:34 AM

the log file is your access.log file. you set this in the config file. did you run the install? you shoudl have seen this.

Subject: help downloading
[ Reply ]
Comment By: chad on 20th of August 2005 01:40 PM

I cannot download this ...403 error

Subject: Re: help downloading
[ Reply ]
Comment By: snippet on 20th of August 2005 01:57 PM

you have to click on the zip file above. you cannot go any other way.

Subject: Problem with install.php
[ Reply ]
Comment By: Daniel on 25th of August 2005 07:00 AM


When I submit install.php I am redirected to /cgi-bin/php4-fcgi-starter

Im running PHP with fastcgi in a jailed System. Other applications do work, no problems so far. What could be the problem?


Subject: Re: Problem with install.php
[ Reply ]
Comment By: snippet on 25th of August 2005 04:46 PM

That is a good one. I do not go by any directory listing except load the stat file. if you have rediect problems than it would be the server not the script. although you are the first to use it with fastcgi I do not have a answer for you at this time.

what part of the install do you have problems on? does it go all the way? does the database tables get written? feel free to email me on the contact page if you wish to discuss it further.

Subject: jsp script for the same
[ Reply ]
Comment By: rohit on 27th of September 2005 03:17 AM

Please provide this particular script in jsp mail me at:

Subject: Re: jsp script for the same
[ Reply ]
Comment By: snippet on 27th of September 2005 05:54 AM

for one can jsp connect to mysql? if so I do not know jsp. you write one and give it to me and I will give you full credit and dispaly it here.

Subject: No config file
[ Reply ]
Comment By: annelions on 06th of October 2005 09:47 AM

I downloaded this and tried to install it, but there is no config_inc.php file as stated on line 29 of index.php:

Subject: Re: No Config file
[ Reply ]
Comment By: snippet on 06th of October 2005 06:11 PM

yes you are very correct. that is why you have to run the install.php and it will create it.

Subject: MySQL_probs again
[ Reply ]
Comment By: Michele on 10th of November 2005 02:05 AM

snippet wrote:
> serverStats supports from mysql 3.23.23 to mysql 4.0+.

Installation went fine, MySQL-Tables have been created, but when I run "Update now" I get

>Database error:
>Invalid SQL: LOAD DATA LOCAL INFILE '200511.txt' INTO TABLE stats
>mysql error: The used command is not allowed with this MySQL

PHP Version 4.3.3, MySQL 4.0.15-Max on SuSE Linux 9

What the hell have I done wrong :( ;)


Subject: MySQL_probs again
[ Reply ]
Comment By: snippet on 10th of November 2005 05:52 PM

Please read the readme file that came with the script. just because you have mysql 4.0.15 doesn't mean the client is the same version. if it is then you don't have permission to run it or mysql has not been compiled to use that command.

FRom Mysql:

In MySQL 3.23.49 and MySQL 4.0.2 LOCAL will only work if you have not started mysqld with --local-infile=0 or if you have not enabled your client to support LOCAL. See section

Subject: Great for one site, what about multiple URL's?
[ Reply ]
Comment By: RecentCoin on 14th of September 2006 10:59 AM

I'd like to say that this works amazing well for one site, I manage several and I'd like to be able to do a couple of things.

1) automate (via cron) the adding of the logs to the database. This will mean adding a variable that lets me specific the log file path, as well as handling some wild card/multiple file names so that I don't miss anything due to log rotation

Subject: Thank you
[ Reply ]
Comment By: snippet on 14th of September 2006 05:20 PM


It is impossible to have the script do more than one domain at a time. The script is only programmed to read one access.log file per domain. Not saying you can't upload others to the stats directory and update the database with that. But programming it to do more than one is impossible as I can't read file paths to other servers. Unless maybe they are on the same server.

i will look into the cron job, i like that idea as well.

Subject: Can't read log file
[ Reply ]
Comment By: paipals on 22nd of November 2006 03:14 AM

I configured location correctly and even tried copying access.log into directory where script is located but still same "This script can't find the log file to process. ....".
During install I noticed message "You are working with MySql 5.0.24a-standard-log, make sure it is greater than 3.23.23 or serverStats will not work."
Does this mean it can't read log of 5+?

Subject: Re: Can't read log file
[ Reply ]
Comment By: snippet on 22nd of November 2006 06:19 AM

It has nothing to do with mysql, the access.log file has to be in the same folder as the script for it to work. Make sure you only put the log file name in the config file then it should work. again you are not parsing a mysql log but a Apache log. big difference.

Subject: Nice tool
[ Reply ]
Comment By: john a t benden d o t co d o t uk on 10th of February 2007 01:36 AM

Good tool, however get upset with large log file volumes (like everything else I guess). It might be worth having summary tables that are updated in the update.php stage, keeps the stress off the mysql server !

Please completely fill out the form below if you want to review this snippet. All reviews are subject to validation.

Replying to a Comment...

Adding your comment. Please wait...

Thanks for adding your comment!. After further review it will be added.

There was a problem adding your comment. Please try again.

Please complete all the fields in the form before sending.

© 2002 - 2024 All Rights Reserved. Conditions
Do NOT follow this link or you will be banned from the site!