Forum

Page 1 of 5 123 ... LastLast
Results 1 to 15 of 69
  1. #1
    Join Date
    September 2012
    Posts
    6,035

    TeamSpeak 3 Server 3.0.11.2 released

    Server version 3.0.11 is now available for download.

    The are some major changes in the MySQL database plugin, as well as some changes regarding query clients and permissions.
    We highly recommend making a backup of your existing database before testing this server, especially if you're using a MySQL database.

    Most notable changes in this upcoming server release are:
    • The MySQL plugin was removed in favor of Maria DB. At least MySQL 5.5.3 or MariaDB 5.5 are now required to run the server if you don't want to use the default SQLite database.
      You must convert your current MySQL database for Maria DB and utf8mb4 support. Please read the documentation for further details and instructions.
    • Guest ServerQuery clients' permissions can now be restricted with the negate flag. Many users had problems with query clients spamming chat messages and channels and this change allows to restrict this without affecting regular users. New server instances will restrict this by default, however for existing instances you'll have to modify the permissions accordingly if you wish to have this effect.
    • Query client logins are now bound to the server on which they were created and only receive that users' permissions on the virtual server they were created and will be treated as guest on other virtual servers.


    Please note that an SSE2 capable CPU is required to run the server on Windows.

    Full changelog below:
    Code:
    === Server Release 3.0.11.2 15 dec 2014
     - fixed possible deadlock in server query
     - fixed a mariadb/mysql db creation issue
     - fixed a mariadb/mysql performance issue
     - fixed a server query crash
    
    === Server Release 3.0.11.1 15 oct 2014
     - Small accounting fix
    
    === Server Release 3.0.11 30 sep 2014
     ! Starting this release, TS3 servers will not support the Mac OSX PowerPC architecture.
     ! Starting this release the Windows version of the server requires an SSE2 capable CPU.
     ! Starting 3.0.12 (next release), TS3 server won't support OSX 10.6 or lower.
     ! Starting this release, the MySQL database plugin has been replaced by a MariaDB plugin. Please
       read doc/update_mysql_to_mariadb.txt for instructions on how to update. Also note the default
       character set for the database is now 'utf8mb4', which means the server needs to be at least
       MySQL 5.5.3 or MariaDB 5.5 .
     ! When a new database is created, we will be using a few extra defaults for the Guest Server Query
       group. Permissions for existing databases will be left untouched.
       The new defaults for the Guest Server Query group should prevent the Server Query from being
       abused with spam. The extra permissions are:
       * b_channel_join_permanent = false, negate = true, skip = true
       * b_channel_join_semi_permanent = false, negate = true, skip = true
       * b_channel_join_temporary = false, negate = true, skip = true
       * b_channel_create_permanent = false, negate = true, skip = true
       * b_channel_create_semi_permanent = false, negate = true, skip = true
       * b_channel_create_temporary = false, negate = true, skip = true
       * b_client_server_textmessage_send = false, negate = true, skip = true
       * b_client_channel_textmessage_send = false, negate = true, skip = true
       * b_client_offline_textmessage_send = false, negate = true, skip = true
       * i_client_private_textmessage_power = -1, negate = true, skip = true
       * i_client_poke_power = -1, negate = true, skip = true
     ! If only 1 serveradmin is logged into the query, this serveradmin can select any server (use)
       regardless of the client limit.
     ! The "Wan IP" feature of the windows server has been removed as it does not work any more.
       If you want to know your wan ip address, use an existing free service like http://ipinfo.io
     + Updated ip2location database
     + Better checking and better error message for errors with query white/blacklists.
     - Fixed crash relating to invalid ip addresses on FreeBSD.
     - Fixed a possible crash during client connect.
     - Fixed channel event notifications stop working after a while.
     - Fixed query logins getting permissions on other virtual servers.
     - Fixed crash when deleting complaints.
     - Fixed issue where clients were not deleted from the database after dbclientkeepdays when
       connecting several TS3 servers to the same database with different dbclientkeepdays values.
     - The server instance no longer starts copies of virtual servers.
     - Guest ServerQuery user now always has default server query group, even while using a virtual
       server.
     - Instance server group permissions now honor the negate flag.
     - Temporary passwords and tokens(privilege keys) of a client are deleted when the client is deleted
       from the database.
     - Complaints of and about a client are deleted when the client is deleted from the database.
     - Fixed possible server hang with query connections.
     - ts3server_startscript.sh restart now works with parameters.
     - ts3server_startscript.sh does a better test for FreeBSD.
    Last edited by Chris; December 16th, 2014 at 08:23 AM. Reason: Updated for server 3.0.11.2

  2. #2
    Join Date
    September 2012
    Posts
    6,035
    To update an existing instance to use the new default restricted permissions for query guests use the following commands on the query interface:

    Code:
    login serveradmin PASSWORD
    servergroupautoaddperm sgtype=20 permsid=b_channel_join_permanent permvalue=0 permskip=1 permnegated=1|permsid=b_channel_join_semi_permanent permvalue=0 permskip=1 permnegated=1|permsid=b_channel_join_temporary permvalue=0 permskip=1 permnegated=1|permsid=b_channel_create_permanent permvalue=0 permskip=1 permnegated=1|permsid=b_channel_create_semi_permanent permvalue=0 permskip=1 permnegated=1|permsid=b_channel_create_temporary permvalue=0 permskip=1 permnegated=1|permsid=b_client_server_textmessage_send permvalue=0 permskip=1 permnegated=1|permsid=b_client_channel_textmessage_send permvalue=0 permskip=1 permnegated=1|permsid=b_client_offline_textmessage_send permvalue=0 permskip=1 permnegated=1|permsid=i_client_private_textmessage_power permvalue=-1 permskip=1 permnegated=1|permsid=i_client_poke_power permvalue=-1 permskip=1 permnegated=1
    Or run the following (Replace ANY_ACTIVE_PORT with a port of a running TS3 Server in your instance and PASSWORD with your actual password for the query):
    Code:
    login serveradmin PASSWORD
    use port=ANY_ACTIVE_PORT
    servergroupaddperm sgid=1 permsid=b_channel_join_permanent permvalue=0 permskip=1 permnegated=1|permsid=b_channel_join_semi_permanen t permvalue=0 permskip=1 permnegated=1|permsid=b_channel_join_temporary permvalue=0 permskip=1 permnegated=1|permsid=b_channel_create_permanent permvalue=0 permskip=1 permnegated=1|permsid=b_channel_create_semi_perman ent permvalue=0 permskip=1 permnegated=1|permsid=b_channel_create_temporary permvalue=0 permskip=1 permnegated=1|permsid=b_client_server_textmessage_ send permvalue=0 permskip=1 permnegated=1|permsid=b_client_channel_textmessage _send permvalue=0 permskip=1 permnegated=1|permsid=b_client_offline_textmessage _send permvalue=0 permskip=1 permnegated=1|permsid=i_client_private_textmessage _power permvalue=-1 permskip=1 permnegated=1|permsid=i_client_poke_power permvalue=-1 permskip=1 permnegated=1
    Last edited by Chris; February 13th, 2017 at 03:00 PM.
    When sending PMs please make sure to include a reference link to the thread in question in the body of your message.

  3. #3
    Join Date
    December 2009
    Location
    UK
    Posts
    759
    Upgraded no problems using SQLite, but I foresee a lot of problems from MySQL users who don't bother reading changelogs (yes I know it's their fault if they crash & burn & don't have a backup)

  4. #4
    Join Date
    November 2010
    Location
    N/A
    Posts
    4
    Hey, I'm using MySQL (5.5.38) and tested the update on a local machine. After the first start of the instance all channels are deleted, except the lobby. Any ideas why this happens? I had to restore the "channels", "channel_properties" & "perm_channel" tables with my backup that I created before converting the tables - only then the server keeps the channels.

    Regards, Eggerd

  5. #5
    Join Date
    June 2008
    Posts
    17,065
    It's nothing, that happend during our tests.
    Did you read the update_mysql_to_mariadb.txt before updating?

    Any server logs availabale?
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread? ||NPL (Registration)

  6. #6
    Join Date
    November 2010
    Location
    N/A
    Posts
    4
    Yes, I read the update_mysql_to_mariadb.txt and followed the steps on my local test machine.
    The server logs show the following:

    Code:
    2014-09-30 10:13:12.293175|ERROR   |ChanClients   |  1| ChanClients() unable to add channel(ID: 2), skipping. Error was: convert error
    2014-09-30 10:13:12.293175|ERROR   |ChanClients   |  1| ChanClients() unable to load channel(ID: 2) from db (missing channelOrderID: 1), deleting.
    2014-09-30 10:13:12.312176|ERROR   |ChanClients   |  1| ChanClients() unable to load channel(ID: 3) from db (missing channelOrderID: 2), deleting.
    2014-09-30 10:13:12.335178|ERROR   |ChanClients   |  1| ChanClients() unable to load channel(ID: 23) from db (missing channelOrderID: 3), deleting.
    2014-09-30 10:13:12.349178|ERROR   |ChanClients   |  1| ChanClients() unable to load channel(ID: 25) from db (missing channelOrderID: 23), deleting.
    2014-09-30 10:13:12.372180|ERROR   |ChanClients   |  1| ChanClients() invalid channel structure, not all channels could be loaded
    2014-09-30 10:13:12.372180|WARNING |ChanClients   |  1| failed to load: cID: 4 pcID: 2 deleting channel!
    2014-09-30 10:13:12.390181|WARNING |ChanClients   |  1| failed to load: cID: 5 pcID: 4 deleting channel!
    2014-09-30 10:13:12.409182|WARNING |ChanClients   |  1| failed to load: cID: 6 pcID: 4 deleting channel!
    2014-09-30 10:13:12.427183|WARNING |ChanClients   |  1| failed to load: cID: 7 pcID: 4 deleting channel!
    2014-09-30 10:13:12.446184|WARNING |ChanClients   |  1| failed to load: cID: 8 pcID: 4 deleting channel!
    2014-09-30 10:13:12.459185|WARNING |ChanClients   |  1| failed to load: cID: 9 pcID: 4 deleting channel!
    2014-09-30 10:13:12.482186|WARNING |ChanClients   |  1| failed to load: cID: 10 pcID: 4 deleting channel!
    2014-09-30 10:13:12.494187|WARNING |ChanClients   |  1| failed to load: cID: 11 pcID: 4 deleting channel!
    2014-09-30 10:13:12.507187|WARNING |ChanClients   |  1| failed to load: cID: 12 pcID: 4 deleting channel!
    2014-09-30 10:13:12.526189|WARNING |ChanClients   |  1| failed to load: cID: 13 pcID: 2 deleting channel!
    2014-09-30 10:13:12.544190|WARNING |ChanClients   |  1| failed to load: cID: 14 pcID: 4 deleting channel!
    2014-09-30 10:13:12.562191|WARNING |ChanClients   |  1| failed to load: cID: 15 pcID: 13 deleting channel!
    2014-09-30 10:13:12.580192|WARNING |ChanClients   |  1| failed to load: cID: 16 pcID: 13 deleting channel!
    2014-09-30 10:13:12.599193|WARNING |ChanClients   |  1| failed to load: cID: 17 pcID: 13 deleting channel!
    2014-09-30 10:13:12.617194|WARNING |ChanClients   |  1| failed to load: cID: 18 pcID: 2 deleting channel!
    2014-09-30 10:13:12.637195|WARNING |ChanClients   |  1| failed to load: cID: 19 pcID: 13 deleting channel!
    2014-09-30 10:13:12.662196|WARNING |ChanClients   |  1| failed to load: cID: 20 pcID: 18 deleting channel!
    2014-09-30 10:13:12.697198|WARNING |ChanClients   |  1| failed to load: cID: 21 pcID: 18 deleting channel!
    2014-09-30 10:13:12.738201|INFO    |VirtualServer |  1| listening on 0.0.0.0:9987

  7. #7
    Join Date
    June 2008
    Posts
    17,065
    Channel ID2 wasn't converted for the new system.
    This channel was deleted and caused that all sub-channels did loose their parent channel and all other channels did loose their sort order.

    I would like to check and reproduce this.
    Can you send me the database, before (the update was done)?
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread? ||NPL (Registration)

  8. #8
    Join Date
    April 2011
    Location
    Germany
    Posts
    1,266
    Upgraded my server... so far all seems fine.

    Good job!

  9. #9
    Join Date
    May 2007
    Location
    Eastern NC
    Posts
    1,723
    Thank you. Update appears to be working fine on my servers using SQLite backend.

  10. #10
    Join Date
    November 2010
    Location
    N/A
    Posts
    4
    Will try my best.. had a fire in the kitchen and currently no access to my PC..

  11. #11
    Join Date
    May 2012
    Location
    The 3rd dimension
    Posts
    956
    I am happy that guest query got locked down to prevent creating channels and messaging people. However I am not happy that you are no longer able to easily assign server groups any longer to customize what you want guest serverquery to be able to do. Especially since some websites require certain settings to be set up in order for your server to be recognised fully on their system. It is no good if there is no way a typical user can make such changes. So I request a reversal of just the part which is blocking people assigning servergroups to the ServerQuery UID to allow the customization of the permissions should a server owner desire or be required to comply with a scanning website's requirements.

  12. #12
    Join Date
    December 2009
    Location
    New Jersey USA
    Posts
    77
    I got this error;

    Code:
    2014-10-01 01:09:49.771202|INFO    |ServerLibPriv |   | TeamSpeak 3 Server 3.0.11 (2014-09-29 15:33:46)
    2014-10-01 01:09:49.771359|INFO    |ServerLibPriv |   | SystemInformation: Linux 2.6.18-371.12.1.el5.centos.plusPAE #1 SMP Wed Sep 3 22:37:52 EDT 2014 i686 Binary: 32bit
    2014-10-01 01:09:49.772578|INFO    |DatabaseQuery |   | dbPlugin name:    MariaDB plugin, (c)TeamSpeak Systems GmbH
    2014-10-01 01:09:49.772644|INFO    |DatabaseQuery |   | dbPlugin version: 1
    2014-10-01 01:09:49.773438|ERROR   |DatabaseQuery |   | mysql_real_connect() failed with error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
    2014-10-01 01:09:49.773508|CRITICAL|ServerLibPriv |   | Server() unable to initialize database
    Last edited by Chris; October 1st, 2014 at 08:15 AM.

  13. #13
    Join Date
    September 2012
    Posts
    6,035
    Quote Originally Posted by BaDaSS View Post
    I got this error;

    Code:
    2014-10-01 01:09:49.771202|INFO    |ServerLibPriv |   | TeamSpeak 3 Server 3.0.11 (2014-09-29 15:33:46)
    2014-10-01 01:09:49.771359|INFO    |ServerLibPriv |   | SystemInformation: Linux 2.6.18-371.12.1.el5.centos.plusPAE #1 SMP Wed Sep 3 22:37:52 EDT 2014 i686 Binary: 32bit
    2014-10-01 01:09:49.772578|INFO    |DatabaseQuery |   | dbPlugin name:    MariaDB plugin, (c)TeamSpeak Systems GmbH
    2014-10-01 01:09:49.772644|INFO    |DatabaseQuery |   | dbPlugin version: 1
    2014-10-01 01:09:49.773438|ERROR   |DatabaseQuery |   | mysql_real_connect() failed with error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
    2014-10-01 01:09:49.773508|CRITICAL|ServerLibPriv |   | Server() unable to initialize database
    Fix your database connection information in the ini file or use SQLite.

    Quote Originally Posted by Morthawt View Post
    However I am not happy that you are no longer able to easily assign server groups any longer to customize what you want guest serverquery to be able to do.
    This was never supported or supposed to work anyway.
    If you use or want to use services that don't provide the ability to log in, then you'll have to add the permissions that service requires to the query guest group (if you want it to be available on all virtual servers) or the regular guest group of the virtual server (if you want it only available on a specific virtual server).
    Last edited by Chris; October 1st, 2014 at 10:11 AM.
    When sending PMs please make sure to include a reference link to the thread in question in the body of your message.

  14. #14
    Join Date
    May 2012
    Location
    The 3rd dimension
    Posts
    956
    So if you modify the Guest server group (the normal guest that comes with the server) it will impact the ServerQuery UID account to enable the permissions needed as before? At least that is something positive. Although not as convenient as having several servergroups set up to easily toggle between query being able to do this this and that, vs at the drop of a hat being able to temporarily remove all those abilities and maybe instead only allow this and that. With having to do everything on the guest servergroup, that is more to keep track of.
    Last edited by Morthawt; October 1st, 2014 at 02:13 PM.

  15. #15
    Join Date
    July 2007
    Location
    Germany
    Posts
    68
    Quote Originally Posted by BaDaSS View Post
    I got this error;

    Code:
    2014-10-01 01:09:49.771202|INFO    |ServerLibPriv |   | TeamSpeak 3 Server 3.0.11 (2014-09-29 15:33:46)
    2014-10-01 01:09:49.771359|INFO    |ServerLibPriv |   | SystemInformation: Linux 2.6.18-371.12.1.el5.centos.plusPAE #1 SMP Wed Sep 3 22:37:52 EDT 2014 i686 Binary: 32bit
    2014-10-01 01:09:49.772578|INFO    |DatabaseQuery |   | dbPlugin name:    MariaDB plugin, (c)TeamSpeak Systems GmbH
    2014-10-01 01:09:49.772644|INFO    |DatabaseQuery |   | dbPlugin version: 1
    2014-10-01 01:09:49.773438|ERROR   |DatabaseQuery |   | mysql_real_connect() failed with error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
    2014-10-01 01:09:49.773508|CRITICAL|ServerLibPriv |   | Server() unable to initialize database
    I had the same problem, you need to delete the the socket line if you wrote this in your db.ini and don't need it.
    And if you have localhost as ip, you must change it to 127.0.0.1.

    It worked for me, server runs again like a charm ^^

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 26
    Last Post: April 8th, 2014, 10:05 PM
  2. TeamSpeak 3 Server 3.0.10 released
    By Chris in forum Archive
    Replies: 8
    Last Post: October 24th, 2013, 10:43 AM
  3. TeamSpeak server 3.0.9 released
    By dante696 in forum Archive
    Replies: 39
    Last Post: September 22nd, 2013, 03:15 PM
  4. TeamSpeak server 3.0.8 released
    By Chris in forum Archive
    Replies: 14
    Last Post: September 12th, 2013, 09:48 AM
  5. TeamSpeak Server 3.0.7.2 released
    By Chris in forum Archive
    Replies: 10
    Last Post: May 20th, 2013, 05:32 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •