TeamSpeak 3 Server 3.0.0-beta30 Available

[DSCKerry]

this really sucks...

I wait for the day when the server isnt as dumb as it is, having to specify that theres a config for both regular and mysql instead of having it look for the config first thing (like almost any server program I have used)

I wait for the day that I can just double click on the server exe and it will auto check \ to find the config, see that it needs to use mysql, look for, find, understand and use that mysql file, and be done with it...

not server - config - mysql - really gay long unneeded command line options - you enter here - if you want - to continue - being - really - annoying

got that? or need it explained in simpler terms? I mean fuck Ill get some crayons out and draw it for you? id offer to pass on examples of simple software that does this already but god knows software haters are everywhere...


probably the only issue I have...

[shadow_lmd]

DSCKerry, I have no idea what you are talking about.

[Alcazar]

... already but god knows software haters are everywhere...

Like you?

[Screech]

Well, aside from the FreeBSD issue Beta30 is looking good to me.

Working great on my Linux VPSs. Permissions and database updates look good. I like the new b_client_permissionoverview_own permission, would be nice to see on normal and above on the public server.

Quick question before I decide to research the idea more regarding this entry: "fixed channel client permissions where not removed on channel delete". Is there code with this to delete previously "orphaned" permissions, maybe as part of the database or permissions version update code? Figure an answer from a dev would be worth more than my time testing.

[R. Ludwig]

Well, aside from the FreeBSD issue Beta30 is looking good to me.

Working great on my Linux VPSs. Permissions and database updates look good. I like the new b_client_permissionoverview_own permission, would be nice to see on normal and above on the public server.

Quick question before I decide to research the idea more regarding this entry: "fixed channel client permissions where not removed on channel delete". Is there code with this to delete previously "orphaned" permissions, maybe as part of the database or permissions version update code? Figure an answer from a dev would be worth more than my time testing.

no sorry... i think i will add something like that to detect outdated, missed, bogus, wrong data in one of the not so near future versions.

[Aenoa]

hi, I fixed the error, I've deleted the SQL folder and remplaced it by the B30 ver.

[Ven0m]

hi, I fixed the error, I've deleted the SQL folder and remplaced it by the B30 ver.

During update, I always leave only database, settings, and license file. Everything else goes out. It's a pretty safe way to update (of course, always do a backup).

--- EDIT ---
I updated x64 FreeeBSD server to the new b30 build. There have been no issues since then. Thumbs up!

[Screech]

no sorry... i think i will add something like that to detect outdated, missed, bogus, wrong data in one of the not so near future versions.

No Problem, thanks for the reply. Maybe another SQL script for me to write and share for those that want it...

[DSCKerry]

DSCKerry, I have no idea what you are talking about.

