Forum

Results 1 to 2 of 2
  1. #1
    Join Date
    July 2013
    Posts
    6

    Database problem after migration and database bricolage

    Hey there!

    I migrated the server from debian to win 2012 r2. Everything worked fine. I had to edit the ts3server.ini to use mariadb instead of mysql but there was no error afterwards. I started the server to make sure everything is fine. Then, I shutted down the server to try to merge all the servers into one big virtual server. So I edited the server_id columns of all tables except "bindings", "complains" (there were no entries), "custom_fields" (there were no entries), "instance_properties", "messages", "perm_client" (there were no entries), "server_properties", "servers", "teamspeak3_metadata" and "tokens" to the id of the virtual server I wanted them to merge into. Now I get this message in the log file. ("SERVERINSTANCE_TEMPLATE_SERVERADMIN_GROUP points to an not available sgid: 3")

    Is there a way to fix this? Please give me some useful information. I want to make this work.

    My System:
    TS-Server version: 3.0.12.2
    OS: Win 2012 R2 Standard
    Excerpt from logfile:
    Code:
    2016-03-02 16:15:21.946300|INFO    |ServerLibPriv |   |TeamSpeak 3 Server 3.0.12.2 (2016-02-15 14:51:38)
    2016-03-02 16:15:21.946300|INFO    |ServerLibPriv |   |SystemInformation: Windows Server 2012 R2 (9600) x64 (AMD or Intel) Binary: 64bit
    2016-03-02 16:15:21.946300|INFO    |DatabaseQuery |   |dbPlugin name:    MariaDB plugin, (c)TeamSpeak Systems GmbH
    2016-03-02 16:15:21.946300|INFO    |DatabaseQuery |   |dbPlugin version: 1
    2016-03-02 16:15:22.118141|INFO    |Accounting    |   |Licensing Information
    2016-03-02 16:15:22.118141|INFO    |Accounting    |   |type              : Non-profit
    2016-03-02 16:15:22.118141|INFO    |Accounting    |   |starting date     : Mon Aug 31 00:00:00 2015
    2016-03-02 16:15:22.118141|INFO    |Accounting    |   |ending date       : Wed Mar  9 00:00:00 2016
    2016-03-02 16:15:22.118141|INFO    |Accounting    |   |max virtualservers: 10
    2016-03-02 16:15:22.118141|INFO    |Accounting    |   |max slots         : 512
    2016-03-02 16:15:22.165014|CRITICAL|PermissionMgr |   |SERVERINSTANCE_TEMPLATE_SERVERADMIN_GROUP points to an not available sgid: 3
    How often does the error appear?: Everytime at server startup.
    What did you try to fix the problem?: Looked up the table "instance_properties" and "perm_server_group" and checked wether there is a server group with id "3". It is.

  2. #2
    Join Date
    June 2008
    Posts
    18,028
    Modifying the database is not supported from us.

    Please use a working backup or start your server from scratch.
    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?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. database id problem
    By zonEe in forum Linux / FreeBSD
    Replies: 4
    Last Post: June 7th, 2011, 07:02 PM
  2. [Resolved] Database problem, TS can't read channels
    By Emcet in forum Server Support
    Replies: 4
    Last Post: May 10th, 2011, 07:50 AM
  3. TS3 Connection Problem (database error)
    By Quittolo in forum Windows
    Replies: 2
    Last Post: November 11th, 2010, 07:08 PM
  4. sql database problem
    By yomega in forum Linux / FreeBSD
    Replies: 3
    Last Post: January 2nd, 2010, 02:15 AM

Tags for this Thread

Posting Permissions

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