Hidden Servers = 2!?

[TDrop]

Hi,

I'm having problems using WebPost - I am running one TS Server on a Linux box but it doesnt seem to be updating the db correctly. When I go to the webshow.php URL it says that I have Hidden Servers but no visible ones. The TeamSpeak Server is up and running and the IP of the server that it is running on has permission to access the db. Any ideas as to why its not showing the server info?
http://www.stormraptors.co.uk/webshow.php

The machine with Webpost on is running;
PHP version 4.2.3
MySQL version 3.23.54

The server.log file doesnt mention webpost at all.

12-01-03 15:11:22,ALL,Info,server, Server startup initialized
12-01-03 15:11:22,ALL,Info,server, Server version: 2.0.18.32 Linux^M
OK
12-01-03 15:11:22,ALL,Info,server, Starting server with port: 8767
12-01-03 15:11:27,ALL,Info,server, Server startup finished
12-01-03 15:11:27,WARNING,Info,server, TeamSpeak Server daemon activated

If I telnet to port 51234 on the TSServer I get a [TS] prompt, and I am also running a MYSQL Forum on the webpost server so I dont think there are any conectivity problems there.

Thanks,

TD

[TDrop]

Could this be a MYSQL problem? I dont know the first thing about MYSQL or PHP but looking through the webpost.php file I found;
$___r= mysql_connect($dblink,$dbuser,$dbpw);
_DBError($___r);

I tried doing; `mysql connect $dblink ,$dbuser`at the command prompt (and all other combinations etc) and it didnt work. However I was able to do `mysql -u$dbuser` and that took me to a mysql prompt. `connect $dbname` worked. Is that normal? Or does it mean I have some other version of MYSQL running?

Another thing Im guessing might be causing it is my server.ini file on the TSServer. I found the following info in the webpost readme.txt;

Edit the [WebStatus] section of your tsserver.ini. Example:

[WebStatus]
Active=1
TeamSpeakSite_Active=1
TeamSpeakSite_DisplayInWebList=1
WebPostURL=http://URL_TO_webpost.php
WebPostLinkUrl=http://URL_THE_SERVERLINK_SHOULD_POINT_TO

I did not have this section in the server.ini file, so i added it (with relevant details) but sill no luck.

Please help me (or point me in the right direction of a relevent URL - no MYSQL howto's though, Im supposed to be revising for an exam on Friday ) cause Ive reached the 'tearing hair out' stage of frustration!


Update: OK Im getting past the frustrated stage - this post has been here a couple of days, has had 80 hits, yet still no1 has even commented Is what I am asking sooo stupid? If so, please tell me!

[direwolf]

Is register_globals on or off on your server?

[TDrop]

Hi, thanks for your reply!

I cant find any reference to "register_globals" in any of the server scripts so I am assuming it is not set. Where should I put it? Ive searched the forums for the phrase but no luck.

[direwolf]

the register_globals is a setting in php. You can set it by editing the php.ini file on your server.

Be aware that having register_globals on is considered to be a security risk.

I found that the script didn't work on my server unless I had register_globals set to on. If I got motivated enough I might go through the script and insert some

$_GET $_POST $_SERVER 

to get it working. Bit busy now tho.

[TDrop]

Cool thx for the info - one last question though (before I go off to learn php) does register_globals need to be set on the webserver or the teamspeak server (Im thinking webserver, but I ust wanna make sure!).

Thanks again,

TD

[TDrop]

OK, I took a look at the php.ini file on the webserver and found the following line

register_globals = On

It wasnt hashed out so I guess it is turned on.

I had a little experiment with mysql and found that IP and connection time are both being posted (that the correct word?) to the database, but other variables (ie the ones I want to see!) are not.

Rebooted Server and connected as a guest to TSS and all of the rooms are gone.... Ive vi'd server.db and I can see all of the usernames/passwords in there so its not empty. Gonna reinstall TSS

[TDrop]

Reinstalled TSS on my server and still no luck Started from scratch and recreated the server.ini file. Im getting desperate now so I'll post it here;

[debug]
MessageTypes=LMTALL
MessageDepths=LMDALL

[Main Config]
HTTPServer Port=14534
HTTPServer Enabled=1
DateTimeFormat=dd-mm-yyyy hh:nn:ss
TCPQueryPort=51234
BoundToIp=

[WebPost]
AdminEmail=admin@stormraptors.co.u
ISPLinkURL=www.stormraptors.co.uk
ISPName=SRM1
ISPCountry=Earth
Enabled=1
PostURL=http://stormraptors.co.uk/webpost.php

[server_cfg Default]
ServerName=TeamSpeak Server
ServerType=1
ServerWelcomeMessage=[Welcome to TeamSpeak, check www.teamspeak.org]
ServerMaxUsers=50
ServerUDPPort=8767
ServerPassword=
ServerFlags=2
AllowCodecCelp51=1
AllowCodecCelp63=1
AllowCodecGSM148=1
AllowCodecGSM164=1
AllowCodecWindowsCELP52=1
WebPost_LinkURL=http://stormraptors.co.uk/webpost.php

[Servers]
0=server_cfg Default

I can Telnet to port 14534 and login as a superadministrator and do commands like pl and sl etc.... Do I have to create a TeamSpeak user with the same name as the MYSQL user?

[TDrop]

Ok I replaced the Webpost script Id downloaded from the Scripts directory with webpost2. It now works fine, so I have no idea what was wrong originally. Oh well, at least its working now

Thanks for your help Direwolf,

TDrop