Mysql with beta 20

[Snake6]

I am having a problem with using mysql on beta 20, the server works fine when using the sqlite plugin.

When I run the startscript I get this error:

2010-03-15 06:34:49.365740|CRITICAL|DatabaseQuery |   | unable to load database plugin library "libts3db_mysql.so", halting!

After some googling I found out this was something to do with the libmysqlclient.15 so I ran ldd libts3db_mysql.so and got this:

./libts3db_mysql.so: /usr/lib/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by ./libts3db_mysql.so)
        linux-gate.so.1 =>  (0x00db6000)
        libmysqlclient.so.15 => /usr/lib/libmysqlclient.so.15 (0x00781000)
        libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x001cb000)
        libm.so.6 => /lib/libm.so.6 (0x00110000)
        libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00431000)
        libc.so.6 => /lib/libc.so.6 (0x002b6000)
        libpthread.so.0 => /lib/libpthread.so.0 (0x00a19000)
        libcrypt.so.1 => /lib/libcrypt.so.1 (0x00143000)
        libnsl.so.1 => /lib/libnsl.so.1 (0x00175000)
        /lib/ld-linux.so.2 (0x009b7000)

I tried putting libmysqlclient.so.15.0.0 in the ts install directory and making a link, but no joy. Anyone have any ideas?

[badpiwat82]

I have the same problem. Here is some info on my config:

Folder contains:

-rw-r--r-- 1 srvusr users   15714 Mar 10 06:10 CHANGELOG
-rw-r--r-- 1 srvusr users   24099 Mar 10 06:10 LICENSE
drwxr-xr-x 2 srvusr users    4096 Mar 10 06:10 doc
drwx------ 3 srvusr users    4096 Mar 28 03:05 files
-rwxr-xr-x 1 srvusr users  195053 Mar 10 06:10 libts3db_mysql.so
-rwxr-xr-x 1 srvusr users  827377 Mar 10 06:10 libts3db_sqlite3.so
drwx------ 2 srvusr users    4096 Mar 28 14:00 logs
-rw-r--r-- 1 srvusr users      10 Mar 28 03:05 query_ip_whitelist.txt
drwxr-xr-x 2 srvusr users    4096 Mar 10 06:10 serverquerydocs
drwxr-xr-x 4 srvusr users    4096 Mar 10 06:10 sql
-rw-r--r-- 1 srvusr users  149254 Mar 28 12:24 ts3
-rw-r--r-- 1 srvusr users      88 Mar 28 13:56 ts3db_mysql.ini
-rw-r--r-- 1 srvusr users     317 Mar 28 14:00 ts3server.ini
-rw-r--r-- 1 srvusr users       5 Mar 28 13:47 ts3server.pid
-rw-r--r-- 1 srvusr users  174080 Mar 28 13:20 ts3server.sqlitedb
-rwxr-xr-x 1 srvusr users 5673336 Mar 10 06:10 ts3server_linux_x86
-rwxr-xr-x 1 srvusr users     157 Mar 10 06:10 ts3server_minimal_runscript.sh
-rwxr-xr-x 1 srvusr users    2564 Mar 28 13:34 ts3server_startscript.sh

ts3db_mysql.ini

[config]
 host='localhost'
 username='ts'
 password='*****'
 database='teamspeak3'
 <<-- have the empty last line

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
dbplugin=ts3db_mysql
dbpluginparameter=ts3db_mysql.ini
dbsqlpath=sql/
dbsqlcreatepath=create_mysql/
dblogkeepdays=90
logpath=logs
logquerycommands=0
dbclientkeepdays=30

and I get the following error when I run the command:

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

./ts3server_linux_x86 dbplugin=ts3db_mysql

TeamSpeak Server 3.0.0-beta20 [Build: 10413]
(c)TeamSpeak Systems GmbH

Logging started
2010-03-28 12:09:47.660945|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta20 [Build: 10413], Linux
2010-03-28 12:09:47.661517|INFO    |DatabaseQuery |   | Please make sure you use the supplied ts3server_minimal_runscript.sh to run the server, or set LD_LIBRARY_PATH yourself
2010-03-28 12:09:47.661600|CRITICAL|DatabaseQuery |   | unable to load database plugin library "libts3db_mysql.so", halting!

