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

[PoL4K]

I need to run server on MySQL.
I used this comand:

./ts3server_linux_amd64 inifile=ts3server.ini

Returns:

2012-03-15 16:41:18.850558|INFO |ServerLibPriv | | TeamSpeak 3 Server 3.0.2 (2012-02-29 05:39:32)
2012-03-15 16:41:18.850772|INFO |DatabaseQuery | | Please make sure you use the supplied ts3server_minimal_runscript.sh to run the server, or set LD_LIBRARY_PATH yourself
2012-03-15 16:41:18.850804|CRITICAL|DatabaseQuery | | unable to load database plugin library "libts3db_mysql.so", halting!

ldd libts3db_mysql.so

        linux-vdso.so.1 =>  (0x00007fffd3385000)
        libmysqlclient.so.15 => /usr/lib/libmysqlclient.so.15 (0x00007f21c1556000)
        libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x00007f21c1242000)
        libm.so.6 => /lib/libm.so.6 (0x00007f21c0fbf000)
        libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00007f21c0da9000)
        libc.so.6 => /lib/libc.so.6 (0x00007f21c0a47000)
        libcrypt.so.1 => /lib/libcrypt.so.1 (0x00007f21c080f000)
        libnsl.so.1 => /lib/libnsl.so.1 (0x00007f21c05f7000)
        libz.so.1 => /usr/lib/libz.so.1 (0x00007f21c03e0000)
        librt.so.1 => /lib/librt.so.1 (0x00007f21c01d7000)
        /lib64/ld-linux-x86-64.so.2 (0x00007f21c1ab9000)
        libpthread.so.0 => /lib/libpthread.so.0 (0x00007f21bffbb000)

INI File:

machine_id=
default_voice_port=9987
voice_ip=91.205.**.**
liscensepath=
filetransfer_port=30033
filetransfer_ip=91.205.**.**
query_port=10011
query_ip=91.205.**.**
dbplugin=ts3db_mysql
dbpluginparameter=ts3db_mysql.ini
dbsqlpath=sql/
dbsqlcreatepath=create_mysql/
logpath=logs
logquerycommands=1

ts3db_mysql.ini

[config]
host=localhost
port=3306
username=ts3
password=** hidden **
database=ts3
socket=

Help me!

OS: Debian 6.0 64bit

[florian_fr40]

Hello

./ts3server_linux_amd64 inifile=ts3server.ini

Please don't ignore the informative message from your server log :

2012-03-15 16:41:18.850772|INFO |DatabaseQuery | | Please make sure you use the supplied ts3server_minimal_runscript.sh

You have to use the startscript or the minimal_runscript

in your case

./ts3server_startscript.sh start inifile=ts3server.ini
or
./ts3server_minimal_runscript.sh inifile=ts3server.ini

Also, don't forget to read the documentation
TeamSpeak 3 Server Quick Start.txt

Note:
This question has been answered many times on this forum. Next time please use the forum search function

[PoL4K]

ts3@debian:~/srv$ ./ts3server_minimal_runscript.sh inifile=ts3server.ini

2012-03-15 17:08:57.273219|INFO    |ServerLibPriv |   | TeamSpeak 3 Server 3.0.2 (2012-02-29 05:39:32)
2012-03-15 17:08:57.273936|INFO    |DatabaseQuery |   | dbPlugin name:    MySQL plugin, (c)TeamSpeak Systems GmbH
2012-03-15 17:08:57.273968|INFO    |DatabaseQuery |   | dbPlugin version: 1
2012-03-15 17:09:12.292514|ERROR   |DatabaseQuery |   | mysql_real_connect() failed with error: Can't connect to MySQL server on 'localhost' (111)
2012-03-15 17:09:12.292574|CRITICAL|ServerLibPriv |   | Server() DatabaseError
ts3@debian:~/srv$

./ts3server_startscript.sh start inifile=ts3server.ini

TeamSpeak 3 server started, for details please view the log file
ts3@debian:~/srv$ 2012-03-15 17:10:26.868759|CRITICAL|ServerLibPriv |   | Server() DatabaseError

I haven't any tables in db.

[florian_fr40]

mysql_real_connect() failed with error: Can't connect to MySQL server on 'localhost' (111)

Do you check your mysql server configuration ?
The ts3 mysql user is allow to connect with the localhost address (do you try with the IP instead) ?
Are you able to connect on the mysql server with another tool like HeidiSQL or the mysql command ?

[PoL4K]

I set root in connection now and returns:

2012-03-15 17:32:05.237354|INFO    |ServerLibPriv |   | TeamSpeak 3 Server 3.0.2 (2012-02-29 05:39:32)
2012-03-15 17:32:05.238005|INFO    |DatabaseQuery |   | dbPlugin name:    MySQL plugin, (c)TeamSpeak Systems GmbH
2012-03-15 17:32:05.238037|INFO    |DatabaseQuery |   | dbPlugin version: 1
2012-03-15 17:32:05.238454|ERROR   |DatabaseQuery |   | mysql_real_connect() failed with error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)
2012-03-15 17:32:05.238487|CRITICAL|ServerLibPriv |   | Server() DatabaseError

[Barungar]

can you connect to the database using the mysql command line interpreter?

try "mysql -u ts3 -p ts3" ...

[PoL4K]

mysql

mysql: relocation error: mysql: symbol strmov_overlapp, version libmysqlclient_16 not defined in file libmysqlclient.so.16 with link time reference

A try to fix them and I didn't find anything about this.

[Barungar]

To me it seems your whole mysql installation is quit, lets say bugged. So it might help a lot to fix mysql first or change to sqlite db for ts3.

[PoL4K]

Do you know how i can fix this bug?

[Barungar]

If you search mysql related forums and other boards you might find some hints.

I found so far, that some debian/ubuntu users got that error because some mysql related paket was not installed properly. Some users stated that it occured after a not so smooth mysql related paket update. Some also state that a complete remove and reinstall of *all* mysql related pakages solved their issues.

So my advice is... look through the net how to fix you mysql problem or use sqlite for you ts3 server.

[PoL4K]

If you search mysql related forums and other boards you might find some hints.

I found so far, that some debian/ubuntu users got that error because some mysql related paket was not installed properly. Some users stated that it occured after a not so smooth mysql related paket update. Some also state that a complete remove and reinstall of *all* mysql related pakages solved their issues.

So my advice is... look through the net how to fix you mysql problem or use sqlite for you ts3 server.

Thanks so much