Author Topic: moved:INSTALLING ZITROSTATS HELP (Read 22873 times)

MR X · « **on:** June 10, 2006, 10:46:54 am »

i have downloaded zitrostats. and i want to run it on my own pc.
i dont know where to get started. ive read the installation guide in zitrostats homepage. but i still dont get it. can somebody help me to install zitrostats completely including mysql and php.
very much thx if you can.shortoff im a php mysql noob

Greetzzz MR X.

KeFear · « **Reply #1 on:** June 11, 2006, 02:32:40 am »

First you need a webserver with php and a mysql server. If you are using windows and don't have any of the above, try EasyPHP (http://easyphp.org/). It's simple to install and has everything you need. If you are using linux (which i doubt) then read the manuals about your distro on how to install apache, php and mysql.
After you are ready installing apache+php+mysql you can install zitro stats according to the installation guide.

MR X · « **Reply #2 on:** June 11, 2006, 04:42:52 am »

ok ill try easyphp. ive windows.

MR X · « **Reply #3 on:** June 11, 2006, 05:43:29 am »

ok ive installed it what to do next with all the zitrostats files

thanx for helping anyway.

MR X · « **Reply #4 on:** June 11, 2006, 06:01:45 am »

ok ive easyphp installed ive rightclicked the icon of easy php then ive clicked on configuratie(thats dutch for configuration) and then on phpmyadmin.then ive clicked on mysql on the left in the php myadmin window and ive clicked then on the tab SQL in the middle of the window. then ive clicked on bladeren(dutch for browse) and then ivepicked the msql file:install. then ive clicked on openen(dutch for open). then i get e message of mysql succesfull imported (or something like that). and then i get this stuff on the left below the word mysql:
${prefix}clans
${prefix}clantags
${prefix}killlog
${prefix}logs
${prefix}options
${prefix}playerdeathweapons
${prefix}playerkillweapons
${prefix}playeropponents
${prefix}players
${prefix}serverdays
${prefix}serverhours
${prefix}servers
${prefix}weapons

thats all.
i think i have done this right right?
whats the next step?

KeFear · « **Reply #5 on:** June 11, 2006, 08:37:09 am »

No. you should move all the zitrostats files to a folder of your webserver (by default "C:\Program Files\EasyPHP\www\")
1. make a folder for zitrostats, copy all the files there,
2. then open your browser,
3. type "localhost/zitro" (replace zitro with the folder name you made in the 1. step)
4. zitro installation should start and should ask you some questions that you must answer (or not, i have never used zitrostats)
5. if installation didn't start, then you should type "localhost/zitro/install.php" in your browser.
6. installation finished, you are happy now.

PS: don't forget to read the installation manual for zitro stats, i'm pretty sure all the steps are written there.
PS2: learn to use the "Modify" button on the forums and don't make double/tripple posts.

MR X · « **Reply #6 on:** June 11, 2006, 01:00:01 pm »

Ok very mutch thanx Kefear your great!!!

. and i now now that you can edit your posts on this forum Â

. btw your ARSSE program rulezz!!!

Greets

MR X

KeFear · « **Reply #7 on:** June 11, 2006, 02:15:33 pm »

You are welcome, and thanks, but ARSSE is far away from perfect, it really needs some bugfixes, improvements and optimalization

But that's a bit off-topic now.

MR X · « **Reply #8 on:** June 11, 2006, 02:27:27 pm »

One question then. when i run install.php i get a bunch of error messages:

Warning: mysql_connect(): Toegang geweigerd voor gebruiker: 'Jules'@'localhost' (Wachtwoord gebruikt: JA) in c:\program files\easyphp1-8\www\config.inc.php on line 48

Warning: mysql_select_db(): Toegang geweigerd voor gebruiker: 'Jules'@'localhost' (Wachtwoord gebruikt: JA) in c:\program files\easyphp1-8\www\config.inc.php on line 49

Warning: mysql_select_db(): A link to the server could not be established in c:\program files\easyphp1-8\www\config.inc.php on line 49

Warning: mysql_query(): Toegang geweigerd voor gebruiker: 'Jules'@'localhost' (Wachtwoord gebruikt: JA) in c:\program files\easyphp1-8\www\config.inc.php on line 52

Warning: mysql_query(): A link to the server could not be established in c:\program files\easyphp1-8\www\config.inc.php on line 52

Warning: mysql_close(): no MySQL-Link resource supplied in c:\program files\easyphp1-8\www\config.inc.php on line 106

Warning: mysql_connect(): Toegang geweigerd voor gebruiker: 'Jules'@'localhost' (Wachtwoord gebruikt: JA) in c:\program files\easyphp1-8\www\install.php on line 5

Warning: mysql_select_db(): Toegang geweigerd voor gebruiker: 'Jules'@'localhost' (Wachtwoord gebruikt: JA) in c:\program files\easyphp1-8\www\install.php on line 6

Warning: mysql_select_db(): A link to the server could not be established in c:\program files\easyphp1-8\www\install.php on line 6

Warning: mysql_list_tables(): Toegang geweigerd voor gebruiker: 'Jules'@'localhost' (Wachtwoord gebruikt: JA) in c:\program files\easyphp1-8\www\install.php on line 8

Warning: mysql_list_tables(): A link to the server could not be established in c:\program files\easyphp1-8\www\install.php on line 8

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\program files\easyphp1-8\www\install.php on line 9

Warning: mysql_query(): Toegang geweigerd voor gebruiker: 'Jules'@'localhost' (Wachtwoord gebruikt: JA) in c:\program files\easyphp1-8\www\install.php on line 24

Warning: mysql_query(): A link to the server could not be established in c:\program files\easyphp1-8\www\install.php on line 24
Error installing: Toegang geweigerd voor gebruiker: 'Jules'@'localhost' (Wachtwoord gebruikt: JA)
The MySQL Query was:CREATE TABLE `u13sss`.`test_settings` (`item` VARCHAR( 150 ) NOT NULL ,`value` VARCHAR( 255 ) NOT NULL ,PRIMARY KEY ( `item` ));

Toegang geweigerd voor gebruiker means Acces denied for user.
there comes a file with the program named config.inc
and this is a part of it:<?PHP
//-----------------------------CONFIGURATION-----------------------------------------
//------------------------------CHANGE THESE-----------------------------------------

//WEBSITE CONFIG - If these locations are not in the directory immediately above /u13sss, absolute paths are necessary.
$weaponpage='statsweapon.php';         //The name of the page containing statsweapon.php
$playerpage='statsplayer.php';         //The name of your page containing statsplayer.php
$top10page='top10.php';               //The name of your page containing the top10.php
$activatepage='activate.php';         //The name of your page containing activate.php

//MYSQL CONFIG
$mysqlserver='localhost';            //MySQL server address
$mysqlserverport='3306';            //MySQL server port
$mysqlusername='Jules';                     //MySQL username
$mysqlpassword='Paradox';                     //MySQL password
$mysqldatabasename='u13sss';         //MySQL database name
$tableprefix='test_';               //MySQL table prefix, allows for multiple instances

the mysql username and password ive configured in the file
C:\Program Files\EasyPHP1-8\conf_files\php.ini like this

; Default port number for mysql_connect(). If unset, mysql_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order). Win32 will only look
; at MYSQL_PORT.
mysql.default_port = 3306

