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

[Corrupter]

Greetings, its been a while since this type of issue was visited and i would like to post my latest findings on the latest crop of this problem.

So it would seem the the developers of teamspeak 3 only really had 1 version of libmysqlclient150ff in mind when they developed the mysql support for ts3. I had a ts3 server running for a bit on the ubuntu flavor distro and things we're fine till i decided i needed to update my linux box to the latest version of Ubuntu which is 11.10 (Oneiric). So rather than upgrade the system using the commands i started from scratch and blew it all away. From a fresh install i installed the following packages,

mysql-client and mysql-server however these no longer supply the previously needed libmysqlclient15off for the beta version of ts3 i was using before. So, after getting the system up and seeing the mysql db running smoothly i went ahead and downloaded the latest linux 32bit variety of ts3 server. popped it on the machine, configured my ini files with the appropriate information and setup the ts3 user that would be used to execute this whole mess. went ahead and tried to run it for the first time to get my keys and voila, it doesnt like that there again is no libmysqlclient.so.15 so i happen to have a copy of actual package from my previous ts3 server that was running happily in beta up to this point, went ahead and dpkg -i libmysqlclient15off and its in. Attempt number two at running the server except its still giving me the same message. So i hammer out ldd libts3db_mysql.so and this time it shows all dependencies are there and present. Hmmm as i scratch my head... What the hecks going on here? So i methodically check all the steps i did, making sure to the best of my knowledge to determine if i had missed one or not and still nothing... not a change in the results.

So where am i at? i thought perhaps there was different versions of libmysqlclient.so.15 out there so i tracked down a half dozen packages for a few different distros even, started plugging them all with the same results, each time ldd libts3db_mysql.so showing the dependencies there.... I've tried all the links from the 5 or 6 so posts on this forum about this issue and replicated each of their attempts, even the ones that people have said worked for them. Perhaps there is something wrong with the 32bit version of ts3 linux server and its compatability with a specific version? I dont know, but i know this, i've tried alot and got a whole lot more of no where. Anyone have any ideas?

I'll paste here some things about what im using as my current testbed.

OS: Linux Ubuntu 11.10 Oneiric 32bit.
TS3: Linux Server x86 3.0.0 from 4netplayers
mysql 5.1.58-1ubuntu1 (Ubuntu)
libmysqlclient15off versions tried:
libmysqlclient15off_5.1.30really5.0.83-0ubuntu3_i386.deb
libmysqlclient15off_5.0.51a-3ubuntu5.8_i386.deb
libmysqlclient15off_5.0.51a-24+lenny5_i386.deb
MySQL-shared-compat-6.0.9-0.sles9.i586.rpm (yes i know this is an rpm, i used alien to convert it to .deb)

each time it produced these results:

libmysqlclient15off_5.1.30really5.0.83-0ubuntu3_i386

:/opt/ts3server$ ldd libts3db_mysql.so
        linux-gate.so.1 =>  (0xb773f000)
        libmysqlclient.so.15 => /usr/lib/libmysqlclient.so.15 (0xb754e000)
        libstdc++.so.6 => /usr/lib/i386-linux-gnu/libstdc++.so.6 (0xb7463000)
        libm.so.6 => /lib/i386-linux-gnu/libm.so.6 (0xb7438000)
        libgcc_s.so.1 => /lib/i386-linux-gnu/libgcc_s.so.1 (0xb741a000)
        libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xb729e000)
        libpthread.so.0 => /lib/i386-linux-gnu/libpthread.so.0 (0xb7283000)
        libcrypt.so.1 => /lib/i386-linux-gnu/libcrypt.so.1 (0xb7252000)
        libnsl.so.1 => /lib/i386-linux-gnu/libnsl.so.1 (0xb7238000)
        libz.so.1 => /lib/i386-linux-gnu/libz.so.1 (0xb7223000)
        /lib/ld-linux.so.2 (0xb7740000)


libmysqlclient15off_5.0.51a-3ubuntu5.8_i386

:/opt/ts3server$ ldd libts3db_mysql.so
        linux-gate.so.1 =>  (0xb7802000)
        libmysqlclient.so.15 => /usr/lib/libmysqlclient.so.15 (0xb7612000)
        libstdc++.so.6 => /usr/lib/i386-linux-gnu/libstdc++.so.6 (0xb7527000)
        libm.so.6 => /lib/i386-linux-gnu/libm.so.6 (0xb74fc000)
        libgcc_s.so.1 => /lib/i386-linux-gnu/libgcc_s.so.1 (0xb74de000)
        libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xb7362000)
        libpthread.so.0 => /lib/i386-linux-gnu/libpthread.so.0 (0xb7347000)
        libcrypt.so.1 => /lib/i386-linux-gnu/libcrypt.so.1 (0xb7316000)
        libnsl.so.1 => /lib/i386-linux-gnu/libnsl.so.1 (0xb72fc000)
        libz.so.1 => /lib/i386-linux-gnu/libz.so.1 (0xb72e7000)
        /lib/ld-linux.so.2 (0xb7803000)


libmysqlclient15off_5.0.51a-24+lenny5_i386

