How to "properly" install TS3 using a mySQL 5 server on linux...

[dlcerny]

I am writing this because in the documentation released with the linux server are really lacking, and some punctuation is missing for the actual examples, so here it goes.......

1. Create a database on your mySQL server, we will use "TS3" for an as instance. database needs to be void of tables (or blank ).

2. Create a file in Gedit or notepad named "ts3db_mysql.ini" and let it contain the following, and no, all the punctuation I have put in is correct for the server to use the file!

[config]
host='SERVERNAMEorIP'
port='usually3306'
username='DBusername'
password='1234xyz'
database='TS3'
socket=

Now here are your descriptions of each, but remember all punctuation is correct!

* host (127.0.0.1)
The hostname or IP addresss of your MySQL server.
* port (3306)
The TCP port of your MySQL server.
* username (root)
The username used to authenticate with your MySQL server.
* password (<empty>)
The password used to authenticate with your MySQL server.
* database (test)
The name of a database on your MySQL server. Note that this database must be created before the TeamSpeak 3 Server is started.
* socket (<empty>)
The name of the Unix socket file to use, for connections made via a named pipe to a local server.

3. Create a file in Gedit or notepad named "ts3server.ini", and populate it with the following:

machine_id=
default_voice_port=9987
voice_ip=0.0.0.0
liscensepath=
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=1

Once again explanation of the above.

* machine_id (<empty>)
Optional name of this server process to identity a group of servers with
the same ID.
Default: The server instance will not use a machine ID.
* default_voice_port (9987)
UDP port open for clients to connect to. This port is used by the first
virtual server, subsequently started virtual servers will open on increasing
port numbers.
Default: The default voice port is 9987.
* voice_ip (0.0.0.0)
IP on which the server instance will listen for incoming voice connections.
Default: The server is bound on any IP address.
* licensepath (<empty>)
The physical path where your license file is located.
Default: The license file is located in your servers installation directory.
* filetransfer_port (30033)
TCP Port opened for file transfers. If you specify this parameter, you also
need to specify the "filetransfer_ip" parameter!
Default: The default file tranfer port is 30033.
* filetransfer_ip (0.0.0.0)
IP on which the file transfers are bound to. If you specify this parameter,
you also need to specify the "filetransfer_port" parameter!
Default: File transfers are bound on any IP address.
* query_port (10011)
TCP Port opened for ServerQuery connections. If you specify this parameter,
need to specify the "query_ip" parameter!
Default: The default ServerQuery port is 10011.
* query_ip (0.0.0.0)
IP bound for incoming ServerQuery connections. If you specify this parameter,
you also need to specify the "query_port" parameter!
Default: ServerQuery connections are bound on any IP address.
* dbplugin (ts3db_sqlite3)
Name of the database plugin library used by the server instance. For example, if
you want to start the server with MySQL support, simply set this parameter to
"ts3db_mysql" to use the MySQL plugin. Do *NOT* specify the "lib" prefix or the file
extension of the plugin.
Default: The default SQLite3 database plugin will be used.
* dbpluginparameter (<empty>)
A custom parameter passed to the database plugin library. For example, the MySQL
database plugin supports a parameter to specify the physical path of the plugins
configuration file.
Default: The database plugin will be used without a parameter.
* dbsqlpath (sql/)
The physical path where your SQL script files are located.
Default: The server will search for SQL script files in the "sql/" subdirectory.
* dbsqlcreatepath (create_sqlite/)
The physical path where your SQL installation files are located. Note that this
path will be added to the value of the "dbsqlpath" parameter.
Default: The server will search for SQL installation scripts files in the
"<dbsqlpath>/dbsqlcreatepath/" subdirectory.
* logpath (logs/)
The physical path where the server will create logfiles.
Default: The server will search for SQL script files in the "logs/" subdirectory.
* logquerycommands (0=off, 1=on)
Logs the individual queries to the server log.

4. Now we are to the final step, start your server with this command:

Linux x86
user@server:~/ts3$./ts3server_startscript.sh start inifile=ts3server.ini

I am sure the steps are the same for most of the releases (ie. Linux 64-bit, Win32, Win64), so hope this helps you.

[JakkFrosted]

About the "ts3db_mysql.ini" file: what purpose does having a database for teamspeak serve?

[dlcerny]

About the "ts3db_mysql.ini" file: what purpose does having a database for teamspeak serve?

You can use some integration between a guild website and TS3, currently I am working on a integration for users to link and upload recordings to our Joomla/phpBB3 website. The actual practical reason is because I think sqlite is an aweful database and when it goes bad, it is bad.

[JakkFrosted]

So is sqlite some kind of makeshift database program that is only good for noncritical or db-light processes? Aside from the site integration possibilities, TS is using a db? And if that is the case it'd be safer to specify mysql?

[KoldFusion]

About the "ts3db_mysql.ini" file: what purpose does having a database for teamspeak serve?

The Database holds information on the rooms, users and permissions.

Without a database you could not set up admins, users, rooms and such.

If you are asking Why SQLite and MySQL. MySQL is a more potent database, easy to manage and alter. Its also nice having two options.

