Forum

Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    Join Date
    September 2008
    Location
    Germany
    Posts
    11

    Teamspeak goes MySql

    Hello,

    I have got a little question:

    machine_id=1
    default_voice_port=1111
    voice_ip=XXXXX
    licensepath=
    filetransfer_port=30033
    filetransfer_ip=XXXXX
    query_port=10011
    query_ip=XXXXXXXX
    query_ip_whitelist=query_ip_whitelist.txt
    query_ip_blacklist=query_ip_blacklist.txt
    dbplugin=ts3db_mysql
    dbpluginparameter=ts3db_mysql.ini
    dbsqlpath=sql/
    dbsqlcreatepath=create_mysql/
    dblogkeepdays=90
    logpath=logs
    logquerycommands=0
    dbclientkeepdays=30
    I have more then 1 server running. Can i add more then one and how ?

    Thanks from Germany!

  2. #2
    Join Date
    May 2010
    Posts
    6,310
    Hello

    I don't really understand you, do you want create another Teamspeak server or another virtual server on your Teamspeak server ?

    In both cases you have to get a NPL license : http://forum.teamspeak.com/showthrea...-Servers-Slots

  3. #3
    Join Date
    September 2008
    Location
    Germany
    Posts
    11
    I have got a NPL and i have 3 Servers online.

    But how to write ?

    machine_id=1
    default_voice_port=1111

    *** German part deleted ***
    *** This forum is english only ***

  4. #4
    Join Date
    May 2010
    Posts
    6,310
    Sorry but it's hard ti understand you.

    Quote Originally Posted by Florian
    do you want create another Teamspeak server or another virtual server on your Teamspeak server ?

  5. #5
    Join Date
    September 2008
    Location
    Germany
    Posts
    11
    I have got three servers running and now i want to let them run with MySQL Database.
    But i do not really know how to change it in the .ini file !

    Better ??

  6. #6
    Join Date
    May 2010
    Location
    Germany
    Posts
    12
    editor?
    write me a PN on German, Forces!

  7. #7
    Join Date
    September 2008
    Location
    Germany
    Posts
    11
    Yes with editor, but i down know what i have to write

    machine_id=1
    machine_id=2
    default_voice_port=1111
    default_voice_port=5555
    Like this..

  8. #8
    Join Date
    May 2010
    Posts
    6,310
    So your ini file is good

    (maybe the voice_port is useless)
    You have to create 3 ini files for each single Teamspeak sever (changing the query and transfer port of course)

    And also you have to create the ts3db_mysql.ini file according the documentation

    So on each Teamspeak server folder you have to put the ts3server.ini and the ts3db_mysql.ini

  9. #9
    Join Date
    September 2008
    Location
    Germany
    Posts
    11
    I have got a ts3db_mysql.ini file

    But what exactly should i write in the 3 single ini files ?
    Can you give me an example?

    machine_id=1
    default_voice_port=1111
    voice_ip=XXXXX
    licensepath=
    filetransfer_port=30033
    filetransfer_ip=XXXXX
    query_port=10011
    query_ip=XXXXXXXX
    query_ip_whitelist=query_ip_whitelist.txt
    query_ip_blacklist=query_ip_blacklist.txt
    dbplugin=ts3db_mysql
    dbpluginparameter=ts3db_mysql.ini
    dbsqlpath=sql/
    dbsqlcreatepath=create_mysql/
    dblogkeepdays=90
    logpath=logs
    logquerycommands=0
    dbclientkeepdays=30
    machine_id=2
    default_voice_port=5555
    voice_ip=XXXXX
    licensepath=
    filetransfer_port=30033
    filetransfer_ip=XXXXX
    query_port=10011
    query_ip=XXXXXXXX
    query_ip_whitelist=query_ip_whitelist.txt
    query_ip_blacklist=query_ip_blacklist.txt
    dbplugin=ts3db_mysql
    dbpluginparameter=ts3db_mysql.ini
    dbsqlpath=sql/
    dbsqlcreatepath=create_mysql/
    dblogkeepdays=90
    logpath=logs
    logquerycommands=0
    dbclientkeepdays=30
    And how to name the ini files ? Same dosent work.

  10. #10
    Join Date
    May 2010
    Posts
    6,310
    As I wrote your ini files are good (just create a third for the third Teamspeak server)

    But DON'T forget to change the port parameters (to avoid any conflict)
    default_voice_port
    filetransfer_port
    query_port

    Info:
    The machine id parameter is usefull if you want use the same database for your 3 Teamspeak server.

  11. #11
    Join Date
    September 2008
    Location
    Germany
    Posts
    11
    default_voice_port
    filetransfer_port
    query_port

    jes, but my BIG QUESTION is, 3 ini files or 1 big ini file ??

  12. #12
    Join Date
    May 2010
    Posts
    6,310

  13. #13
    Join Date
    September 2008
    Location
    Germany
    Posts
    11
    Yes but how to name them ?

    ts3server1.ini
    ts3server2.ini
    ts3server3.ini

    like this ?

  14. #14
    Join Date
    May 2010
    Posts
    6,310
    So on each Teamspeak server folder you have to put the ts3server.ini and the ts3db_mysql.ini
    So, on each server folder you have ts3server.ini file and ts3db_mysql.ini
    Same name for each folder.

    Code:
    Server 1
    ts3sever.ini
    ts3db_mysql.ini
    Code:
    Server 2
    ts3sever.ini
    ts3db_mysql.ini
    Code:
    Server 3
    ts3sever.ini
    ts3db_mysql.ini
    Last edited by florian_fr40; August 18th, 2011 at 05:55 PM.

  15. #15
    Join Date
    September 2008
    Location
    Germany
    Posts
    11
    Yes but at the moment i have got 1 folder with the 3 Servers!

    So you mean i have to make 3 new server folders with 3 NPL licenses ?
    Last edited by Forces; August 18th, 2011 at 06:19 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [Resolved] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
    By Svenskunganka in forum Server Support
    Replies: 2
    Last Post: September 12th, 2013, 10:59 PM
  2. Teamspeak 3 with mySQL
    By QuasarSee in forum Windows
    Replies: 5
    Last Post: November 7th, 2011, 09:13 AM
  3. Teamspeak 3 <> MySQL
    By DeadHunter in forum Linux / FreeBSD
    Replies: 5
    Last Post: November 25th, 2010, 03:16 PM

Posting Permissions

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