Forum

Results 1 to 2 of 2
  1. #1
    Join Date
    August 2011
    Posts
    2

    Lightbulb Install TS3 RC1 with mysql >=5.1 on gentoo

    Hello,

    after hours working on this problem i have found a workaround to install it.
    Use this workaround on your own risk..

    Code:
    emerge media-sound/teamspeak-server-bin -v
    create a database...
    Code:
    mysqladmin create ts3db -p
    create a file ts3db_mysql.ini
    Code:
    cd /opt/teamspeak3-server/
    vim ts3db_mysql.ini
    Code:
    [config]
    host=localhost
    port=3306
    username=ts3db
    password=XXXXXXXX
    database=ts3db
    socket=
    edit your config and get a ts3 license ...
    Code:
    vim /etc/teamspeak3-server/server.conf
    machine_id=
    default_voice_port=9987
    voice_ip=0.0.0.0
    licensepath=/opt/teamspeak3-server/ <- folder to your license...
    filetransfer_port=30033
    filetransfer_ip=0.0.0.0
    query_port=10011
    query_ip=0.0.0.0
    dbplugin=ts3db_mysql.ini
    dbpluginparameter=ts3db_mysql.ini
    dbsqlpath=sql/
    dbsqlcreatepath=create_mysql/
    logpath=/var/log/teamspeak3-server/
    logquerycommands=1
    Download libmysqlclient.so.15.0.0 if you havent this file and copy it to /opt/teamspeak3-server/


    create some symlinks...
    Code:
    ln -s libts3db_mysql.so libts3db_mysql.ini.so 
    ln -s libmysqlclient.so.15.0.0 libmysqlclient.so.15
    start ts3 by hand and set clear database to 1 (if a new install) because its the first start ...
    ts3server dbplugin=ts3db_mysql dbsqlcreatepath=create_mysql/ clear_database=1
    TeamSpeak Server 3.0.0-rc1 [Build: 14468]
    (c)TeamSpeak Systems GmbH

    Logging started
    2011-08-10 07:19:49.713510|INFO |ServerLibPriv | | Server Version: 3.0.0-rc1 [Build: 14468], Linux
    2011-08-10 07:19:49.714372|INFO |DatabaseQuery | | dbPlugin name: MySQL plugin, (c)TeamSpeak Systems GmbH
    2011-08-10 07:19:49.714422|INFO |DatabaseQuery | | dbPlugin version: 1
    2011-08-10 07:19:49.723846|INFO |SQL | | db_CreateTables() tables droped
    2011-08-10 07:19:49.871061|INFO |SQL | | db_CreateTables() tables created

    ------------------------------------------------------------------
    I M P O R T A N T
    ------------------------------------------------------------------
    Server Query Admin Acccount created
    loginname= "serveradmin", password= "2hqlxfdB"
    ------------------------------------------------------------------


    2011-08-10 07:19:53.544452|INFO |Accounting | | Licensing Information
    2011-08-10 07:19:53.544542|INFO |Accounting | | type : Non-profit
    2011-08-10 07:19:53.544618|INFO |Accounting | | starting date : Fri Jul 15 00:00:00 2011
    2011-08-10 07:19:53.544662|INFO |Accounting | | ending date : Sun Jul 15 00:00:00 2012
    2011-08-10 07:19:53.544704|INFO |Accounting | | max virtualservers: 10
    2011-08-10 07:19:53.544742|INFO |Accounting | | max slots : 512
    2011-08-10 07:19:53.562010|WARNING |PermGroupMgr | | cldbid: 1, assigned to unknown gid: 2, ignoring!
    2011-08-10 07:19:53.563977|CRITICAL|PermissionMgr | | SERVERINSTANCE_TEMPLATE_CHANNELDEFAULT_GROUP points to an not available cgid: 4
    Don't forgot the serveradmin password , token

    now we have the problem with group ID thats per default not exist...
    also next workaround...

    i use root to edit it but u can also use your ts3db user...
    mysql -p
    Enter password: xxxx

    mysql> use ts3db;
    mysql> INSERT INTO `groups_channel` (`group_id`, `server_id`, `name`, `type`) VALUES (4, 0, 'Testgrp', 0);
    Query OK, 1 row affected (0.00 sec)
    exit
    so now you can start your tsserver. Be sure that you change the parameter clear_database from 1 to 0

    ts3server dbplugin=ts3db_mysql dbsqlcreatepath=create_mysql/ clear_database=0
    or start it with
    ts3server dbplugin=ts3db_mysql
    So now my last workaround to start ts3 with the startscript in /etc/init.d/...

    vim /etc/init.d/teamspeak3-server

    change
    --exec "/usr/sbin/ts3server" -- \
    to
    --exec /usr/sbin/ts3server dbplugin=ts3db_mysql dbsqlcreatepath=create_mysql/ clear_database=0 -- \
    check if user teamspeak3 have enought permission in files folder
    drwx------ 3 teamspeak3 teamspeak3 4096 Aug 10 11:16 files

    so now you can start TS3 with the init script.

    Much workarounds but i need mysql on my server and not mariadb

  2. #2
    Join Date
    September 2011
    Location
    Ipswich / Queensland / Australia
    Posts
    2

    Thumbs up

    Thanks. I need to have a go at this soon.

    BTW Why is Teamspeak-server masked in Portage?

    Also what we really need is a way to link Teamspeak into Asterisk.

    Only reason we are bothering with Teamspeak on our server is to keep the Mincecraft players happy. OMG! :|

    .-.-.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Install TS3 RC1 with mysql >=5.1 on gentoo
    By blackgate in forum Off Topic
    Replies: 1
    Last Post: August 10th, 2011, 04:19 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
  •