Tutorial Scripts for TS3 server | MariaDB |Autostart

BIOS · Nov 24, 2017

Configure Teamspeak
We are going to configure TeamSpeak3 server with the MySQL-MariaDB database,
We have to manually create configfiles:

queryipblacklist.txt
queryipwhitelist.txt
ts3server.ini
ts3db_mariadb.ini

Create blacklist configfile.

Code:

sudo touch /opt/teamspeak3-server/query_ip_blacklist.txt

Create whitelist configfile.

Code:

sudo cat  << EOT > /opt/teamspeak3-server/query_ip_whitelist.txt
127.0.0.1
EOT

Create configfile with MySQL-MariaDB database option.

Code:

sudo nano /opt/teamspeak3-server/ts3server.ini

With the following inside of it:

Code:

machine_id=
default_voice_port=9987
voice_ip=
licensepath=
filetransfer_port=30033
filetransfer_ip=
query_port=10011
query_ip=
query_ip_whitelist=query_ip_whitelist.txt
query_ip_blacklist=query_ip_blacklist.txt
dbsqlpath=sql/
dbplugin=ts3db_mariadb
dbsqlcreatepath=create_mariadb/
dbpluginparameter=ts3db_mariadb.ini
dbconnections=10
logpath=logs
logquerycommands=0
dbclientkeepdays=30
logappend=0
query_skipbruteforcecheck=0

Create the configfile for the database for the TeamSpeak3 server.
Change PASSWORD the same password you have created configuring MySQL database.

Code:

sudo nano /opt/teamspeak3-server/ts3db_mariadb.ini

Input:

Code:

[config]
host=127.0.0.1
port=3306
username=teamspeak3
password=PASSWORD
database=teamspeak3
socket=

Now you need to change permissions of the new config files:

Code:

sudo chown teamspeak3-user:teamspeak3-user /opt/teamspeak3-server -R

Now the configuration is done.

Create ts3 init script of TeamSpeak3 server (autostart)

Code:

sudo nano /etc/init.d/ts3

With:

Code:

#! /bin/sh
### BEGIN INIT INFO
# Provides:          ts3
# Required-Start:    $network mysql
# Required-Stop:     $network
# Default-Start:     2 3 4 5
# Default-Stop:      0 1 6
# Short-Description: TeamSpeak3 Server Daemon
# Description:       Starts/Stops/Restarts the TeamSpeak Server Daemon
### END INIT INFO

set -e

PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin
DESC="TeamSpeak3 Server"
NAME=teamspeak3-server
USER=teamspeak3-user
DIR=/opt/teamspeak3-server
OPTIONS=inifile=ts3server.ini
DAEMON=$DIR/ts3server_startscript.sh
#PIDFILE=/var/run/$NAME.pid
SCRIPTNAME=/etc/init.d/$NAME

# Gracefully exit if the package has been removed.
test -x $DAEMON || exit 0

sleep 2
sudo -u $USER $DAEMON $1 $OPTIONS

Now change permissions for the scripts:

Code:

sudo chmod a+x /etc/init.d/ts3

Code:

sudo chmod a+x /opt/teamspeak3-server/ts3server_startscript.sh

Code:

sudo chmod a+x /opt/teamspeak3-server/ts3server_minimal_runscript.sh

Code:

sudo update-rc.d ts3 defaults

Now everything should be done, and ready to go. Lets start the Teamspeak3 server for the first time:

Code:

sudo /etc/init.d/ts3 start

You will first see the serveradmin password and token key. Make sure you save the serveradmin password somewhere save. With this you can query inside your teamspeak server. For the token key, you can also look in the logs:

Code:

/opt/teamspeak3-server/logs

Hit enter, and its all running.

Works on Debian 9.2

Tutorial Scripts for TS3 server | MariaDB |Autostart

BIOS

Knowledge Seeker