Installing Zitro-Stats

[Flying Dutchman]

Hi there. I'm trying to install Zitro-Stats for Real Soldats new server. I've read the tutorial and so far everything is going fine. But now I have to initialize it and for that I have to enter several things, and I'm not sure what I should enter.

He asks me for:

• Server
• User
• Password
• Database
• Table Prefix
• Admin Password

I've tried several things but it keeps saying the Server, User and Password are wrong. It would be nice if someone could point me out what exactly I should enter cause I'm a complete noob on this kinda stuff.
The server is hosted by selfkill.

PS; Sorry if this is posted in the wrong section, wasn't really sure where to post.

[spkka]

well since the release of 1.4 i try to get it  to work and it did work before..
Tell me how you fixed it
u13 servers still running with zitrostats so im wondering what he changed
i sended a mail to the guy that made zitrostats to make it  working again

[Bunney]

Hey Dutchman its me Guerrilla, from -:TA:-

Hmm Zitro Stats, hmm, updated? im not sure, i have never heard a problem like that before

[Flying Dutchman]

Hi there Bunneh.
Well it's not really a problem from the side if Zitro-Stats. When opening Zitro-Stats  for the first time after uploading it to the server it asks to fill in those things mentioned above, but I don't know what to put in em.

Edit: Ok, I finally figured out what to type in those bars. But now it says "Error: creating database failed!". Anyone got an idea what's causing it? And how I can fix it?

Edit 2: It seems I don't have the rights to create a new database, even while allowing the user to do everything. How can I fix this?

Ok, nevermind everything. I figured it out!! Could make the database manually and its working now!

[Maff^]

Just to let you know, on the ZitroStats website there is a new version (1.20070509) available.

changelog:

ADDED soldat 1.4 compatibility
FIXED copyright of soldat forum logo
FIXED warning notice in global.inc.php
FIXED deleting logs of deleted servers
FIXED replacing servers with same ip/port/logdir

I just installed it, and works fine with server 2.6.0 look

[Storm]

Heya guys,

I just downloaded Zitro-Stats to create some nice stats for my clan's private and public server.
I followed all instructions but I'm getting this error:

"error mysql_query('SELECT `value` FROM `stats_options` WHERE `key`='VERSION'')
Table 'stormdesigns.stats_options' doesn't exist"

I tried creating the table myself, but I had to give in some entries, which I don't know what they are.

Can you help me Maff^? ( I just sent you a PM too :-) )

[urraka]

Try deleting config.inc.php inside the include folder.

[Storm]

Omg, you're good. I actually see a page now!

Thanks alot PerroAZUL! Too bad we don't have karam or anything at these forum boards :-)

Greets from the Netherlands!

Date Posted: May 30, 2007, 04:50:53 PMHey matey, everything is working! I configured the page a bit, only thing I need to do now is add servers.
I made the following "solution":

Servers upload stats every night to my website.com/stats/logs folder which is reachable by HTTP.
In Zitro-Stats I configured it like the following:

- Servername
- IP:port (my ip:23074) (Game is configured at this port)
- Logdir: The dir I specified above. I checked if I could open a file, and I could do that.

Now the following error appears when I got the "asequery" plugin. This is to update or check upon the status right?

"Warning: fsockopen(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /home/stormdesigns/public_html/xr/stats/plugins/asequery/index.php on line 16

Warning: fsockopen(): unable to connect to stormdesigns:23197 in /home/stormdesigns/public_html/xr/stats/plugins/asequery/index.php on line 16
Connection error!"

Also, when I try to run update.php it gives me a choice of saving it locally, not to run it. I tried to CHMOD 777 that file, but that didn't work out.

Can I call upon you again PerroAZUL? =)

Date Posted: May 30, 2007, 05:31:37 PMUpdate; The error is no longer there. I was mistaken by putting in stormdesigns with no TLD. I got 2 servers running on one machine.

A private clanserver on port 23074 passworded
A public clanserver on port 23073 non-passworded

The private one can be monitored, the public one shows as offline, but this server is just online.

This is my current access-list:

ip nat inside source static tcp 172.19.28.10 23073 interface Dialer1 23073
ip nat inside source static udp 172.19.28.10 23073 interface Dialer1 23073
ip nat inside source static udp 172.19.28.10 23074 interface Dialer1 23074
ip nat inside source static tcp 172.19.28.10 23074 interface Dialer1 23074
ip nat inside source static udp 172.19.28.10 23197 interface Dialer1 23197
ip nat inside source static tcp 172.19.28.10 23084 interface Dialer1 23084
ip nat inside source static tcp 172.19.28.10 23083 interface Dialer1 23083

