[Release] gllcTS2 Webpost for TeamSpeak 2

[andreagighi]

I'm setting up webpost for my ts2 server but i got this problem:

Gabibbi Esaltati Voice Server

Data unavailable.
TCPQueryPort may not be open.



I got this problem only in my server but not in thz server:
this the url:
http://andreagighi.altervista.org/ts2/wp2/

and here the url of tzh that work good:

http://www.thzclan.com/ts2/

I think the problem can be the database not properly setting ...
some help ???
thnksssss

...i use phpMyAdmin to set the database !!!

[BLIND]

I forget what ports they are, but sounds like your router/firewall is blocking the data port...

[woutur]

I give up.

I couldn't get past the first step, there is no documentation whatsoever. And not really good support on this.

I mean, I can't ask clearer than:
Help me get through the first step.
What commands should i use?
What is the file: webpost2.sql for?
How can i make the things in that file work in mysql?
Is there some way I can use myphpadmin for that?

Stuff I already asked I guess. Too bad. Now newbies can't use this otherwise fine piece of software.

[BLIND]

ok, don't get bent out of shape, best way to get support like what your having is have some one guide you through. If you wish to e-mail me your messenger info, we can get in contact and I can help you.

phpMyAdmin will run .sql (or any table/database formating file) you just must have a few things done.

This might sound stupid, but its critical.

1. have phpMyAdmin running and working (i.e. entered all config.inc.php info correctly) so you can browse and edit your database and tables.

2. (not sure what version of phpMyAdmin your running, but its generally the same) open your web browser and point it to the phpMyAdmin address, and login, or if that isn't required, pick a database your going to be adding the webpost to in the left frame. in the right frame click on the SQL tab.

3. There are 2 text boxes there (I hope) first one is like your mysql command prompt, you can runn commands there. Second is a text entry for a location of the database/table editing file (webpost.sql in this case) browse for that file and run it, and it should insert all the webpost tables and data.

[Gryphon]

Sorry I have not been around much, very busy at work.

The instructions are setup assuming that if people have access to mysql and php that they most likely know how to do this.

First you must have a database setup with a username and password. Login to the database with phpMyAdmin and find the area to run the sql file, attached it a screenshot of it.

After you have run the query all your tables will be setup. Then plug in the database username and password into the config file.

I can't promise any time frame on 4.0, but it will have a web based install so that phpMyAdmin is not necessary.

[woutur]

Thx to a file I got the tables and all made in the db.
Only thing now is to make my server show up:
http://62.216.18.183/~teamspeak/webpost.php

This is the same address i specified at the PostURL=
in the server.ini.
I know the tcpquery port is open and running (I can connect to it and check commands and stuff.)

Just need the last step

[Gryphon]

That is the right address for the PostURL, make sure you restart the server after making changes. The server also needs to run for a while before they show up on the list, 10 minutes max.

[woutur]

[WebPost]
AdminEmail=wouter@teamspeak.org
ISPLinkURL=Not really important
ISPName=Cistron
ISPCountry=Netherlands
Enabled=1
PostURL=http://62.216.18.183/~teamspeak/webpost.php
ListPublic=1
ISPCountryNumber=0


^^
My setup. It just fails to show up.. Might the problem be that i am using a slighty newer server version?

[BLIND]

hrmm this might be totally off the wall, but try taking the tilde ( ~ ) out of the address, and of course making the web address folder the same likewise. (i.e. http://62.216.18.183/teamspeak/webpost.php)

Just a thought, it might screw with SQL settings, but I might be totally off the wall as well.

[woutur]

I moved my data to another dir to lose the tilde ~. But still I don't get any server showing up.

Maybe it's the server version

030514 17:23:37    2622 Connect     teamspeak@localhost on 
                   2622 Init DB     webpost2
                   2622 Query       delete from ts2_weblist where (server_timestamp + 900) < '1052925817'
                   2622 Query       delete from ts2_user where (server_timestamp + 900) < '1052925817'
                   2622 Query       delete from ts2_channel where (server_timestamp + 900) < '1052925817'
                   2622 Query       delete from ts2_group where (server_timestamp + 900) < '1052925817'
                   2622 Query       SELECT * FROM ts2_weblist WHERE clients_current > 0
                   2622 Query       SELECT * FROM ts2_weblist WHERE clients_current > 0
                   2622 Query       SELECT * FROM ts2_weblist WHERE 1
                   2622 Query       SELECT * FROM ts2_weblist WHERE 1 order by server_name asc, server_name LIMIT 0,15
                   2622 Query       SELECT * FROM ts2_channel
                   2622 Quit

From the mysql.log

[BLIND]

hrmm maybe Gryphon can back me up on this, but as long as your server version is sending the same packet info out on the same ports as previous versions, it should be gravy.

[maletin]

Originally posted by woutur
My setup. It just fails to show up.. Might the problem be that i am using a slighty newer server version?

My TS-Server was 66 days running, when the webhost-server was going down.
after restart, i couldnt see any webpost request from my ts-server.
i had to restart the ts-server and now it works again (but all servers (ports) are visible on the webhost-server. the tcpquery port doesn't work again. maybe i miss an old patch, that i had on my old webpost.)

[Gryphon]

Originally posted by BLIND
hrmm maybe Gryphon can back me up on this, but as long as your server version is sending the same packet info out on the same ports as previous versions, it should be gravy.

All all the webpost needs to show up is port number. All the other data can be there or not and something would still show up

I just spoofed it and something showed up on the listing, so I know it will accept the post. For some reason your server is not sending anything at all to the webpost.php.

You set ther PostURL and restarted the server after the changes?

[woutur]

I gave up

I could make my server show up on other webposts just not on my own page.

Other people could make their servers show on other webposts but not on my webpost. Ergo: there is something wrong with access to my webpost.. or something.

Might be a firewall problem, or a permission thing. Dunno.

[9999]

If i use the .htacces file the webpost page wont show up so i deleted it and it shows the inde now.


But i've set the webpost url in TS2 but it doesn't show up in the list :S

Why not?