Forum

Results 1 to 5 of 5
  1. #1
    Join Date
    July 2014
    Posts
    3

    TS3 server Debian MariaDB not working (Permissions bug?)

    Hello,

    I have been running a Teamspeak3 server with a MySQL for a long time but since now we are upgrading our
    platform and are now running on MariaDB (pretty much the same, I know).

    I setup the server with SQL stuff setting clear_database=1 on the first boot and then setting it to 0.
    It creates all of the tables fine and reportes that the tables was created.
    Code:
    db_CreateTables() tables droped
    db_CreateTables() tables created

    Then I recieve this message in the log; I then found this http://forum.teamspeak.com/showthrea...-5-1-on-gentoo
    Code:
    CRITICAL|PermissionMgr | | SERVERINSTANCE_TEMPLATE_CHANNELDEFAULT_GROUP points to an not available cgid: 4
    I tried this ugly fix by running the following query.
    Code:
    INSERT INTO `groups_channel` (`group_id`, `server_id`, `name`, `type`) VALUES (4, 0, 'Test', 0);
    Now the server starts but all people is seens as "Server Admin [temp]" as server group, I tried executing the token but
    it failed saying something on the lines with "you cannot be added to the default server group".
    If I create a token manually for the virtualserver id 1 with the Server Admin group I get "Invalid group id" stuff when using the token.

    I'm on Debian Wheezy and MySQL/MariaDB is.
    Code:
    mysql  Ver 15.1 Distrib 10.0.12-MariaDB, for debian-linux-gnu (x86_64) using readline 5.1
    I downloaded the Teamspeak3 amd64 server files.
    I'm starting the server with the ts3server_startscript.sh script using the following extra parameters
    Code:
    COMMANDLINE_PARAMETERS="${2} dbplugin=ts3db_mysql dbsqlcreatepath=create_mysql/ clear_database=0"
    ts3db_mysql.ini
    Code:
    [config]
    host='127.0.0.1'
    port='3306'
    username='ts3user'
    password='test123'
    database='ts3'
    socket=
    ts3server.ini
    Code:
    machine_id=
    default_voice_port=9987
    voice_ip=0.0.0.0
    liscensepath=
    filetransfer_port=30033
    filetransfer_ip=0.0.0.0
    query_port=10011
    query_ip=0.0.0.0
    dbplugin=ts3db_mysql
    dbpluginparameter=ts3db_mysql.ini
    dbsqlpath=sql/
    dbsqlcreatepath=create_mysql/
    logpath=logs
    logquerycommands=1
    It's also warning about this:
    Code:
    PermGroupMgr  |   | cldbid: 1, assigned to unknown gid: 2, ignoring!
    I'm also wondering why it creates a virtualserver with id 1 when there is a virtualserver with id 0 in the database?
    I tried creating the token like this:
    Code:
    MariaDB [ts3]> select * from groups_server;
    +----------+-----------+--------------------+------+
    | group_id | server_id | name               | type |
    +----------+-----------+--------------------+------+
    |        1 |         0 | Guest Server Query |    2 |
    |        3 |         0 | Admin Server Query |    2 |
    |        5 |         0 | Server Admin       |    0 |
    |        7 |         0 | Normal             |    0 |
    |        9 |         0 | Guest              |    0 |
    |       11 |         1 | Server Admin       |    1 |
    |       13 |         1 | Normal             |    1 |
    |       15 |         1 | Guest              |    1 |
    +----------+-----------+--------------------+------+
    8 rows in set (0.00 sec)
    
    MariaDB [ts3]> INSERT INTO tokens (server_id, token_key, token_type, token_id1, token_id2) VALUES ('1', 'test', '0', '11', '0');
    When I try to enter the "test" token in teamspeak I get this error.
    "Failed to use Privilege Key: access to default group is forbidden"

    This is how the groups looks like and the default values in the server_properties:
    Code:
    MariaDB [ts3]> select * from groups_server;
    +----------+-----------+--------------------+------+
    | group_id | server_id | name               | type |
    +----------+-----------+--------------------+------+
    |        1 |         0 | Guest Server Query |    2 |
    |        3 |         0 | Admin Server Query |    2 |
    |        5 |         0 | Server Admin       |    0 |
    |        7 |         0 | Normal             |    0 |
    |        9 |         0 | Guest              |    0 |
    |       11 |         1 | Server Admin       |    1 |
    |       13 |         1 | Normal             |    1 |
    |       15 |         1 | Guest              |    1 |
    +----------+-----------+--------------------+------+
    8 rows in set (0.00 sec)
    
    MariaDB [ts3]> select * from groups_channel;
    +----------+-----------+---------------+------+
    | group_id | server_id | name          | type |
    +----------+-----------+---------------+------+
    |        1 |         0 | Channel Admin |    0 |
    |        3 |         0 | Operator      |    0 |
    |        4 |         0 | Test|    0 |
    |        5 |         0 | Voice         |    0 |
    |        7 |         0 | Guest         |    0 |
    |        9 |         1 | Channel Admin |    1 |
    |       11 |         1 | Operator      |    1 |
    |       13 |         1 | Test  |    1 |
    |       15 |         1 | Voice         |    1 |
    |       17 |         1 | Guest         |    1 |
    +----------+-----------+---------------+------+
    10 rows in set (0.00 sec)
    
    MariaDB [ts3]> select * from server_properties where ident like '%default_%_group';
    +-----------+------+-------------------------------------------+-------+
    | server_id | id   | ident                                     | value |
    +-----------+------+-------------------------------------------+-------+
    |         1 |    1 | virtualserver_default_server_group        | 11    |
    |         1 |    1 | virtualserver_default_channel_group       | 13    |
    |         1 |    1 | virtualserver_default_channel_admin_group | 9     |
    +-----------+------+-------------------------------------------+-------+
    3 rows in set (0.00 sec)
    Can anybody help me or has had the same problem before?
    I can remember I had a similar but much smaller problem when I first setup the old teamspeak3 server with MySQL backend but I can't remember what I did, I should have written it down.

    Thanks for any help!
    Best regards

  2. #2
    Join Date
    September 2012
    Posts
    6,076
    Unless you're specifying "infile=ts3server.ini" on the command line when starting, the server won't know anything about the database.
    Messing around with the database manually is not supported.

    Start again from scratch by downloading the latest server version from our official page, then setup your ts3db_maria.ini and your ts3server.ini files properly, with the correct and required information and start your server like this: ./ts3server_startscript.sh start inifile=ts3server.ini
    All the other stuff should be in the ts3server.ini which will also mention your ts3db_maria.ini in the dbpluginparameter line. No need to specify any of that on the command line as well.
    Please note that using MariaDB is not officially supported, there might be some differences to MySQL, that may cause stuff to not work.
    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
    July 2014
    Posts
    3
    Hello Chris,
    Thanks for your support but I must say that was not helpful at all.

    With a clean Teamspeak 3 server an empty database and settings
    Code:
    COMMANDLINE_PARAMETERS="inifile=ts3server.ini"
    This is what happens:
    Code:
    2014-07-12 10:10:57.995922|INFO    |ServerLibPriv |   | TeamSpeak 3 Server 3.0.10.3 (2014-01-01 16:28:39)
    2014-07-12 10:10:57.996011|INFO    |ServerLibPriv |   | SystemInformation: Linux 3.2.0-4-amd64 #1 SMP Debian 3.2.57-3+deb7u2 x86_64 Binary: 64bit
    2014-07-12 10:10:57.996036|INFO    |ServerLibPriv |   | Using hardware aes
    2014-07-12 10:10:57.997840|INFO    |DatabaseQuery |   | dbPlugin name:    MySQL plugin, (c)TeamSpeak Systems GmbH
    2014-07-12 10:10:57.997871|INFO    |DatabaseQuery |   | dbPlugin version: 1
    2014-07-12 10:11:08.159949|INFO    |SQL           |   | db_CreateTables() tables created
    2014-07-12 10:11:46.786248|WARNING |Accounting    |   | Unable to find valid license key, falling back to limited functionality
    2014-07-12 10:11:47.294047|WARNING |PermGroupMgr  |   | cldbid: 1, assigned to unknown gid: 2, ignoring!
    2014-07-12 10:11:47.295445|CRITICAL|PermissionMgr |   | SERVERINSTANCE_TEMPLATE_CHANNELDEFAULT_GROUP points to an not available cgid: 4
    ts3server.ini
    Code:
    machine_id=
    default_voice_port=9987
    voice_ip=0.0.0.0
    liscensepath=
    filetransfer_port=30033
    filetransfer_ip=0.0.0.0
    query_port=10011
    query_ip=0.0.0.0
    dbplugin=ts3db_mysql
    dbpluginparameter=ts3db_mysql.ini
    dbsqlpath=sql/
    dbsqlcreatepath=create_mysql/
    logpath=logs
    logquerycommands=1
    ts3db_mysql.ini
    Code:
    [config]
    host='127.0.0.1'
    port='3306'
    username='ts3'
    password='test123'
    database='ts3'
    socket=
    If you try this ugly "fix":
    Code:
    INSERT INTO `groups_channel` (`group_id`, `server_id`, `name`, `type`) VALUES (4, 0, 'Test', 0);
    The server actually boots.
    Code:
    2014-07-12 10:13:53.159312|INFO    |ServerLibPriv |   | TeamSpeak 3 Server 3.0.10.3 (2014-01-01 16:28:39)
    2014-07-12 10:13:53.159402|INFO    |ServerLibPriv |   | SystemInformation: Linux 3.2.0-4-amd64 #1 SMP Debian 3.2.57-3+deb7u2 x86_64 Binary: 64bit
    2014-07-12 10:13:53.159429|INFO    |ServerLibPriv |   | Using hardware aes
    2014-07-12 10:13:53.161277|INFO    |DatabaseQuery |   | dbPlugin name:    MySQL plugin, (c)TeamSpeak Systems GmbH
    2014-07-12 10:13:53.161305|INFO    |DatabaseQuery |   | dbPlugin version: 1
    2014-07-12 10:13:53.168159|WARNING |Accounting    |   | Unable to find valid license key, falling back to limited functionality
    2014-07-12 10:13:53.675569|WARNING |PermGroupMgr  |   | cldbid: 1, assigned to unknown gid: 2, ignoring!
    2014-07-12 10:13:56.150285|INFO    |              |   | Puzzle precompute time: 2474
    2014-07-12 10:13:56.156589|INFO    |FileManager   |   | listening on 0.0.0.0:30033
    2014-07-12 10:13:56.616306|INFO    |VirtualSvrMgr |   | executing monthly interval
    2014-07-12 10:13:56.616766|INFO    |VirtualSvrMgr |   | reset virtualserver traffic statistics
    2014-07-12 10:14:02.347364|INFO    |CIDRManager   |   | updated query_ip_whitelist ips: 127.0.0.1,
    2014-07-12 10:14:02.347686|INFO    |Query         |   | listening on 0.0.0.0:10011
    2014-07-12 10:14:00.590960|INFO    |VirtualServer |  1| listening on 0.0.0.0:9987
    2014-07-12 10:14:00.625669|INFO    |VirtualServer |  1| client 'server'(id:0) added privilege key for servergroup ''(id:0)
    2014-07-12 10:14:00.625700|WARNING |VirtualServer |  1| --------------------------------------------------------
    2014-07-12 10:14:00.625715|WARNING |VirtualServer |  1| ServerAdmin privilege key created, please use the line below
    2014-07-12 10:14:00.625728|WARNING |VirtualServer |  1| token=xxx
    2014-07-12 10:14:00.625741|WARNING |VirtualServer |  1| --------------------------------------------------------
    But when executing the "token" you get:
    Code:
    Failed to use Privilege Key: invalid group ID
    Also the default server groups is defined like this
    Code:
    Default server group: Server Admin [temp]
    Default channel group: Test [temp]
    As you can see here:
    Code:
    MariaDB [ts3]> select * from groups_server;
    +----------+-----------+--------------------+------+
    | group_id | server_id | name               | type |
    +----------+-----------+--------------------+------+
    |        1 |         0 | Guest Server Query |    2 |
    |        3 |         0 | Admin Server Query |    2 |
    |        5 |         0 | Server Admin       |    0 |
    |        7 |         0 | Normal             |    0 |
    |        9 |         0 | Guest              |    0 |
    |       11 |         1 | Server Admin       |    1 |
    |       13 |         1 | Normal             |    1 |
    |       15 |         1 | Guest              |    1 |
    +----------+-----------+--------------------+------+
    8 rows in set (0.00 sec)
    
    MariaDB [ts3]> select * from groups_channel;
    +----------+-----------+---------------+------+
    | group_id | server_id | name          | type |
    +----------+-----------+---------------+------+
    |        1 |         0 | Channel Admin |    0 |
    |        3 |         0 | Operator      |    0 |
    |        4 |         0 | Test          |    0 |
    |        5 |         0 | Voice         |    0 |
    |        7 |         0 | Guest         |    0 |
    |        9 |         1 | Channel Admin |    1 |
    |       11 |         1 | Operator      |    1 |
    |       13 |         1 | Test          |    1 |
    |       15 |         1 | Voice         |    1 |
    |       17 |         1 | Guest         |    1 |
    +----------+-----------+---------------+------+
    10 rows in set (0.00 sec)
    
    MariaDB [ts3]> select * from server_properties where ident like 'virtualserver_default_%_group';
    +-----------+------+-------------------------------------------+-------+
    | server_id | id   | ident                                     | value |
    +-----------+------+-------------------------------------------+-------+
    |         1 |    1 | virtualserver_default_server_group        | 11    |
    |         1 |    1 | virtualserver_default_channel_group       | 13    |
    |         1 |    1 | virtualserver_default_channel_admin_group | 9     |
    +-----------+------+-------------------------------------------+-------+
    3 rows in set (0.00 sec)
    Do you have any suggestions?
    Best regards
    Last edited by triggerim; July 12th, 2014 at 11:18 AM.

  4. #4
    Join Date
    April 2011
    Location
    Germany
    Posts
    1,266
    As was said before... how would it be if you used an actually supported db... like MySQL or SQLite... MariaDB even as a fork of MySQL is officially not supported.

  5. #5
    Join Date
    July 2014
    Posts
    3
    No shit sherlock... I was looking for a solution.
    Anyhow I got it resolved.

    Also while I'm at it; it's just ridiculous how Teamspeak still is dependent on libmysqlclient15off...
    Welcome to 2014!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. TS3-Server stops after about 24 minutes using MariaDB
    By whfor in forum Linux / FreeBSD
    Replies: 2
    Last Post: April 15th, 2015, 03:53 PM
  2. Ts3 not working Mariadb
    By PRAWKC in forum Linux / FreeBSD
    Replies: 2
    Last Post: January 28th, 2015, 07:44 AM
  3. Teamspeak server shutdown randomly (3.0.11.1 MariaDB)
    By xxFankxx in forum Server Support
    Replies: 4
    Last Post: December 12th, 2014, 01:00 AM
  4. Server Admin permissions not working
    By Armageddonn in forum General Questions
    Replies: 0
    Last Post: June 17th, 2011, 06:55 AM
  5. Replies: 12
    Last Post: January 21st, 2011, 02:34 PM

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
  •