[Howto] TS2 Server + MySQL 5.0

[ConiKost]

Hello!

A small Howto for TS2 Server + MySQL 5.0

1) Download & Install TS2 Server, but NOT start! (Readme folgen)

2) Create an MySQL Table and a User who has access to it (e.g. via phpMyAdmin)

3) Change MySQL Passwort for the TS2 User

SET PASSWORD FOR '<USER>'@'<SERVER>' = OLD_PASSWORD('<PASSWORT>');


3) Create in /etc/teamspeak2-server a server.ini

Paste this:


[DBEXPRESS]
sqldir=/opt/teamspeak2-server/mysql_sql/
Drivername=mysql
Database=DATABASE
Hostname=127.0.0.1 (important!! do not write localhost)
User_name=USERNAME
Password=PASSWORD
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/libmysqlclient_r.so.10.0.0
LibraryName=/opt/teamspeak2-server/libsqlmy.so
Active=1


Change the Values you need.

4) Now we need older MySQL Libs. Get them from http://www.pack-eis.de/index.php?p=libmysql-shared

5) Copy


libmysqlclient.so.10.0.0
libmysqlclient_r.so.10.0.0


to /usr/lib

6) Now you can start the ts2 server. It should automatically create all tables ... if they are any errors, see /var/log/teamspeak2-server/server.log