:/opt/ts3server$ ldd libts3db_mysql.so
        linux-gate.so.1 =>  (0xb7727000)
        libmysqlclient.so.15 => /usr/lib/libmysqlclient.so.15 (0xb752e000)
        libstdc++.so.6 => /usr/lib/i386-linux-gnu/libstdc++.so.6 (0xb7443000)
        libm.so.6 => /lib/i386-linux-gnu/libm.so.6 (0xb7418000)
        libgcc_s.so.1 => /lib/i386-linux-gnu/libgcc_s.so.1 (0xb73fa000)
        libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xb727e000)
        libpthread.so.0 => /lib/i386-linux-gnu/libpthread.so.0 (0xb7263000)
        libcrypt.so.1 => /lib/i386-linux-gnu/libcrypt.so.1 (0xb7232000)
        libnsl.so.1 => /lib/i386-linux-gnu/libnsl.so.1 (0xb7218000)
        libz.so.1 => /lib/i386-linux-gnu/libz.so.1 (0xb7203000)
        /lib/ld-linux.so.2 (0xb7728000)


MySQL-shared-compat-6.0.9-0.sles9.i586.rpm

:/opt/ts3server$ ldd libts3db_mysql.so
        linux-gate.so.1 =>  (0xb7809000)
        libmysqlclient.so.15 => /usr/lib/libmysqlclient.so.15 (0xb7619000)
        libstdc++.so.6 => /usr/lib/i386-linux-gnu/libstdc++.so.6 (0xb752e000)
        libm.so.6 => /lib/i386-linux-gnu/libm.so.6 (0xb7503000)
        libgcc_s.so.1 => /lib/i386-linux-gnu/libgcc_s.so.1 (0xb74e5000)
        libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xb7369000)
        libpthread.so.0 => /lib/i386-linux-gnu/libpthread.so.0 (0xb734e000)
        libcrypt.so.1 => /lib/i386-linux-gnu/libcrypt.so.1 (0xb731d000)
        libnsl.so.1 => /lib/i386-linux-gnu/libnsl.so.1 (0xb7303000)
        libz.so.1 => /lib/i386-linux-gnu/libz.so.1 (0xb72ee000)
        /lib/ld-linux.so.2 (0xb780a000)


unknown

:/opt/ts3server$ ldd libts3db_mysql.so
        linux-gate.so.1 =>  (0xb7859000)
        libmysqlclient.so.15 => /usr/lib/libmysqlclient.so.15 (0xb7669000)
        libstdc++.so.6 => /usr/lib/i386-linux-gnu/libstdc++.so.6 (0xb757e000)
        libm.so.6 => /lib/i386-linux-gnu/libm.so.6 (0xb7553000)
        libgcc_s.so.1 => /lib/i386-linux-gnu/libgcc_s.so.1 (0xb7535000)
        libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xb73b9000)
        libpthread.so.0 => /lib/i386-linux-gnu/libpthread.so.0 (0xb739e000)
        libcrypt.so.1 => /lib/i386-linux-gnu/libcrypt.so.1 (0xb736d000)
        libnsl.so.1 => /lib/i386-linux-gnu/libnsl.so.1 (0xb7353000)
        libz.so.1 => /lib/i386-linux-gnu/libz.so.1 (0xb733e000)
        /lib/ld-linux.so.2 (0xb785a000)

Ok, first person to suggest something that works gets a beer on me!

And for the last and latest attempt on a completely and totally new fresh install:

TeamSpeak Server 3.0.0 [Build: 14957]
(c)TeamSpeak Systems GmbH

Logging started
2011-11-04 23:03:50.803454|INFO    |ServerLibPriv |   | Server Version: 3.0.0 [Build: 14957], Linux
2011-11-04 23:03:50.804764|INFO    |DatabaseQuery |   | Please make sure you use the supplied ts3server_minimal_runscript.sh to run the server, or set LD_LIBRARY_PATH yourself
2011-11-04 23:03:50.805275|CRITICAL|DatabaseQuery |   | unable to load database plugin library "libts3db_mysql.so", halting!

[dante696]

I'm a linux noob, but I can tell you, how i got our server running with MYSQl under Ubuntu-11.10

1. Open the console and type sudo apt-get install libmysqlclient-dev (skipp this step, if done already)
2. Download the libmysqlclient.so.15.0.0 package I provide here and unzip it.
3. Open the console again and switch to directoy, where libmysqlclient.so.15.0.0 was unzipped.
4. Copy this libary and activate it. (Please run these 3 commands.)

sudo cp libmysqlclient.so.15.0.0 /usr/lib/
sudo ln -s /usr/lib/libmysqlclient.so.15.0.0 /usr/lib/libmysqlclient.so.15
sudo ldconfig

5. Start the server per ts3server_minimal_runscript.sh

[Corrupter]

Turned out for me to be a permissions issue. i had to make sure chmod 755 the entire directory and make sure the user had write permissions for the new folders the user was creating when running the ts3server for the first time. I also had a jailkit in place that was restricting the user i was running the program as to accessing the libmysql files so i had to configure that.

Furthermore i intended on doing this on a server running an apache server so i will be re-doing this from scratch and checking and noting my results, maybe i'll write my steps and results here to prevent someone else from hitting this wall as well again.

[NHDriver4]

I'm a linux noob, but I can tell you, how i got our server running with MYSQl under Ubuntu-11.10

Dante696,

Your "noob" linux advice enabled me to get my server up and running on my Ubuntu Natty 64bit server. Thanks for taking the time to share your results, and upload these files. In time, I hope that the TeamSpeak developers plan around these issues, and add in some more compatibility readiness in their server program.

[dante696]

The problem is, that these MYSQl libarys differ on each Linux distribution.