does anyone know how to solve this?

[Alcazar]

You should run the server with the provided startscripts, else you have to set the library path manually before running the server.

[badpiwat82]

To my total confusion, it works now. So what was the problem? I think I narrowed it down to three things:

1.) create an empty database for your ts server. Do not! import the tables by create.sql provided in the installation package. Make sure your tsdb user has all neccessary permissions to create and populate the tables.

2.) edit the "ts3server_startscript.sh" so that it uses the inifile you created. mine looks like this now:

#!/bin/bash
# Copyright (c) 2010 TeamSpeak Systems GmbH
# All rights reserved

COMMANDLINE_PARAMETERS="inifile=ts3server.ini" #add any command line parameters you want to pass here
BINARYPATH="."
cd "${BINARYPATH}"
LIBRARYPATH="$(pwd)"
...

3.) only use the ts3server_startscript.sh. Then it should work (thx Alcazar).

If you have any problems feel free to contact me.
H

[clanerz]

Thank you for the tip

This almost fixed the same issue for me. All I am still encountering now is that when I addition "inifile=ts3server.ini"to the startscript I get following error:

WARNING ! For security reasons we advise: DO NOT RUN THE SERVER AS ROOT
!!!!!!!!!!!
Starting the TeamSpeak 3 server
TeamSpeak 3 server started, for details please view the log file
.so", halting!rv# 2010-03-29 19:52:56.035476|CRITICAL|DatabaseQuery |   | unable to load database plugin library "libts3db_mysql

Regards,
Stan

[blindrain]

i have the same issue
on beta 18 and 21

[badpiwat82]

Hi Stan,

Well, we're in this together since I tried to start my ts3 server this morning and I get the error message again: "unable to load database plugin library "libts3db_mysql.so", halting!".

It worked fine alle the time, dunno what I did. Will keep you updated though.
Cheers, H

Thank you for the tip

This almost fixed the same issue for me. All I am still encountering now is that when I addition "inifile=ts3server.ini"to the startscript I get following error:

WARNING ! For security reasons we advise: DO NOT RUN THE SERVER AS ROOT
!!!!!!!!!!!
Starting the TeamSpeak 3 server
TeamSpeak 3 server started, for details please view the log file
.so", halting!rv# 2010-03-29 19:52:56.035476|CRITICAL|DatabaseQuery |   | unable to load database plugin library "libts3db_mysql

Regards,
Stan

[WolfStar76]

I'm in the same boat as the rest of you. Same error.

I see the note about creating an empty database, but I'm not very familiar with database creation.

I've borrowed from the posts here - creating an empty database, making a ts3db_mysql.ini file. All to no avail.

If anyone else has any pointers, I'd love to hear them.

I'll be keeping an eye on this thread to see what you clever people come up with.

[Peter]

You need to use the runscript or startscript to start the TS3 server!

[WolfStar76]

You need to use the runscript or startscript to start the TS3 server!

Interesting.

I was following the steps provided in KoldFusion's tutorial, and was using the command:

./ts3server_linux_x86 inifile=ts3server.ini

Running the startscript helped, however. I got the SuperAdmin information, and now I have to work go read to see what's going on with my license file.

Thanks, Peter!

[Paddy1991]

I have the same problem... I be reading the TeamSpeak 3 will work only with MySQL version 5.0x

(sry for my bad english ^^)

[OpticHosts]

I assume everyone here is using the latest version of PHP. I had this same problem and could not figure out why. I followed some threads on this forum to debug this problem my self. I found out the problem but CentOS would not let me install and old version of libmysqlclient.so

PHP 5.2 uses libmysqlclient.so.16 however it creates a symbolic link from libmysqlclient.so.15 to libmysqlclient.so.16. Apparently TS does not like this.

This thread has a copy of the old .15 to download. Just put this file in the root directory of your TS3 release. Also create the symbolic link there as well.

http://forum.teamspeak.com/showthrea...qlclient.so.15

Post #2 has the file and Post #5 shows the link command.