Forum

Page 3 of 3 FirstFirst 123
Results 31 to 40 of 40
  1. #31
    Join Date
    March 2007
    Posts
    30
    So what should I do? How can I convert my database from MySQL to MariaDB / SQLite?

  2. #32
    Join Date
    June 2008
    Posts
    18,273
    You can go on using a MySQL databse for your server as long MariaDB supports it.
    But you must use the MariaDB plugin from now on and you need to read the documentation update_mysql_to_mariadb.txt.

    This was explained in post 1# and #7 and the given URL
    Quote Originally Posted by dante696 View Post
    How to convert the server to MariaDB standard (and using MySQL or MariaDB)
    http://forum.teamspeak.com/showthrea...424#post388424
    Quote Originally Posted by dante696 View Post
    In case you did use MYSQL with server 3.0.10.3 just like to update the TeamSpeak server
    1. Make a backup of your existing database
    2. Install the server 3.0.12.4 (or newer)
    3. Read update_mysql_to_mariadb.txt from your Doc folder
    4. Run convert_mysql_to_mariadb.sql and mariadb_fix_latin_utf8.sql from folder (sql\updates_and_fixes)
    5. Replace all MYSQL paramters for Maria DB (shown in step 4 and 5)
    6. Start the server with parameter inifile=ts3server.ini
    7. Check your server logs for success or errors
    Last edited by dante696; September 16th, 2016 at 03:34 PM.
    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?

  3. #33
    Join Date
    March 2007
    Posts
    30
    Quote Originally Posted by dante696 View Post
    You can go on using a MySQL databse for your server as long MariaDB supports it.
    But you must use the MariaDB plugin from now on and you need to read the documentation update_mysql_to_mariadb.txt.

    This was explained in post 1# and #7 and the given URL
    I did exactly what was said in there but I had a problem with executing these .sql files.
    I received few errors when I executed them (using the 'source' command as I found on google - it was not mentioned in the .txt instructions file), one of them was: ERROR 1115 (42000): Unknown character set: 'utf8mb4'

    Most of the errors if not all of them were about "utf8mb4" not being recognized

  4. #34
    Join Date
    June 2008
    Posts
    18,273
    Quote Originally Posted by welter View Post
    it was not mentioned in the .txt instructions file
    We mentoined that in the update_mysql_to_mariadb.txt:
    2. To fully support Utf8 characters, we need the TeamSpeak database to work with the 'utf8mb4'
    character set. This was not available when TeamSpeak 3 was released back in 2009. This character
    set was introduced in MySql 5.5.3 and thus we needed to upgrade to a MySQL client 5.5 or higher.

    That is an MySQL error and tells you that your MySQL version is old and outdated does not know utf8mb4.
    Update your MySQL version to the latest version 5.7.15 and then perfom the sql files.
    Making a backup is recommended!

    Source: http://stackoverflow.com/questions/2...er-set-utf8mb4
    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?

  5. #35
    Join Date
    October 2016
    Posts
    1

    TS3 3.0.13.x server cant load DB plug (MySQL) Linux 3.2.0-4-686

    Hello,
    Got problem after upgrade from 3.0.12.4 to 3.0.13.x.

    [email protected]:~/teamspeak3-server_linux-x86$ ./ts3server_minimal_runscript.sh inifile=ts3server.ini
    2016-10-27 19:58:18.390283|INFO |ServerLibPriv | |TeamSpeak 3 Server 3.0.13.5 (2016-10-24 11:53:53)
    2016-10-27 19:58:18.391472|INFO |ServerLibPriv | |SystemInformation: Linux 3.2.0-4-686-pae #1 SMP Debian 3.2.73-2+deb7u3 i686 Binary: 32bit
    2016-10-27 19:58:18.405993|ERROR |DatabaseQuery | |Failed to import "ts3dbplugin_bulk_insert" from "libts3db_mysql.so"
    2016-10-27 19:58:18.406634|ERROR |DatabaseQuery | |Failed to import "ts3dbplugin_shortname" from "libts3db_mysql.so"
    2016-10-27 19:58:18.407285|ERROR |DatabaseQuery | |Failed to import "ts3dbplugin_apiversion" from "libts3db_mysql.so"
    2016-10-27 19:58:18.407753|CRITICAL|DatabaseQuery | |Could not load database plugin

    [email protected]:~/teamspeak3-server_linux-x86$
    [email protected]:~/teamspeak3-server_linux-x86$ ./ts3server_minimal_runscript.sh inifile=ts3server.ini
    2016-10-27 19:58:46.289503|INFO |ServerLibPriv | |TeamSpeak 3 Server 3.0.13.4 (2016-08-29 12:39:04)
    2016-10-27 19:58:46.300944|INFO |ServerLibPriv | |SystemInformation: Linux 3.2.0-4-686-pae #1 SMP Debian 3.2.73-2+deb7u3 i686 Binary: 32bit
    2016-10-27 19:58:46.555650|ERROR |DatabaseQuery | |Failed to import "ts3dbplugin_bulk_insert" from "libts3db_mysql.so"
    2016-10-27 19:58:46.555905|ERROR |DatabaseQuery | |Failed to import "ts3dbplugin_shortname" from "libts3db_mysql.so"
    2016-10-27 19:58:46.556048|ERROR |DatabaseQuery | |Failed to import "ts3dbplugin_apiversion" from "libts3db_mysql.so"
    2016-10-27 19:58:46.556181|CRITICAL|DatabaseQuery | |Could not load database plugin

    [email protected]:~/teamspeak3-server_linux-x86$
    [email protected]:~/teamspeak3-server_linux-x86$ ./ts3server_minimal_runscript.sh inifile=ts3server.ini
    2016-10-27 19:59:09.643731|INFO |ServerLibPriv | |TeamSpeak 3 Server 3.0.13.3 (2016-08-18 16:46:43)
    2016-10-27 19:59:09.644714|INFO |ServerLibPriv | |SystemInformation: Linux 3.2.0-4-686-pae #1 SMP Debian 3.2.73-2+deb7u3 i686 Binary: 32bit
    2016-10-27 19:59:09.713864|INFO |DatabaseQuery | |dbPlugin name: MySQL plugin, (c)TeamSpeak Systems GmbH
    2016-10-27 19:59:09.714522|INFO |DatabaseQuery | |dbPlugin version: 1
    Segmentation fault

    [email protected]:~/teamspeak3-server_linux-x86$
    [email protected]:~/teamspeak3-server_linux-x86$ ./ts3server_minimal_runscript.sh inifile=ts3server.ini
    2016-10-27 19:59:34.730826|INFO |ServerLibPriv | |TeamSpeak 3 Server 3.0.13.2 (2016-08-15 10:04:11)
    2016-10-27 19:59:34.737773|INFO |ServerLibPriv | |SystemInformation: Linux 3.2.0-4-686-pae #1 SMP Debian 3.2.73-2+deb7u3 i686 Binary: 32bit
    2016-10-27 19:59:34.819016|INFO |DatabaseQuery | |dbPlugin name: MySQL plugin, (c)TeamSpeak Systems GmbH
    2016-10-27 19:59:34.819287|INFO |DatabaseQuery | |dbPlugin version: 1
    Segmentation fault

    [email protected]:~/teamspeak3-server_linux-x86$
    [email protected]:~/teamspeak3-server_linux-x86$ ./ts3server_minimal_runscript.sh inifile=ts3server.ini
    2016-10-27 19:59:58.382914|INFO |ServerLibPriv | |TeamSpeak 3 Server 3.0.13.1 (2016-08-14 08:52:28)
    2016-10-27 19:59:58.384163|INFO |ServerLibPriv | |SystemInformation: Linux 3.2.0-4-686-pae #1 SMP Debian 3.2.73-2+deb7u3 i686 Binary: 32bit
    2016-10-27 19:59:58.481914|INFO |DatabaseQuery | |dbPlugin name: MySQL plugin, (c)TeamSpeak Systems GmbH
    2016-10-27 19:59:58.482241|INFO |DatabaseQuery | |dbPlugin version: 1
    Segmentation fault

    [email protected]:~/teamspeak3-server_linux-x86$



    On all version 3.0.13.x got this problem (now I back to 3.0.12.4 and works great).
    Config files:
    [email protected]:~/teamspeak3-server_linux-x86$ cat ts3server.ini
    machine_id=
    default_voice_port=9988
    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

    [email protected]:~/teamspeak3-server_linux-x86$ cat ts3db_mysql.ini
    [config]
    host=127.0.0.1
    port=3306
    username=teamspeak
    password=haslodots3.
    database=teamspeak
    socket=


    Any changes in config files in 3.0.13.x version?
    Last edited by dante696; October 27th, 2016 at 11:00 PM. Reason: merged

  6. #36
    Join Date
    June 2008
    Posts
    18,273
    We don't support the MySQL plugin any longer. You must use the MariaDB plugin.
    See post 1 in this thread.
    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?

  7. #37
    Join Date
    December 2014
    Posts
    2

    Error on start server 3.0.13.5

    2016-10-30 23:14:21.365464|ERROR |DatabaseQuery | |Failed to import "ts3dbplugin_bulk_insert" from "libts3db_mysql.so"
    2016-10-30 23:14:21.365714|ERROR |DatabaseQuery | |Failed to import "ts3dbplugin_shortname" from "libts3db_mysql.so"
    2016-10-30 23:14:21.365888|ERROR |DatabaseQuery | |Failed to import "ts3dbplugin_apiversion" from "libts3db_mysql.so"
    2016-10-30 23:14:21.365993|CRITICAL|DatabaseQuery | |Could not load database plugin


    Help pls. I cant start my teamspeak3 server.

  8. #38
    Join Date
    September 2017
    Posts
    5

    Exclamation unable to load database plugin library "libts3db_mysql.so"

    I want to set up a TS3 server with MySQL database.

    The ts3server.ini contains:
    Code:
    machine_id=
    default_voice_port=9987
    voice_ip=
    licensepath=
    filetransfer_port=30033
    filetransfer_ip=
    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_sqlite/
    dbconnections=10
    logpath=logs
    logquerycommands=0
    dbclientkeepdays=30
    logappend=1
    query_skipbruteforcecheck=0
    The ts3db_mysql.ini contains:
    Code:
    [config]
    host='127.0.0.1'
    port='3306'
    username='teamspeak'
    password='s3cret'
    database='teamspeak'
    socket=
    When I start the server by "./ts3server_startscript.sh start inifile=ts3server.ini" it says:
    Code:
    2017-10-12 08:43:47.911175|CRITICAL|DatabaseQuery |   |unable to load database plugin library "libts3db_mysql.so", halting!
    In the whole system no such file exists and it is also not shipped with the TS3 server ZIP file.
    I tried to install the package "libmysqlclient15off", but this package doesn't even exist in any Ubuntu repository.

    I use Ubuntu Server 16.04.
    Last edited by dante696; October 12th, 2017 at 10:53 AM. Reason: merged

  9. #39
    Join Date
    June 2008
    Posts
    18,273
    Please use the mariaDB libary. The MySQL libary support was dropped 2014.
    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?

  10. #40
    Join Date
    August 2018
    Posts
    3

    Unable to upgrade teamspeak server on cent os 6

    my teamspeak server is version 3.0.11.3 running on centos 6 and none of new teamspeak client users are able to connect to my server so i tried to upgrade it by

    stopping the teamspeak then copy pasting new server files on old ones via sftp and restarting the server
    now when i start my server i get database plugin error i search it up and found out that teamspeak stopped using mysql and now using mariaDB or Sqlite but centos 6 does not have it so i tried to install it for some reason it does not work ( i am not good with linux so i guess i am doing something wrong )

    so can you guys make me tutorial with commands so i can copy paste them and make my server running ?
    Last edited by dante696; August 17th, 2018 at 09:04 AM. Reason: merged see post 7.

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, 08:09 PM
  2. Unable to load database plugin (mysql)
    By snipebase in forum Linux / FreeBSD
    Replies: 2
    Last Post: March 27th, 2011, 05:13 PM
  3. Help, unable to load db plugin lib !
    By abt-network in forum Linux / FreeBSD
    Replies: 4
    Last Post: December 19th, 2010, 07:32 PM
  4. (beta-17) Can't load MySQL plugin
    By Armada651 in forum Server Support
    Replies: 2
    Last Post: February 7th, 2010, 04: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
  •