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

[welter]

So what should I do? How can I convert my database from MySQL to MariaDB / SQLite?

[dante696]

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

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

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

[welter]

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

[dante696]

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

[Jorek]

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?

[dante696]

We don't support the MySQL plugin any longer. You must use the MariaDB plugin.
See post 1 in this thread.

[StayHere]

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.

[JakobIRL]

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

The ts3server.ini contains:

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:

[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:

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.

[dante696]

Please use the mariaDB libary. The MySQL libary support was dropped 2014.

[dadyal]

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 ?