Snippet Library

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 :)

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.

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...

got the same problems...

VERSION ERROR:
Problem:
ServerStats requires Mysql version 3.23.23 or above.
Remedy:
Upgrade to a more recent version of Mysql

i use suse 9.2 with mysql 4.0.21

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.

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

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.

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.

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

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.

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:

if (!$_COOKIE["STATS_AUTH_USER"]) {
header("location: index.php");
}

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

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

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.

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

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.

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.

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

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

Hi,

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.

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.