I dont know what OS your using, but I use Windows, so this (for the most part) is windows related (might be the same on other OS's dont know).

I want to start my TS3 server, so I go into my folder where I placed TS3, I open the .exe, but wait, its not working!
I cannot see the reason why, I mean the "ts3server.ini" is in the folder, in the .ini its set to MySQL, oh wait! you have to make a shortcut to the .exe?
wait what? why? because the exe is stupid! oh... that sucks... ok so
"X:\teamspeak3-server_win64\ts3server_win64.exe -ts3server.ini" ok, lets try again... wtf... still not working! but I have the .ini set and in the ts3server.ini its set for MySQL... whats that? its still stupid? oh... that still sucks... what now?
Oh add more to the shortcut "X:\teamspeak3-server_win64\ts3server_win64.exe -ts3server.ini -dbplugin=ts3db_mysql"

HEY IT WORKS, that help you understand?

I should be able to click on ts3server_win64.exe WITHOUT having to have a shortcut, it should automatically see/search for the ts3server.ini, read from that ini see that it is set for mysql, and use the ts3db_mysql config file+plugin without having to use those extra necessary parameters...

[Screech]

Hello people,

We just released the TeamSpeak 3 Server beta-30.

Changes: (abbreviated to the ones for my question)

=== Server Release 3.0.0-beta30 23.11.2010 Nov 2010
+ reduced CPU usage for large servers
+ servergroupclientlist uses now internal id/uid/name cache which results in faster processing and lower database usage

Still happy, but just got more questions. I just looked at a graph of my memory and CPU usage over the last week. When I updated my server 4 days 8 hours ago and the memory increased about 8MB (from 62MB to just over 70MB). First guess is that is the internal id/uid/name cache feature. Next and more concerning is my CPU, prior to the update the CPU was between 6-8%, now I'm up to 18-28%. That is the opposite of what I was expecting with my small server seeing as the CPU usage was reduced for large servers.

http://screech.me/images/temp/beta30-system_usage.png

[TotoIsBack]

We wanted to wait a little to be sure, but now that you post it, we have the same constation. Our memorry use and our cpu use have increased (~20% more for the CPU for ~80servers).

We were surprised that, as you said, the effect constated was the opposite a the one in the changelog

(constated on linux 32Bits and 64Bits)

[savinna]

NOTE: The amd64 freebsd server was reuploaded in a fixed version
YA ! YA ! YA !
NOW WORK GOOD~

[Screech]

No Problem, thanks for the reply. Maybe another SQL script for me to write and share for those that want it...

OK as normal, I make no claim to the safety of these SQL commands and HIGHLY recommend making a backup of your database before issuing them just in case they don't work as well for you as they do me so that you may restore the database.

This script should safely remove out of date records that are no longer needed in the database.

DELETE FROM channel_properties  WHERE server_id NOT IN (SELECT server_id FROM servers) OR id NOT IN (SELECT channel_id FROM channels) ;
DELETE FROM perm_channel_clients WHERE server_id NOT IN (SELECT server_id FROM servers) OR id1 NOT IN (SELECT channel_id FROM channels) OR id2 NOT in (select client_id FROM clients) ;
DELETE FROM perm_channel_groups WHERE (server_id > 0 AND server_id NOT in (SELECT server_id FROM servers)) OR id1  NOT IN (SELECT group_id FROM groups_channel) ;
DELETE FROM perm_client WHERE (server_id > 0 AND server_id NOT IN (SELECT server_id FROM servers)) OR id1 NOT IN (SELECT client_id FROM clients) ;
DELETE FROM perm_server_group WHERE (server_id > 0 AND server_id NOT IN (SELECT server_id FROM servers)) OR id1 NOT IN (SELECT group_id FROM groups_server) ;
DELETE FROM server_properties WHERE (server_id > 0 AND server_id NOT IN (SELECT server_id FROM servers)) ;
DELETE FROM tokens WHERE server_id NOT IN (SELECT server_id FROM servers) OR (token_type = 0 and token_id1 NOT IN (SELECT group_id FROM groups_server)) OR (token_type = 1 AND (token_id1 NOT IN (SELECT group_id FROM groups_channel) OR token_id2 NOT IN (SELECT channel_id FROM channels))) ;
DELETE FROM messages WHERE server_id NOT IN (SELECT server_id FROM servers) OR message_to_client_id NOT IN (SELECT client_id FROM clients) ;
DELETE FROM complains WHERE server_id NOT IN (SELECT server_id FROM servers) OR complain_from_client_id NOT IN (SELECT client_id FROM clients) OR complain_to_client_id NOT IN (SELECT client_id FROM clients) ;
DELETE FROM bans WHERE server_id NOT IN (SELECT server_id FROM servers) ;
DELETE FROM client_properties WHERE server_id NOT IN (SELECT server_id FROM servers) OR id NOT IN (SELECT client_id FROM clients) ;
DELETE FROM groups_channel WHERE server_id > 0 AND server_id NOT IN (SELECT server_id FROM servers) ;
DELETE FROM groups_server WHERE server_id > 0 AND server_id NOT IN (SELECT server_id FROM servers) ;
DELETE FROM group_server_to_client WHERE group_id NOT IN (SELECT group_id FROM groups_server) OR (server_id > 0 AND server_id NOT IN (SELECT server_id FROM servers)) OR id1 NOT IN (SELECT client_id FROM clients) ; 
DELETE FROM group_channel_to_client WHERE group_id NOT IN (SELECT group_id FROM groups_channel) OR server_id NOT IN (SELECT server_id FROM servers) OR id1 NOT IN (SELECT client_id FROM clients) OR id2 NOT IN (SELECT channel_id FROM channels) ;
DELETE FROM perm_channel WHERE server_id NOT IN (SELECT server_id FROM servers) OR id1 NOT IN (SELECT channel_id FROM channels) ;

In my database that I've been running since early Jan 2010 it cleaned 4 records (2 in perm_channel_clients, 1 in perm_server_group and the last 1 in tokens). Some of those may not even have the problem, but I was bored and being overly thorough (though I did choose not to remove bans invoked by clients that are no longer in the database, or messages where the from client is no longer in the database).

[Polli]

Hi

I use MySQL-DB and amd64 Version on an Debian5 Root Server.

The Problem is that the Server hangs up after a few days. Restarting does not solve the problem. The Server is not reacheable. The update shows me that i have B29 installed. Im confused and switched back to B29.

Can you reproduce the Problem? Or need more info?

Here are the log-Files

2010-11-24 16:51:06.969880|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta30 [Build: 12998], Linux
2010-11-24 16:51:06.971780|INFO    |DatabaseQuery |   | dbPlugin name:    MySQL plugin, (c)TeamSpeak Systems GmbH
2010-11-24 16:51:06.971857|INFO    |DatabaseQuery |   | dbPlugin version: 1
2010-11-24 16:51:07.040671|INFO    |SQL           |   | database updated successfully to revision: 16
2010-11-24 16:51:07.040990|INFO    |SQL           |   | pruning old database log entries where timestamp is older than 90 days
2010-11-24 16:51:07.062466|INFO    |SQL           |   | pruning old guest clients where last connected time is older than 30 days (this will take a LONG time, dont shutdown the server), clients to remove: 320
2010-11-24 16:51:07.635061|INFO    |SQL           |   | updated permissions to version 9
2010-11-24 16:51:07.697461|INFO    |SQL           |   | updated permissions to version 10
2010-11-24 16:51:07.832299|INFO    |Accounting    |   | Licensing Information
2010-11-24 16:51:07.832380|INFO    |Accounting    |   | type              : Non-profit
2010-11-24 16:51:07.832446|INFO    |Accounting    |   | starting date     : Sun Dec 20 23:00:00 2009
2010-11-24 16:51:07.832482|INFO    |Accounting    |   | ending date       : Mon Dec 20 23:00:00 2010
2010-11-24 16:51:07.832514|INFO    |Accounting    |   | max virtualservers: 10
2010-11-24 16:51:07.832542|INFO    |Accounting    |   | max slots         : 512
2010-11-24 16:51:07.888882|ERROR   |FileManager   |   | bind() failed: 98
2010-11-24 16:51:07.888957|ERROR   |FileManager   |   | bind failed on 0.0.0.0:30033
2010-11-24 16:51:08.146778|ERROR   |VirtualServer |  1| bind failed on 0.0.0.0:9987
2010-11-24 16:51:08.147464|ERROR   |VirtualSvrMgr |   | loading VirtualServer(1) failed to start, error: unable to bind network port
2010-11-24 16:51:08.200781|INFO    |VirtualServer |  1| stopped
2010-11-24 16:51:08.308009|ERROR   |VirtualServer |  3| bind failed on 0.0.0.0:9988
2010-11-24 16:51:08.308475|ERROR   |VirtualSvrMgr |   | loading VirtualServer(3) failed to start, error: unable to bind network port
2010-11-24 16:51:08.400873|INFO    |VirtualServer |  3| stopped
2010-11-24 16:51:08.530012|ERROR   |VirtualServer |  6| bind failed on 0.0.0.0:9989
2010-11-24 16:51:08.530479|ERROR   |VirtualSvrMgr |   | loading VirtualServer(6) failed to start, error: unable to bind network port
2010-11-24 16:51:08.604936|INFO    |VirtualServer |  6| stopped
2010-11-24 16:51:08.661630|ERROR   |VirtualServer |  7| bind failed on 0.0.0.0:9990
2010-11-24 16:51:08.678875|ERROR   |VirtualSvrMgr |   | loading VirtualServer(7) failed to start, error: unable to bind network port
2010-11-24 16:51:08.705211|INFO    |VirtualServer |  7| stopped
2010-11-24 16:51:08.764891|ERROR   |VirtualServer | 10| bind failed on 0.0.0.0:9991
2010-11-24 16:51:08.765507|ERROR   |VirtualSvrMgr |   | loading VirtualServer(10) failed to start, error: unable to bind network port
2010-11-24 16:51:08.805004|INFO    |VirtualServer | 10| stopped
2010-11-24 16:51:08.805621|INFO    |CIDRManager   |   | updated query_ip_whitelist ips: XXXXXX, 
2010-11-24 16:51:08.831179|ERROR   |Query         |   | bind failed on 0.0.0.0:10011

2010-11-24 17:45:21.632668|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta30 [Build: 12998], Linux
2010-11-24 17:45:21.634585|INFO    |DatabaseQuery |   | dbPlugin name:    MySQL plugin, (c)TeamSpeak Systems GmbH
2010-11-24 17:45:21.634661|INFO    |DatabaseQuery |   | dbPlugin version: 1
2010-11-24 17:45:21.640981|ERROR   |DatabaseQuery |   | db_exec() ALTER TABLE instance_properties ADD COLUMN string_id varchar(255);CREA error: Duplicate column name 'string_id'
2010-11-24 17:45:21.641051|ERROR   |SQL           |   | database update to revision: 16 failed!

[dante696]

Polli
Here is your fix
http://forum.teamspeak.com/showthread.php?t=60079