Picture SQLite as your mother s Compact Toyota Echo. And MySQL as a Pimped out Mercedees.

[Bloody-wave]

hello,

when i launch the server i have always this error :

Logging Started
2009-12-21 10:58:44.123141|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta2 [Build: 9398]
2009-12-21 10:58:44.125335|INFO    |DatabaseQuery |   | dbPlugin name:    MySQL plugin, (c)TeamSpeak Systems GmbH
2009-12-21 10:58:44.125444|INFO    |DatabaseQuery |   | dbPlugin version: 1
2009-12-21 10:58:44.131954|ERROR   |DatabaseQuery |   | mysql_real_connect() failed with error: Access denied for user 'root'@'localhost' (using password: NO)
Erreur de segmentation

I don't understand why the server connect on mysql with root account and no password...

my ts3server.ini :

machine_id=
default_voice_port=9987
voice_ip=0.0.0.0
liscensepath=
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=1

and ts3db_mysql.ini

[config]
host='127.0.0.1'
port='3306'
username='ts3_user'
password='ts3_db_password'
database='ts3_1'
socket=''

[Micromac]

Add a Emty line in your ts3db_mysql.ini under socket.

And my Ini look`s like this:

[config]
host=localhost
port=3306
username=ts3_server
password=ts3_password
database=ts3_server
socket=

[Hutti]

For all who want to use a password for the mysql user, just create this password with the old_password command in the mysql comman shell.

Example:

SET PASSWORD = OLD_PASSWORD('secret');

Same like ts2.

Best regards

Hutti

PS: Tested on Suse 10.1 with mysql 5

[Muxeu]

I started server TS3 using a mySQL:

2009-12-21 13:03:55.467471|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta2 [Build: 9398]
2009-12-21 13:03:55.471493|INFO    |DatabaseQuery |   | dbPlugin name:    MySQL plugin, (c)TeamSpeak Systems GmbH
2009-12-21 13:03:55.471620|INFO    |DatabaseQuery |   | dbPlugin version: 1
2009-12-21 13:03:55.546155|WARNING |Accounting    |   | Unable to find valid license key, falling back to limited
2009-12-21 13:03:55.792719|INFO    |FileManager   |   | listening on 0.0.0.0:30033
2009-12-21 13:03:55.853702|INFO    |VirtualServer |  1| listening on 0.0.0.0:9987
2009-12-21 13:03:55.854753|INFO    |Query         |   | listening on 0.0.0.0:10011

But SERVERQUERY does not change anything in DB tables.

TS3
use sid=1
error id=0 msg=ok

login serveradmin *******
error id=0 msg=ok

serveredit virtualserver_name=UkrTel\sTeamSpeak\s3\sServer
error id=0 msg=ok

But nothing changes in mysql table server_properties.

ident: virtualserver_name
value: TeamSpeak ]I[ Server

[Hackebein]

For all who want to use a password for the mysql user, just create this password with the old_password command in the mysql comman shell.

Example:

SET PASSWORD = OLD_PASSWORD('secret');

Same like ts2.

Best regards

Hutti

PS: Tested on Suse 10.1 with mysql 5

TS3 will by login with user "root" and pw "" und DB "test" and nothing other. Because in the config stand somting other informations. In the server.ini will be the ts3_mysql.ini loaded because he loaded the data not. I have a Windows 7 64bit. Who ist my Problem?

[Sanya]

One Problem I have.
I created the files and started the server with the command:

./ts3server_linux_amd64 inifile=ts3server.ini

I got a warning like this:

failed with error: Can't connect to MySQL server on '127.0.0.1' (111)
Segmentation fault

But Username and Password are right.

[Cheech]

Hi,

then try localhost and not 127.0.0.1....

cheech

[Sanya]

ts3server.ini

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=1

ts3db_mysql.ini

[config]
host='localhost'
port='3306'
username='USER'
password='PW'
database='NAME'
socket=

Anything wrong?

[Zmegolaz]

Hi guys,

I'm running Debian Linux 2.6.31.5 with MySQL 5.0.51a.
I've created a database and user in my MySQL database, but when I run ts3server_linux_x86 I get this output:

2010-01-12 17:30:48.791691|ERROR   |DatabaseQuery |   | db_exec() CREATE TABLE channel_properties (  server_id integer unsigned,  id     error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AUTOINCREMENT NOT NULL,  channel_parent_id  integer unsigned,  server_id        ' at line 1
2010-01-12 17:30:48.791811|CRITICAL|SQL           |   | db_CreateTables() unable to create tables

And the only thing created is the channel_properties table.

I tried to run the SQL commands located in the file sql/create_tables.sql in phpMyAdmin, and it worked fine, all the tables were created, but then I got this instead:

2010-01-12 17:22:15.727843|CRITICAL|SQL           |   | db_CreateTables() unable to load instance default values

I've tried running sql/defaults.sql manually too, but got some other error, and thought that this won't work even if I do get the server to start :P

//Zmegolaz

[Cheech]

Hi,

which start command did you used ?

Ts3server.ini and ts3db_mysql.ini ????


cheech