access-list 105 remark |------------Allow Soldat----------------|
access-list 105 permit tcp any any eq 23073
access-list 105 permit tcp any any eq 23083
access-list 105 permit udp any any eq 23073
access-list 105 permit tcp any any eq 23074
access-list 105 permit tcp any any eq 23084
access-list 105 permit udp any any eq 23074
access-list 105 permit udp any any eq 23197

I also tried disabling the private one, and only trying to monitor the public one. This did not work either.

The problem with the update.php is still active. Still asks me if I want to open/save it instead of really running something. Do I have to open it with php.exe or something in that direction? This because the webserver is not at my home..

[urraka]

If you don't want the prompt box in update.php you can edit that file and remove this line:

Code: [Select]

header("Content-type: text/plain");
I don't know if there is a better work-around for this.

[Storm]

I just edited that Perro,

And now I actually see a real error:

"____ _ ____ __ __ [__ ] |_ __] \/ \ Stats - Version 1.20070509 / /| || || O )O | -------------------------- / /_| || || < | © 2006-10-09 Stefan Schulz [____]_||_||_|\_\__/ o_zilla@hotmail.com http://zitrostats.sourceforge.net/ ==[ SYNCHRONIZE ]================================== server 1 (stormdesigns.nl:23074) |xR| Private Server
Warning: file(http://www.stormdesigns.nl/xr/stats/logs/privatekills/?C=M;O=A): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /home/stormdesigns/public_html/xr/stats/include/update_sync.inc.php on line 50

Warning: Invalid argument supplied for foreach() in /home/stormdesigns/public_html/xr/stats/include/update_sync.inc.php on line 51
log files: 0 total, 0 changed, 0 new server 2 (stormdesigns.nl:23073) |xR| Public Server
Warning: file(http://www.stormdesigns.nl/xr/stats/logs/publickills/?C=M;O=A): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /home/stormdesigns/public_html/xr/stats/include/update_sync.inc.php on line 50

Warning: Invalid argument supplied for foreach() in /home/stormdesigns/public_html/xr/stats/include/update_sync.inc.php on line 51
log files: 0 total, 0 changed, 0 new ==[ CLEAN EXPIRED ]================================ expiredate: 2007-03-01 01:17:13 events before deadline: 0 ==[ CALCULATING NEW ]============================== parsing new events from 0 log(s) ==[ UPDATE DATABASE ]============================== insert new done delete old done ==[ PLUGINS ]====================================== delete usage 2 delete signatures 0 "

Failed to open HTTP stream..I think this plugin needs the url given have "list-options"?
Since if I go there manually, I can't view the page either. I have to enter the whole url.

The requested URL /xr/stats/logs/publickills was not found on this server.

I'll check this today with my webhosting company. Maybe they can enable listing on my log directories.
Have you looked at the online status issue? "Server offline!" still appears at one server. The other one works great!

Thanks again!

[urraka]

I got errors like those when i tried http protocol, so I changed to ftp and it worked just fine. I use FileZilla for ftp, by the way.

[Storm]

I use FlashFXP, I'll try the ftp then.. the log dir is that used like ftp://user:password@ftp.host.com?

Date Posted: May 31, 2007, 03:00:03 PMOk, ftp seems to work great!
Anyways, still my 23073 appears offline while the 23074 works like a charm..

Date Posted: May 31, 2007, 03:10:23 PMW00t I found the issue.

My private server (23074) is using ASE port 23197
My public server (23073) is using ASE port 23196! <- Didn't open up a port for this one.

I didn't know I had to open up ASE ports anyway. So let this be a lesson to other users of Zitro-Stats!

Only thing remaining for me is to create a script that uploads the log files every 24 hours =)

Thanks for the help all!

[urraka]

My server also appears offline. Maybe it's because I use a perroazul.dyndns.org name instead of the actual ip.

[Storm]

Nah, I use dns records too =) maybe also the ASE port?

[Leo]

You need to open query port to ASE which is your server's port + 123 In Storm's case, 23073 + 123=23196 (which worked)

ps. I told you about ftp Storm

[Storm]

Yep! Thanks again Leo, this works just as good =] Hopefully it works for PerroAZUL too

[urraka]

Yes it worked, i hadn't thought about that because i had open that port, but for some reason that entry got removed from the router ¬¬

[Storm]

Maybe your router was rebooted while your configuration wasn't saved yet? =)

[the undertaker]

how do u create a port for soldat ? 

[Storm]

You have to configure your firewall in your router or software.
If you have anything like ZoneAlarm or Norton Internet Security you should open that up and search for network security or firewall. Otherwise you have to log into your router and configure some ports. Consult your manual for that.

If you have any further questions, be sure to ask! :-)