; Default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults.
mysql.default_socket =

; Default host for mysql_connect() (doesn't apply in safe mode).
mysql.default_host = localhost

; Default user for mysql_connect() (doesn't apply in safe mode).
mysql.default_user = Jules

; Default password for mysql_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")
; and reveal this password! And of course, any users with read access to this
; file will be able to reveal the password as well.
mysql.default_password = Paradox

im doiing something wrong???

KeFear · « **Reply #9 on:** June 11, 2006, 02:37:42 pm »

make sure you have the user in your MySQL database, and make sure you set the right password for him.
Also make sure you set this password in the configuration file of zitro-install and/or you typed in correctly when the installer asked.

MR X · « **Reply #10 on:** June 12, 2006, 03:35:29 pm »

Its maybe a stupid question cause im new with msql and php but how do i set the username and password??? i know how to set it in zitrostats config file but i dont know how i must set it in the MySQL database. can you explain it maybe??? plzz

Thank you foor helping me out!

KeFear · « **Reply #11 on:** June 13, 2006, 10:26:33 am »

Ok, just open phpMyAdmin and find "Privileges" or similar. You can add and manage your MySQL users on that page. You must be - of course - logged in as admin to do that.

MR X · « **Reply #12 on:** June 13, 2006, 04:51:31 pm »

Its working!!!!! yeaahhhhh!!! OMG i feel stupid

thank you Kefear.
But yeah once you know it it all becomes a lot easier

Thank you very very mutch for helping.
and keep up the good work.

But here's another (maybe agian a stupid) question.
I can view my zitrostats only on my pc with localhost as URL.
When i type my IP as URL it should be working too but it doesnt.

Do i something wrong agian???

oh man if i know mutch about easyphp and php/mysql then i gonna write a tutorial.!!

Lord Jaws · « **Reply #13 on:** June 13, 2006, 04:55:53 pm »

Cool, I am gonna try it too, thanx for this, its a sort of tutorial.

And ARSSE does rule, its the prefect tool to administrate my clanserver, jsut I wish I could get some scripts, I aint good at those things >.<

MR X · « **Reply #14 on:** June 14, 2006, 10:24:01 am »

Hehe found it by myself. to make it "public" you must right click on easyphp's icon in the taskbar. then you must click in the pop up menu on "Configuration" and then on "Apache"
Then you get a file opened in notepad named "httpd.conf". pres CTRL+F to open the search window of notepad and type "Listen: Allows you" exactly like i wrote it. click then on "search next" or somthing like that in the search window. then you get the "Listen: Allows you" text in the file highlighted. Scroll a little bit down then until you see this text:

# Listen: Allows you to bind Apache to specific IP addresses and/or
# ports, in addition to the default. See also the <VirtualHost>
# directive.
#
#Listen 3000
#Listen 12.34.56.78:80
Listen 127.0.0.1:80

when you see this text you can only view your current php sites with the following url:
http://Http://127.0.0.1:80
when you want that your friends and everyone on the world can see your site you must add this sentence below "Listen 127.0.0.1:80": "Listen <your IP adress>:80"
Note where <your IP adress> stands must stand your IP address.
if you done this you can visit your site with your ip adress

Thats all

Special Thanx to Mr. Kefear. without him i didnt even know anything about easyphp and that stuff. SO THANK YOU KEFEAR

FliesLikeABrick · « **Reply #15 on:** June 14, 2006, 10:45:48 am »

Quote from: MR X on June 14, 2006, 10:24:01 am

Hehe found it by myself. to make it "public" you must right click on easyphp's icon in the taskbar. then you must click in the pop up menu on "Configuration" and then on "Apache"
Then you get a file opened in notepad named "httpd.conf". pres CTRL+F to open the search window of notepad and type "Listen: Allows you" exactly like i wrote it. click then on "search next" or somthing like that in the search window. then you get the "Listen: Allows you" text in the file highlighted. Scroll a little bit down then until you see this text:

# Listen: Allows you to bind Apache to specific IP addresses and/or
# ports, in addition to the default. See also the <VirtualHost>
# directive.
#
#Listen 3000
#Listen 12.34.56.78:80
Listen 127.0.0.1:80

when you see this text you can only view your current php sites with the following url:
http://Http://127.0.0.1:80
when you want that your friends and everyone on the world can see your site you must add this sentence below "Listen 127.0.0.1:80": "Listen <your IP adress>:80"
Note where <your IP adress> stands must stand your IP address.
if you done this you can visit your site with your ip adress

Thats all

Special Thanx to Mr. Kefear. without him i didnt even know anything about easyphp and that stuff. SO THANK YOU KEFEAR

don't replace it with your public IP address for a couple reasons:
1) http://localhost won't work anymore
2) your external/internet IP probably changes pretty often
3) your local IP (192.168.C.D) won't work

