Jump to content

Upgrade TS3 server


gemcneill

Recommended Posts

This sql statements are only needed to get access to the new permissions:

 

These are the command to update your database:

 

Quote:

insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_virtualserver_modify_min_client_version", 1, 0, 0);

 

insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_virtualserver_modify_min_cl ient_version", 100, 0, 0);

 

insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_modify_min_client_version", 1, 0, 0);

 

insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_virtualserver_modify_min_cl ient_version", 75, 0, 0);

 

insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_virtualserver_custom_search", 1, 0, 0);

 

insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_virtualserver_custom_search ", 100, 0, 0);

 

insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_custom_search", 1, 0, 0);

 

insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_virtualserver_custom_search ", 75, 0, 0);

 

Source: http://forum.teamspeak.com/showthread.php?t=50072

Link to comment
Share on other sites

The whitelist text should either be blank or have an internal ip listed by default.

 

127.0.0.1

 

You need to add your tca master ip under that one and also you should add the tsviewer ip if your client use this service to list they're TS server on a website.

 

That IP is: 85.25.120.233

 

 

 

query_ip_whitelist.txt

127.0.0.1
tcamaster ip goes here
85.25.120.233

Hope this helps!

Link to comment
Share on other sites

Hmm, tried with the whitelist file empty. Tried with the whitelist file populated with the ips and still I receive the error message

 

failed, Connection Closed Gracefully

 

when I try to add a virtual server on the box. Note that each time I tried, I did a new install so I knew all was fresh.

Link to comment
Share on other sites

Hmm, tried with the whitelist file empty. Tried with the whitelist file populated with the ips and still I receive the error message

 

failed, Connection Closed Gracefully

 

when I try to add a virtual server on the box. Note that each time I tried, I did a new install so I knew all was fresh.

 

changes require a restart of the TS3 master server

Link to comment
Share on other sites

hello,

 

i'm having a problem with ts3 too. I have updated it to beta15, all current servers are running and working fine. But i have an error when i try to install a new ts3 server

 

the error is : Connection Closed Gracefully

when i see the server log from the master ts3 server logs, i can see he has created one, but the server ip isnt showing up in tcadmin list.

 

2010-01-20 10:51:38.338625|INFO |VirtualServer | 22| listening on 91.198.27.41:10005

2010-01-20 10:51:38.463625|INFO |VirtualServer | 23| listening on 91.198.27.41:10006

2010-01-20 10:51:38.604250|INFO |VirtualServer | 24| listening on 91.198.27.41:10007

2010-01-20 10:51:38.729250|INFO |VirtualServer | 25| listening on 91.198.27.41:10008

2010-01-20 10:51:38.854250|INFO |VirtualServer | 26| listening on 91.198.27.41:10009

2010-01-20 10:51:38.854250|INFO |Query | | listening on 91.198.27.41:10011

2010-01-20 10:56:07.026125|INFO |VirtualServer | 27| listening on 91.198.27.41:10010

2010-01-20 10:56:07.041750|INFO |VirtualServer | 27| client 'server'(id:0) added token for servergroup 'Server Admin'(id:95)

2010-01-20 10:56:07.041750|WARNING |VirtualServer | 27| --------------------------------------------------------

2010-01-20 10:56:07.041750|WARNING |VirtualServer | 27| ServerAdmin token created, please use the line below

2010-01-20 10:56:07.041750|WARNING |VirtualServer | 27| token=7VK0KplJpL7PclIgxBRX7G1vVeNWJuiNckhUaSsM

2010-01-20 10:56:07.041750|WARNING |VirtualServer | 27| --------------------------------------------------------

2010-01-20 10:56:07.088625|INFO |VirtualSvrMgr | | addServer() VirtualServer(27) started

 

only the portnummer 10005 is visible in the tcadmin, the server i have created before the update. All test servers since the update are in the list of the log, but not on the list of the tcadmin. i can join the servers with the ports that are not on the tcadmin list like 10010 for example.

 

What can i do? (if i go to admin settings , voice server settings, the test is successfull)

 

my whitelist ip's are

127.0.0.1

62.182.59.39

85.25.120.233

 

2nd one is the tcadmin master server ip (my webserver ip is 62.182.59.44 should i add it somewher?)

 

voiceservers are installed on 91.198.27.41

 

Thanks

Vicky - SilverStarke

Link to comment
Share on other sites

silverstarke,

 

i updated to the v15 and had some problem so i created a fresh TS3 with the v16 and everything is working good now. I would suggest you to try it before searching around for hours.

 

Create a new TS3 server v16 with your DB, had all your IP's (including TCA Remote & Master) for gaming/voice in the "query_ip_whitelist.txt" and give us back some feedback.

Link to comment
Share on other sites

This sql statements are only needed to get access to the new permissions:

 

These are the command to update your database:

 

Quote:

insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_virtualserver_modify_min_client_version", 1, 0, 0);

 

insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_virtualserver_modify_min_cl ient_version", 100, 0, 0);

 

insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_modify_min_client_version", 1, 0, 0);

 

insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_virtualserver_modify_min_cl ient_version", 75, 0, 0);

 

insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_virtualserver_custom_search", 1, 0, 0);

 

insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_virtualserver_custom_search ", 100, 0, 0);

 

insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_custom_search", 1, 0, 0);

 

insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_virtualserver_custom_search ", 75, 0, 0);

 

Source: http://forum.teamspeak.com/showthread.php?t=50072

 

I am receiving this error when I try to use new tokens that are created

 

database empty result set

 

I am assuming that the above fixes this. Do I just use putty to log into each server and run this command?

Link to comment
Share on other sites

i have a new beautiful message :s:s:s Could not connect to TeamSpeak Server: error id= msg=connection failed, you are banned

 

Had the same problem with Beta 16.

But if you check it via the ts3 shell, the virtual server is probably created.I deleted it manually and added the tc admin master ip to the whitelist. After doing that it worked.

 

Seems like Teamspeak is creating bugs instead of solutions

Link to comment
Share on other sites

  • 2 weeks later...
i have a new beautiful message :s:s:s Could not connect to TeamSpeak Server: error id= msg=connection failed, you are banned

great because i dont know why :st

 

I'm having the same issue now.. In my whitelist I added the Master server and it worked for a day... I'm using TS3 version 16.

 

Since my TCAdmin is hosted by tcadmin.com, I'm assuming the Master Server IP would come from the resolved address <myname>.tcadmin.com

 

After reading this thread, I'm sure my issue is an IP for my white list, but either it's not working or I have the wrong IP. I'm also using the latest TCAdmin.

 

Any ideas?

Link to comment
Share on other sites

whietlist doesnt do name resolution.

 

 

Ping youname.tcadmin.com to get the IP or put in a ticket and ask for it.

 

I did this already... I was asking if this was the IP I was to enter.. from xxxx.tcadmin.com

 

There must be something else I'm missing.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

  • Who's Online   0 Members, 0 Anonymous, 43 Guests (See full list)

    • There are no registered users currently online
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Terms of Use