Forum

Page 1 of 3 123 LastLast
Results 1 to 15 of 40
  1. #1
    Join Date
    November 2014
    Posts
    2

    Since 3.0.11."Unable to load/use MySQL plugin"

    Dear user,
    MySQL support was dropped in server 3.0.11. you must use the MariaDB plugin now.


    Please read post #7 for more information.

    A how to can be found in post #49

    -------------------------------------------------------------------------------------------------------------



    I've Googled, searched these forums, and I'm at my wit's end - I can't figure this out.

    I'm trying to set up my TeamSpeak server to use MySQL for this wonderful EVE Online authentication plugin for SMF, but I can't even get TeamSpeak to run when it's configure for MySQL. Upon running a clean TeamSpeak server configured for MySQL, I get the error:

    unable to load database plugin library "libts3db_mysql.so", halting!
    Here's 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=0
    and my ts3db_mysql.ini:

    [config]
    host=127.0.0.1
    port=3306
    username=(username)
    password=(password)
    database=(database)
    socket='
    Last edited by dante696; August 17th, 2018 at 08:25 AM.

  2. #2
    Join Date
    April 2011
    Location
    Germany
    Posts
    1,266
    You might want to tell us which server version you are trying to use. If it is the recent one then there is no MySQL plugin, because MySQL support was removed from teamspeak. Only SQLite and MariaDB are supported databases with teamspeak server.

  3. #3
    Join Date
    November 2014
    Posts
    2
    Shoot, I guess that would do it, wouldn't it? Thanks for explaining, Barungar.

  4. #4
    Join Date
    January 2013
    Posts
    4
    I'm having a similar problem with Ubuntu 14.04 / TS3 Server version amd64 3.0.11.1

    What version of TS3 Server can be installed that works with Mysql?

  5. #5
    Join Date
    April 2011
    Location
    Germany
    Posts
    1,266
    Installing an older teamspeak server can not be recommended. Just ask yourself, why do you need a MySQL-DB? In most cases you really don't. The SQlite-DB is more then sufficient for all self-hosted teamspeaks servers. Out-of-band data access/manipulation in the DB is not supported by teamspeak. Everything you want to know can be queried and modified by SQ. So there is no real need to use anything other than SQlite (except for big hosters).

  6. #6
    Join Date
    January 2013
    Posts
    4
    Quote Originally Posted by Barungar View Post
    Installing an older teamspeak server can not be recommended. Just ask yourself, why do you need a MySQL-DB? In most cases you really don't. The SQlite-DB is more then sufficient for all self-hosted teamspeaks servers. Out-of-band data access/manipulation in the DB is not supported by teamspeak. Everything you want to know can be queried and modified by SQ. So there is no real need to use anything other than SQlite (except for big hosters).
    Mysql is being used by previously wrote plugins and applications. TS3 has been working with mysql databases for years. Are you saying there has been some change in the most recent TS3 server builds that doesnt allow mysql to work?

  7. #7
    Join Date
    June 2008
    Posts
    18,151
    No, he wants to tell you that
    1. We do not give support for MySQL anymore which was replaced with the new standard MariaDB.
    2. You can use MySQL as long MariaDB supports it. This is not related to TeamSpeak.
    3. You can not start the server with the MySQL plugins anymore.
    4. You must use the SQLite or MariaDB plugin to run the server.
    5. We do not give any support for outdated server versions. So a downgrade is never supported.


    Edit
    How to convert the server to MariaDB standard (and using MySQL or MariaDB)
    http://forum.teamspeak.com/showthrea...424#post388424

    I mark this thread as not possible -> We can't support it anymore and how to's are given already.
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

  8. #8
    Join Date
    November 2014
    Posts
    1

    Install TS3 with MySQL Support on Windows 2012 R2

    Hello guys,

    I try the whole day to fix this bug but i donīt now how, perhaps u can help me...

    Log:
    2014-11-17 23:19:07.346275|INFO |ServerLibPriv | | TeamSpeak 3 Server 3.0.11.1 (2014-10-15 07:06:31)
    2014-11-17 23:19:07.346275|INFO |ServerLibPriv | | SystemInformation: Windows Server 2012 (9200) x64 (AMD or Intel) Binary: 64bit
    2014-11-17 23:19:07.346275|INFO |ServerLibPriv | | Using hardware aes
    2014-11-17 23:19:07.346275|CRITICAL|DatabaseQuery | | unable to load database plugin library "ts3db_mysql.dll", halting!

    ts3db_mysql:
    [config]
    host='192.168.84.5'
    port='3306'
    username='test'
    password='*****'
    database='test'
    socket='/var/run/mysqld/mysqld.sock'

    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
    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/
    dbconnections=10
    logpath=logs
    logquerycommands=0
    dbclientkeepdays=30
    logappend=0

    ts3-shortcut target parameter:
    C:\Users\Domainadmin\Desktop\Teamspeak3-Server\ts3server_win64.exe inifile=ts3server.ini
    Last edited by dante696; November 18th, 2014 at 07:08 AM. Reason: merged

  9. #9
    Join Date
    September 2012
    Posts
    45

    Ubuntu 10 LTS and MySql

    I have been trying to follow this thread for instructions (http://forum.teamspeak.com/showthrea...erver-on-Linux) on setting up TeamSpeak on a 64 bit Ubuntu system, and for the life of me, I simply can not get over the hurdle of the missing "libts3db_mysql.so" file.

    The links shown for the various ways to get package updates do not work for apt-get.

    What's the latest scoop of solving this? Or is it just not possible to use a MySQL database in this server type?

    mini-update.. I also tried this tutorial (http://forum.teamspeak.com/showthrea...-Debian-Ubuntu) and close to the start, there is a link for the "wget" of the package.. and that link also does not work. There was a direct link later on to grab "libmysqlclient15off_5.0.51a-24+lenny5_amd64.deb" which I did get, and I did the dpkg -I on it, and it "installed"... but..

    [email protected]:~# locate libmysqlclient15off
    /root/libmysqlclient15off_5.0.51a-24+lenny5_amd64.deb
    /usr/share/doc/libmysqlclient15off
    /usr/share/doc/libmysqlclient15off/EXCEPTIONS-CLIENT.gz
    /usr/share/doc/libmysqlclient15off/NEWS.Debian.gz
    /usr/share/doc/libmysqlclient15off/README.Debian
    /usr/share/doc/libmysqlclient15off/changelog.Debian.gz
    /usr/share/doc/libmysqlclient15off/copyright
    /var/lib/dpkg/info/libmysqlclient15off.list
    /var/lib/dpkg/info/libmysqlclient15off.md5sums
    /var/lib/dpkg/info/libmysqlclient15off.postinst
    /var/lib/dpkg/info/libmysqlclient15off.postrm
    /var/lib/dpkg/info/libmysqlclient15off.shlibs

    The above, is all I get.. and of course, the server still wont start.
    Last edited by dbsDev; December 1st, 2014 at 05:03 PM.

  10. #10
    Join Date
    December 2004
    Location
    RF
    Posts
    3,006
    Did get? Good. Now, do remove it and read some more up to date instructions.
    TS3 now supports MySQL through MariaDB plugin.

  11. #11
    Join Date
    March 2015
    Posts
    3

    unable to load database plugin library "libts3db_mysql.so", halting!

    Hello, i tried to connect my teamspeak with a mysql server, but every time i try this i got the following message
    Code:
    INFO    |ServerLibPriv |   | TeamSpeak 3 Server 3.0.11.2 (2014-12-15 14:43:52)
    INFO    |ServerLibPriv |   | SystemInformation: Linux 3.13.0-36-generic #63-Ubuntu SMP Wed Sep 3 21:30:07 UTC 2014 x86_64 Binary: 64bit
    INFO    |DatabaseQuery |   | Please make sure you use the supplied ts3server_minimal_runscript.sh to run the server, or set LD_LIBRARY_PATH yourself
    CRITICAL|DatabaseQuery |   | unable to load database plugin library "libts3db_mysql.so", halting!
    The question: is what can i do?

    I tried everything i know maybe someone had that same problem or can help me anyway.
    Last edited by dante696; March 9th, 2015 at 05:44 PM. Reason: merged

  12. #12
    Join Date
    June 2008
    Posts
    18,151
    1. Do not use outdated tutorials
    2. Read documentations
    3. do a forum search
    4. Use the Maria DB plugin
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

  13. #13
    Join Date
    September 2015
    Posts
    2

    CentOS6 (OVH Release3) - TeamSpeak≥ to MySQL - libts3db_mysql.so

    I want to install my teamspeak server with connection to a mysql database. I use this command ./ts3server_startscript.sh start inifile=ts3server.ini to start it. But there is a error appearing. It tells me that the libts3db_mysql.so is missing.

    1. Error:
    2015-09-03 13:33:20.300899|CRITICAL|DatabaseQuery | | unable to load database plugin library libts3db_mysql.so, halting!
    I tried to download the libmysqlclient.so.15 manualy and renamed it to libts3db_mysql.so. The teamspeak starts without errors but its not working correctly. The logfile just shows this:
    2015-09-03 14:10:32.290799|INFO |ServerLibPriv | | TeamSpeak 3 Server 3.0.11.3 (2015-04-13 13:26:31)
    2015-09-03 14:10:32.291211|INFO |ServerLibPriv | | SystemInformation: Linux 3.14.32-xxxx-grs-ipv6-64 #1 SMP Tue Jun 30 18:50:21 CEST 2015 x86_64 Binary: 64bit

    ts3db_mysql.ini
    [config]
    host='localhost'
    port='3306'
    username='XXX'
    password='PASSXXX'
    database='XXX
    socket=
    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
    dbclientkeepdays=30
    logappend=0
    I also tried to install the MySQL-shared-compat-6.0.11-0.rhel5.x86_64.rpm as root but the only thing that happens is this message:
    Using yum can damage your system
    To use yum at your own risk
    use /usr/bin/yum localinstall MySQL-shared-compat-6.0.11-0.rhel5.x86_64.rpm
    Last edited by dante696; September 10th, 2015 at 10:20 AM. Reason: merged

  14. #14
    Join Date
    September 2012
    Posts
    6,076
    There is no more tsdb_mysql plugin, it got removed in 3.0.11.

    What you have to do is to replace the dbplugin line in your ts3server.ini with
    Code:
    dbplugin=ts3db_mariadb
    Once done you should either be able to start the server, or if you receive an error about a missing library, copy the files from the redist folder to the main folder.

    WARNING! If you are updating the server from a previous version and have never been using any version newer than 3.0.10.x make sure to follow the instructions in doc/update_mysql_to_mariadb.txt once.
    When sending PMs please make sure to include a reference link to the thread in question in the body of your message.

  15. #15
    Join Date
    September 2015
    Posts
    2
    New Error Message:
    2015-09-05 22:03:52.365776|INFO |ServerLibPriv | | TeamSpeak 3 Server 3.0.11.3 (2015-04-13 13:26:31)
    2015-09-05 22:03:52.366173|INFO |ServerLibPriv | | SystemInformation: Linux 3.14.32-xxxx-grs-ipv6-64 #1 SMP Tue Jun 30 18:50:21 CEST 2015 x86_64 Binary: 64bit
    2015-09-05 22:03:52.366893|INFO |DatabaseQuery | | Please make sure you use the supplied ts3server_minimal_runscript.sh to run the server, or set LD_LIBRARY_PATH yourself
    2015-09-05 22:03:52.367084|CRITICAL|DatabaseQuery | | unable to load database plugin library "libts3db_mariadb.so", halting!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Unable to load database plugin
    By TysonPhilip in forum Server Support
    Replies: 1
    Last Post: February 14th, 2016, 07:09 PM
  2. Unable to load database plugin (mysql)
    By snipebase in forum Linux / FreeBSD
    Replies: 2
    Last Post: March 27th, 2011, 04:13 PM
  3. Help, unable to load db plugin lib !
    By abt-network in forum Linux / FreeBSD
    Replies: 4
    Last Post: December 19th, 2010, 06:32 PM
  4. (beta-17) Can't load MySQL plugin
    By Armada651 in forum Server Support
    Replies: 2
    Last Post: February 7th, 2010, 03:51 PM

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
  •