Requirements: Perl, MariaDB
Tested on: Ubuntu 18.04 and Centos 7
Step by Step Guide
- You will need to SSH to the machine to do everything so go login.
- Stop your currently running teamspeak server.
tar -cvf ts3.tar /home/ts3/teamspeak3-server_linux_amd64
- Before you do anything you should take a backup of your server just in case you mess up with anything.
tar -cvf ts3.tar /home/ts3/teamspeak3-server_linux_amd64
or
zip -r ts3.zip /home/ts3/teamspeak3-server_linux_amd64
- Create a new database into MariaDB.
mysql -u root -p
CREATE DATABASE ts3;
exit
- Go to teamspeak directory.
cd /home/ts3/teamspeak3-server_linux_amd64
- put your own path
- Create a dump file of the current SQLite file.
sqlite3 ts3server.sqlitedb .dump > ts3dump.sql
- Create the Perl converter file and put the following code.
nano sql.pl
https://pastebin.com/raw/BKATXgx5
(Add inside the sql.pl the content of the pastebin. For some security reason the forum didn't allow me to post the code.
- Run the Perl file.
perl sql.pl ts3dumb.sql > ts3.sql
- Now that you have a compatible MySQL file you need to import it to the database we made before.
mysql -u root -p ts3 < ts3.sql
- Convert and Fix to fully work with MariaDB. Under teamspeak’s directory go to " sql/updates_and_fixes " and run the following commands.
mysql -u root -p ts3 < convert_mysql_to_mariadb.sql
mysql -u root -p ts3 < mariadb_fix_latin_utf8.sql
- Go back to teamspeak’s root directory and create the " ts3server.ini " file and add the following lines bellow.
nano ts3server.ini
If you already have this file just modify the following lines.
dbplugin=ts3db_mariadb
dbpluginparameter=ts3db_mariadb.ini
dbsqlpath=sql/
dbsqlcreatepath=create_mariadb/
dbconnections=10
- You will also need to create the file " ts3db_mariadb.ini " so you can make the database connection from teamspeak to mysql.
nano ts3db_mariadb.ini
[config]
host=127.0.0.1
port=3306
username=root
password=your_password
database=ts3
- Copy the MariaDB library from teamspeak’s " redist " folder into teamspeak’s main folder.
cp /home/ts3/teamspeak3-server_linux_amd64/redist/libmariadb.so.2 /home/ts3/teamspeak3-server_linux_amd64/libmariadb.so.2
- Modify the teamspeak server start script to read the ts3server.ini file on ts3 server start or restart.
Find the following lines:
ExecStart=/home/ts3/teamspeak3-server_linux_amd64/ts3server_startscript.sh start
ExecReload=/home/ts3/teamspeak3-server_linux_amd64/ts3server_startscript.sh restart
And replace them with:
ExecStart=/home/ts3/teamspeak3-server_linux_amd64/ts3server_startscript.sh start inifile=ts3server.ini
ExecReload=/home/ts3/teamspeak3-server_linux_amd64/ts3server_startscript.sh restart inifile=ts3server.ini
- Reload systemctl to verify the changes on the service start.
systemctl daemon-reload
- You are ready to start the server again!
service teamspeak start
- After that update your teamspeak’s instance log should return this.
2020-04-13 15:23:31.847227|INFO |ServerLibPriv | |TeamSpeak 3 Server 3.12.1 (2020-03-27 10:38:47)
2020-04-13 15:23:31.847477|INFO |ServerLibPriv | |SystemInformation: Linux 3.10.0-1062.18.1.el7.x86_64 #1 SMP Tue Mar 17 23:49:17 UTC 2020 x86_64 Binary: 64bit
2020-04-13 15:23:31.852988|INFO |DatabaseQuery | |dbPlugin name: MariaDB plugin, Version 3, (c)TeamSpeak Systems GmbH
2019-03-28 16:12:08.746601|INFO |DatabaseQuery | |dbPlugin version: 2
You are ready!
You can safely remove these files from the teamspeak directory as they are not needed anymore:
- ts3dump.sql
- sql.pl
- ts3.sql
- ts3server.sqlitedb (Old database file. You can keep it for backup if you want.)
.
