Team Speak 3 server with MySQL on Linux

[Szilard]

Hi.

Before you say that this is already written, I say: I write this with MySQL, and somebody other wrote it without MySQL.
I recommend this if you make more servers.

---

You need to download Team Speak 3 server.
32 bit: (x86)

Code:

wget http://teamspeak.gameserver.gamed.de/ts3/releases/3.0.2/teamspeak3-server_linux-x86-3.0.2.tar.gz -O ts3.tar.gz

64 bit:

Code:

wget http://teamspeak.gameserver.gamed.de/ts3/releases/3.0.2/teamspeak3-server_linux-amd64-3.0.2.tar.gz -O ts3.tar.gz

You need to extract it.

Code:

tar -xvzf ts3.tar.gz

Rename it:
32 bit: (x86)

Code:

mv teamspeak3-server_linux-x86 ts3

64 bit:

Code:

mv teamspeak3-server_linux-amd64 ts3

Give it chmod 777.

Code:

chmod -R 777 ts3

Cd into it.

Code:

cd ts3

Install these packages, if these aren't installed yet.

Code:

apt-get install mysql-server mysql-client libmysqlclient15-dev phpmyadmin

It will ask this:

Quote:Configure database for phpmyadmin with dbconfig-common

It's answer is yes.
Login into mysql.

Code:

mysql -u root -p

Write your given password.
Create database "teamspeak3".

Code:

CREATE DATABASE teamspeak3;

Logout from MySQL.

Code:

quit

Now go back to the directory. We are in the ts3 directory.
Make "ts3server.ini" with these settings.

Code:

cat > ts3server.ini <<END
machine_id=
default_voice_port=9987
voice_ip=0.0.0.0
licensepath=
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=0

(You can change port, and add license.dat file to the ts3 directory, too.)
We need "ts3db_mysql.ini" file now.

Code:

cat > ts3db_mysql.ini <<END
[config]
host=localhost
username=root
password=password
database=teamspeak3
socket=

END

You need to change password (after "password=") to your given password.



Ready.

Start:
with screen:

Code:

screen ./ts3server_minimal_runscript.sh inifile=ts3server.ini

without screen:

Code:

./ts3server_minimal_runscript.sh inifile=ts3server.ini

---

Errors
If your TS3 server doesn't start, and writes this:

Code:

unable to load database plugin library "libts3db_mysql.so", halting!

Do this:

Code:

wget http://ftp.nl.debian.org/debian/pool/main/m/mysql-dfsg-5.0/libmysqlclient15off_5.0.51a-24+lenny5_i386.deb
dpkg -i libmysqlclient15off_5.0.51a-24+lenny5_i386.deb
dpkg -i --force-architecture  libmysqlclient15off_5.0.51a-24+lenny5_i386.deb