Forum

Page 1 of 3 123 LastLast
Results 1 to 15 of 34
  1. #1
    Join Date
    December 2009
    Location
    Enid, Ok
    Posts
    10

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

    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
    [email protected]:~/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.
    Last edited by florian_fr40; February 8th, 2012 at 10:30 AM.

  2. #2
    Join Date
    December 2009
    Location
    PA, U.S.
    Posts
    35
    About the "ts3db_mysql.ini" file: what purpose does having a database for teamspeak serve?

  3. #3
    Join Date
    December 2009
    Location
    Enid, Ok
    Posts
    10

    reasons

    Quote Originally Posted by JakkFrosted View Post
    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.

  4. #4
    Join Date
    December 2009
    Location
    PA, U.S.
    Posts
    35
    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?

  5. #5
    Join Date
    September 2007
    Location
    Calgary Alberta Canada
    Posts
    109

    Smile

    Quote Originally Posted by JakkFrosted View Post
    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.

  6. #6
    Join Date
    October 2007
    Location
    France
    Posts
    70
    hello,

    when i launch the server i have always this error :

    Code:
    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 :
    Code:
    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
    Code:
    [config]
    host='127.0.0.1'
    port='3306'
    username='ts3_user'
    password='ts3_db_password'
    database='ts3_1'
    socket=''

  7. #7
    Join Date
    October 2006
    Location
    Germany
    Posts
    30
    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=

  8. #8
    Join Date
    December 2009
    Location
    Germany
    Posts
    3
    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

  9. #9
    Join Date
    December 2009
    Location
    Ukraine
    Posts
    1
    I started server TS3 using a mySQL:
    Code:
    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.
    Code:
    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.
    Code:
    ident: virtualserver_name
    value: TeamSpeak ]I[ Server

  10. #10
    Join Date
    August 2008
    Location
    Bonn, Germany
    Posts
    6
    Quote Originally Posted by Hutti View Post
    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?

  11. #11
    Join Date
    December 2009
    Location
    Constance
    Posts
    11
    One Problem I have.
    I created the files and started the server with the command:

    Code:
    ./ts3server_linux_amd64 inifile=ts3server.ini
    I got a warning like this:

    Code:
    failed with error: Can't connect to MySQL server on '127.0.0.1' (111)
    Segmentation fault
    But Username and Password are right.

  12. #12
    Join Date
    December 2009
    Location
    Good old Germany
    Posts
    222
    Hi,

    then try localhost and not 127.0.0.1....

    cheech

  13. #13
    Join Date
    December 2009
    Location
    Constance
    Posts
    11
    ts3server.ini
    Code:
    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
    Code:
    [config]
    host='localhost'
    port='3306'
    username='USER'
    password='PW'
    database='NAME'
    socket=
    Anything wrong?
    Last edited by Sanya; January 12th, 2010 at 04:14 PM.

  14. #14
    Join Date
    January 2010
    Location
    Sweden
    Posts
    2
    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:

    Code:
    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:

    Code:
    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
    Last edited by Zmegolaz; January 12th, 2010 at 07:06 PM.

  15. #15
    Join Date
    December 2009
    Location
    Good old Germany
    Posts
    222
    Hi,

    which start command did you used ?

    Ts3server.ini and ts3db_mysql.ini ????


    cheech

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. DXHook.DLL doesn't install properly
    By Carlislemark in forum Windows
    Replies: 3
    Last Post: February 6th, 2012, 03:25 PM
  2. Linux server install for low-skill-in-linux-terminal guy
    By flakz0r in forum Linux / FreeBSD
    Replies: 5
    Last Post: December 30th, 2010, 09:03 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •