Forum


Notice to all users

We are migrating towards a new forum system located at community.teamspeak.com, as such this forum will become read-only on January 29, 2020

Results 1 to 4 of 4
  1. #1
    Join Date
    January 2010
    Location
    canada
    Posts
    4

    sql database problem

    Edit by mod
    Please don't use this outdated script anymore! The script got an overhaul long time ago.
    Please use the minimal or startscript instead


    This is on a freshly installed Debian system with both mysql and sqlite installed I tried following several peoples walkthrough and none work exactly

    I have 3 possible outcomes when I try to start TS3 server the first one is when i just execute it with no parameters

    [email protected]:~/teamspeak3-server_linux-x86$ ./ts3server_linux_x86
    Logging started
    2010-01-01 21:14:26.521128|INFO |ServerLibPriv | | Server Version: 3.0.0-beta12 [Build: 9596]
    2010-01-01 21:14:26.523471|INFO |DatabaseQuery | | dbPlugin name: SQLite3 plugin, (c)TeamSpeak Systems GmbH
    2010-01-01 21:14:26.524564|INFO |DatabaseQuery | | dbPlugin version: 3.6.21
    2010-01-01 21:14:27.660431|INFO |Accounting | | Licensing Information
    2010-01-01 21:14:27.664493|INFO |Accounting | | type : Non-profit
    2010-01-01 21:14:27.667837|INFO |Accounting | | starting date : Wed Dec 30 16:00:00 2009
    2010-01-01 21:14:27.670883|INFO |Accounting | | ending date : Thu Dec 30 16:00:00 2010
    2010-01-01 21:14:27.674054|INFO |Accounting | | max virtualservers: 10
    2010-01-01 21:14:27.677096|INFO |Accounting | | max slots : 512
    2010-01-01 21:14:27.780056|INFO |FileManager | | listening on 0.0.0.0:30033
    2010-01-01 21:14:27.990207|INFO |VirtualServer | 1| listening on 0.0.0.0:9987
    2010-01-01 21:14:27.995076|INFO |Query | | listening on 0.0.0.0:10011
    ^C
    The next is when I load the ts3server.ini fil

    [email protected]:~/teamspeak3-server_linux-x86$ ./ts3server_linux_x86 inifile=ts3server
    Logging started
    2010-01-01 21:14:37.868691|INFO |ServerLibPriv | | Server Version: 3.0.0-beta12 [Build: 9596]
    2010-01-01 21:14:37.870603|CRITICAL|DatabaseQuery | | unable to load database plugin library, halting!
    And last when I try to load both the ts3server file and the ts3db_mysql files

    [email protected]:~/teamspeak3-server_linux-x86$ ./ts3server_linux_x86 inifile=ts3server dbplugin=ts3db_mysql
    Logging started
    2010-01-01 21:14:43.847438|INFO |ServerLibPriv | | Server Version: 3.0.0-beta12 [Build: 9596]
    2010-01-01 21:14:43.854698|INFO |DatabaseQuery | | dbPlugin name: MySQL plugin, (c)TeamSpeak Systems GmbH
    2010-01-01 21:14:43.855800|INFO |DatabaseQuery | | dbPlugin version: 1
    2010-01-01 21:14:43.876877|ERROR |DatabaseQuery | | mysql_real_connect() failed with error: Unknown database 'test'
    Segmentation fault
    I beleive the last option takes me closest to starting the program but i have tryed several different database name and none seem to work
    my ini files are as follows

    ts3server.ini
    machine_id=
    default_voice_port=8801
    voice_ip=70.74.197.59
    licensepath=
    filetransfer_port=30033
    filetransfer_ip=70.74.197.59
    query_port=10011
    query_ip=70.74.197.59
    dbplugin=ts3db_mysql
    dbpluginparameter=
    dbsqlpath=sql/
    dbsqlcreatepath=create_mysql/
    logpath=logs
    logquerycommands=0
    <blank line>
    ts3db_mysql
    [config]
    host=localhost
    port=8801
    username=tts
    password=
    database=test
    socket=
    <blank line>
    So is there a database name I should be using or do i need to make a new database name in mysql
    Last edited by dante696; February 21st, 2011 at 12:14 PM.

  2. #2
    Join Date
    September 2006
    Location
    Germany / Hannover
    Posts
    137
    maybe it is usefull to write the right name from the inifile to the commandline

    ./ts3server_linux_x86 inifile=ts3server.ini

  3. #3
    Join Date
    January 2010
    Location
    In front of my computer
    Posts
    51

    Create your database

    You need to create your database, and the user account. Then use that database in your INI.

    Assuming you have mysql on the same box as TS3...
    Code:
    mysql -uroot -p   <<<Login as root>>>
    CREATE DATABASE ts3db;
    CREATE USER 'ts3dbUser'@'localhost' IDENTIFIED BY 'xPVHFxL7zUnZPReH';  <<<Make up your own password>>>
    GRANT ALL PRIVILEGES ON `ts3db` . * TO 'ts3dbUser'@'localhost';

    Then your ts3db_mysql.ini should be...

    Code:
    [config]
    host=localhost
    port=3306
    username=ts3dbUser
    password=xPVHFxL7zUnZPReH
    database=ts3db
    socket=
    Linuxx

  4. #4
    Join Date
    January 2010
    Location
    canada
    Posts
    4
    I solved it first i had to delete the ts3server.ini file and have the program remake it with the command
    ./ts3server_linux_x86 createinifile=1
    then I used vim to add my ip address to the file and the command
    ./ts3server_linux_x86 inifile=ts3server.ini
    and it worked

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. database id problem
    By zonEe in forum Linux / FreeBSD
    Replies: 4
    Last Post: June 7th, 2011, 07:02 PM
  2. [Resolved] Database problem, TS can't read channels
    By Emcet in forum Server Support
    Replies: 4
    Last Post: May 10th, 2011, 07:50 AM
  3. TS3 Connection Problem (database error)
    By Quittolo in forum Windows
    Replies: 2
    Last Post: November 11th, 2010, 07:08 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
  •