Instead, use 0.0.0.0:80, this tells it to listen on all IPs

KeFear · « **Reply #16 on:** June 14, 2006, 11:05:15 am »

Or just use "Listen 80", that's my setting.

Lord Jaws: what kind of scripts do you need?

MR X · « **Reply #17 on:** June 15, 2006, 05:45:35 am »

Hey zitrostats ask me my log directory in his admin pannel. what must i type there?. ive tryed C:\soldat\logs and
C:/soldat/logs and C:soldatlogs and /logs and logs.

he gives me this error when i run update.php:

____ _ ____ __ __
[__ ] |_ __] \/ \ Stats - Version 0.6
/ /| || || O )O | -------------------
/ /_| || || < | Â©2005-09-29 by oLaf
[____]_||_||_|\_\__/ o_zilla@hotmail.com

http://zitrostats.sourceforge.net/

==[ SYNCHRONIZE ]=============================
server 1 (86.84.27.194:23073) Join R Die
ERROR: chdir failed!

==[ CLEAN EXPIRED ]===========================
expiredate: 2005-06-15 14:27:15
events before deadline: 0

==[ CALCULATING NEW ]=========================
parsing new events from 0 log(s)

==[ UPDATE DATABASE ]=========================
insert new done
delete old done

==[ CLEAN TEMP ]==============================
delete signatures 0
delete usage 0

On the homepage of zitrostats stands this but i dont get it. what means "/usr/local/". is that an other "word" for the root of my HDD???

In servers administration you can setup the game servers participating in your stats. For "logdir" you have to enter the path of log directory: for example /usr/local/soldat/server01/logs/ for a local server or ftp://user:secret@soldat01.my.net/logs/ for a remote server via FTP.

KeYDoN · « **Reply #18 on:** June 15, 2006, 09:55:21 am »

maybe CaSe sEnsIBilItY

and don forget the "\" as last character

KeFear · « **Reply #19 on:** June 15, 2006, 12:13:37 pm »

Just try to set the dir to "c:\soldat\logs\" or wherever your logs are. Just don't forget the last "\" from the end, as KeYDon wrote.

For the second problem:
/usr/local is a folder on linux systems, just ignore it if you are using windows..

News:

Author Topic: moved:INSTALLING ZITROSTATS HELP (Read 22873 times)