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

Page 1 of 3 123 LastLast
Results 1 to 15 of 40
  1. #1
    Join Date
    December 2009
    Location
    Planet earth
    Posts
    10

    `server mysql database cant connect fail

    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


    2009-12-22 17:29:37.026667|ERROR |DatabaseQuery | | mysql_real_connect() led with error: Access denied for user 'root'@'localhost' (using password: NO

    ive done an ini

    [config]
    host=localhost
    port=3306
    username=teamspeak
    password=x5gUjs
    database=ts3db
    socket=

    added this but putin a new pass and a database if i start the server i get this error
    any suggestions?
    Last edited by dante696; February 21st, 2011 at 12:27 PM.

  2. #2
    Join Date
    October 2008
    Location
    USA
    Posts
    31
    remove the SOCKET line.

    And put an empty line at the end of the config

    [config]
    host=localhost
    port=3306
    username=teamspeak
    password=x5gUjs
    database=ts3db
    **empty line**

  3. #3
    Join Date
    October 2008
    Location
    USA
    Posts
    31
    Make sure too that you have added that teamspeak db user to the database with access.

  4. #4
    Join Date
    December 2009
    Location
    Planet earth
    Posts
    10
    [email protected]:~/teamspeak3$ ./ts3server_linux_x86 dbplugin=ts3db_mysql.ini
    Logging started
    2009-12-22 17:46:18.244297|INFO |ServerLibPriv | | Server Version: 3.0.0-beta3 [Build: 9419]
    2009-12-22 17:46:18.244726|CRITICAL|DatabaseQuery | | unable to load database plugin library, halting!



    [email protected]:~/teamspeak3$ ./ts3server_linux_x86 dbplugin=ts3db_mysql dbsqlcreatepath=create_mysql/
    Logging started
    2009-12-22 17:47:02.842738|INFO |ServerLibPriv | | Server Version: 3.0.0-beta3 [Build: 9419]
    2009-12-22 17:47:02.844328|INFO |DatabaseQuery | | dbPlugin name: MySQL plugin, (c)TeamSpeak Systems GmbH
    2009-12-22 17:47:02.844362|INFO |DatabaseQuery | | dbPlugin version: 1
    2009-12-22 17:47:02.847516|ERROR |DatabaseQuery | | mysql_real_connect() failed with error: Access denied for user 'root'@'localhost' (using password: NO)
    Segmentation fault


    [email protected]:~/teamspeak3$ ./ts3server_linux_x86 dbplugin=ts3db_mysql.ini dbsqlcreatepath=create_mysql/
    Logging started
    2009-12-22 17:47:34.778951|INFO |ServerLibPriv | | Server Version: 3.0.0-beta3 [Build: 9419]
    2009-12-22 17:47:34.779286|CRITICAL|DatabaseQuery | | unable to load database plugin library, halting!

    ts3db_mysql.ini
    [config]
    host=localhost
    port=3306
    username=teamspeak
    password=xxxxxxxxxxxxxxxxxxxx
    database=teamspeak

  5. #5
    Join Date
    October 2008
    Location
    USA
    Posts
    31
    Have yo updated everything? Meaning updated your linux lately?

  6. #6
    Join Date
    December 2009
    Location
    Planet earth
    Posts
    10
    Quote Originally Posted by evendco View Post
    Have yo updated everything? Meaning updated your linux lately?
    its debian 4 updated yes without mysql its running but i want it running with sql db

  7. #7
    Join Date
    December 2009
    Location
    London UK
    Posts
    28
    simler issue here.

  8. #8
    Join Date
    December 2009
    Location
    lutz
    Posts
    39
    Quote Originally Posted by UselessWolf View Post
    unable to load database plugin library, halting!
    post the output of command "ldd libts3db_mysql.so" while your in your ts3 server directory.

  9. #9
    Join Date
    December 2009
    Location
    Planet earth
    Posts
    10
    Quote Originally Posted by DraZtiK View Post
    post the output of command "ldd libts3db_mysql.so" while your in your ts3 server directory.
    i quite dont understand what i should do... =(

  10. #10
    Join Date
    December 2009
    Location
    lutz
    Posts
    39
    Quote Originally Posted by UselessWolf View Post
    i quite dont understand what i should do... =(
    Putty into your server...cd to the directory of your teamspeak server and then type "ldd libts3db_mysql.so" without the quotes. and then paste the results here in this forum. LOL

  11. #11
    Join Date
    December 2009
    Location
    Planet earth
    Posts
    10
    Quote Originally Posted by DraZtiK View Post
    Putty into your server...cd to the directory of your teamspeak server and then type "ldd libts3db_mysql.so" without the quotes. and then paste the results here in this forum. LOL
    [email protected]:~/teamspeak3$ ldd libts3db_mysql.so
    libmysqlclient.so.15 => /usr/lib/libmysqlclient.so.15 (0xb7d2d000)
    libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0xb7c47000)
    libm.so.6 => /lib/tls/libm.so.6 (0xb7c22000)
    libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xb7c17000)
    libc.so.6 => /lib/tls/libc.so.6 (0xb7ae5000)
    libpthread.so.0 => /lib/tls/libpthread.so.0 (0xb7ad3000)
    libcrypt.so.1 => /lib/tls/libcrypt.so.1 (0xb7aa5000)
    libnsl.so.1 => /lib/tls/libnsl.so.1 (0xb7a8e000)
    libz.so.1 => /usr/lib/libz.so.1 (0xb7a7a000)
    /lib/ld-linux.so.2 (0xb7f14000)

    there u are

  12. #12
    Join Date
    December 2009
    Location
    London UK
    Posts
    28
    not trying to thread hijack but as were all faceing the same issue here. thort ide merge posts.

    Quote Originally Posted by DarKZONE View Post
    has anyone been able to get the ts3 server to load with mysql? i see a lot of issue with it starting.

    mysql_real_connect() failed with error: Access denied for user 'root'@'localhost' (using password: NO)


    evan though the ts3db_mysql.ini is in the same folder as the bin.
    and yes it filled out right i just want to know if any 1 has been able to start it with mysql support on a linux server useing a username and password for mysql.

    //EDIT1

    Right system check
    i know mysql is running and working fine as other websites i run useing mysql are fine.

    the ts3db_mysql.ini is in the same folder as the bin file.
    made the ts3db_mysql.ini by makeing a new text file under windows 7 and renameing it to ts3db_mysql.ini
    then put int the following
    [config]
    host=localhost
    port=3306
    username=username
    password=blankblank
    database=TS3

    ive made the db usering cpanel
    made the username and added the username to the db with full permissions
    in the ini the username password and db name are right,

    so i cant figger out what is going on, it looks like to me the ts3 servers ignoreing the user/pass as ive evan put a fake one in there same issue
    Quote Originally Posted by Stormsys View Post
    create a ts3db_mysql.ini:
    -------cut here--------
    [config]
    host=localhost
    port=3306
    username=***
    password=***
    database=***
    socket=mysql

    -------cut here--------

    edit ts3server.ini, adding these:
    -------cut here--------
    dbplugin=ts3db_mysql
    dbsqlpath=sql/
    dbsqlcreatepath=create_mysql/
    dbpluginparameter=ts3db_mysql.ini
    -------cut here--------
    Quote Originally Posted by DarKZONE View Post
    1 there is no ts3server.ini just made one thogh adding what you put.
    2. added the socet=mysql to the ts3db_myswl.ini
    3. trying to start the server with ./ts3server_linux_x86 dbplugin=ts3db_mysql dbsqlcreatepath=create_mysql

    all = same results

    its still trying to use the root username >.>

    POSTING HERE AS SAME PROBLEM http://forum.teamspeak.com/showthrea...448#post205448
    and if it helps

    libmysqlclient.so.15 => /usr/lib/libmysqlclient.so.15 (0xb7e7b000)
    libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0xb7d93000)
    libm.so.6 => /lib/libm.so.6 (0xb7d6a000)
    libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xb7d5e000)
    libc.so.6 => /lib/libc.so.6 (0xb7c0a000)
    libcrypt.so.1 => /lib/libcrypt.so.1 (0xb7bdc000)
    libnsl.so.1 => /lib/libnsl.so.1 (0xb7bc2000)
    /lib/ld-linux.so.2 (0xb7fe5000)

  13. #13
    Join Date
    December 2009
    Location
    lutz
    Posts
    39
    When you look in your mysql database is it empty? or were tables created?

    Heres mine.

  14. #14
    Join Date
    December 2009
    Location
    London UK
    Posts
    28
    Just tested the following.

    uploaded a new ts3db_mysql.ini with default info.
    to see if had any issue, the server is still ignoreing the username and password and just trying root

    Quote Originally Posted by DraZtiK View Post
    When you look in your mysql database is it empty? or were tables created?

    Heres mine.
    to answer your question no the db is empty no tables and all that.
    but of corse there would be no tables and info as the server cant conntact to the mysql server

  15. #15
    Join Date
    December 2009
    Location
    lutz
    Posts
    39
    Here are my configs..
    ts3db_mysql.ini
    Code:
    [config]
    host=localhost
    port=3306
    username=xxxxx
    password=xxxxx
    database=teamspeak
    socket=
    After the socket= line..make sure you hit the enter key so you are on the next line. (not sure if this bug was fixed yet.

    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=/home/draztik/teamspeak3-server_linux-x86/ts3db_mysql.ini
    dbsqlpath=sql/
    dbsqlcreatepath=create_mysql/
    logpath=/home/draztik/teamspeak3-server_linux-x86/logs
    logquerycommands=0

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 Server Crashes (Database Fail)
    By peteyshivery in forum Linux / FreeBSD
    Replies: 1
    Last Post: May 24th, 2011, 02:05 PM
  3. TeamSpeak Server Crashes (Database Fail)
    By peteyshivery in forum Linux
    Replies: 1
    Last Post: May 24th, 2011, 02:05 PM
  4. Server updates when using mysql as the database
    By jesepi in forum Server Support
    Replies: 1
    Last Post: December 23rd, 2009, 08:23 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
  •