Tutos geek

Tutoriaux linux, debian, android et autres

Mise à jour de TeamSpeak 3.3.x

14/08/2018 - Aucun commentaire

cd /home/teamspeak/teamspeak3
./ts3server_startscript.sh stop
vi ts3server.ini
[file]dbplugin=ts3db_mariadb
dbpluginparameter=ts3db_mariadb.ini
dbsqlcreatepath=create_mariadb/[/file]

netstat --listening -p |grep mysql # trouver l'emplacement du socket mysql.sock

vi ts3db_mariadb.ini
[file][config]
host='IP_From_MARIA_DB_SERVER'
port='Port_Number_Of_MARIA_DB_SERVER'
username='Database_Username"
password='Password_For_The_User'
database='Name_Of_your_Database'
socket=/var/run/mysqld/mysqld.sock[/file]

Un petit backup de la DB, on n'est jamais trop prudent...
mysqldump -u root -p --all-databases --add-drop-table --add-drop-database > mysql_full_dump_`date +%F`.sql

Mise à jour de la DB pour la rendre compatible MariaDB
cd /home/teamspeak/teamspeak3/sql/updates_and_fixes
mysql -u ts3_user -p teamspeak3 < convert_mysql_to_mariadb.sql
mysql -u ts3_user -p teamspeak3 < mariadb_fix_latin_utf8.sql

cp ./redist/libmariadb.so.2 .

On restart
./ts3server_startscript.sh start inifile=ts3server.ini



Source
http://www.hadess-server.at/doc/update_mysql_to_mariadb.txt
https://forum.teamspeak.com/threads/132925-unable-to-load-database-plugin-library-libts3db_mariadb-so
https://openclassrooms.com/forum/sujet/mac-mysql-sock-inexistant