Can't get SQL to work.

**tom_il** · 27-12-2009, 10:42

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

Hi i have read the whole forum for answers and tried everything but no luck.

When i start TS3 up with the command (Or any variant of this)

Code:

./ts3server_linux_x86 dbplugin=ts3db_mysql dbsqlcreatepath=create_mysql/

i get this :

Code:

2009-12-27 09:20:36.966981|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta5 [Build: 9462]
2009-12-27 09:20:37.014069|CRITICAL|DatabaseQuery |   | unable to load database plugin library, halting!

my ts3db_mysql.ini looks like :

Code:

[config]
host=localhost
username=*****
password=*****
database=teamspeak3
(blank line)

Like elsewhere metioned here the output off the LDD command of the SQL Library.

Code:

[root@vds-828553 tss3]# ldd libts3db_mysql.so
        libmysqlclient.so.15 => not found
        libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0xb7dfc000)
        libm.so.6 => /lib/libm.so.6 (0xb7dd3000)
        libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xb7dc7000)
        libc.so.6 => /lib/libc.so.6 (0xb7c6e000)
        /lib/ld-linux.so.2 (0xb7ef4000)

I suspect that first line is the cause of my problems.
Everything runs fine with sqlite3 but i can't get it to work with SQL.

Anyone can help me ?

**MichaelP** · 27-12-2009, 10:48

Code:

aptitude install libmysqlclient15-dev

might help =)

**tom_il** · 27-12-2009, 11:12

Originally Posted by MichaelP

Code:

aptitude install libmysqlclient15-dev

might help =)

thx but no luck

:

Code:

[root@vds-828553 tss3]# aptitude install libmysqlclient15-dev
-bash: aptitude: command not found

**MichaelP** · 27-12-2009, 11:14

oh... what operating system are you using?

**tom_il** · 27-12-2009, 11:39

Originally Posted by MichaelP

oh... what operating system are you using?

FedoraCore 8

**MichaelP** · 27-12-2009, 12:11

ok, i dint worked with fedora yet, but you can try this one

Code:

yum install mysql mysql-devel mysql-client

greetz michael

**tom_il** · 27-12-2009, 13:17

Thank you very much for setting on the right path Michael.

Your command did do something but not the right thing as it still didn't work.

what did the trick was

download the mysqlclient15 from here : http://rpm.pbone.net/index.php3/stat....i386.rpm.html

and then run the command :

rpm -Uhv mysqlclient15-5.0.67-1.fc8.remi.i386.rpm

**tom_il** · 27-12-2009, 13:38

Probably i won't be the only have this problem.

Could it be possible to add the reason why the database couldn't be loaded in the error message ?

Would take away alot of frustration from future users with the same problem

**MichaelP** · 27-12-2009, 19:00

well, if you would be a experienced linux admin, you might be able to fix this on your own

and as i see you fixed it with a bit of google

**tom_il** · 27-12-2009, 23:02

Originally Posted by MichaelP

well, if you would be a experienced linux admin, you might be able to fix this on your own

and as i see you fixed it with a bit of google

LOL, didn't know anything about linux 1year ago so i don't think i am doing to bad. With the help of google of course

It would be a great help if there was a reason shown why the database couldn't be loaded though. Forum would be abit less active then

.

Realy appreciated your help, it put me on the right track.

**dlcerny** · 28-12-2009, 02:39

I had it set up on my first server OK, then disaster, power supply died and took the machine with it. I am now having a similar problem on the new server:

Code:

daniel@Ubuntu1:~/TS3$ ldd libts3db_mysql.so
	linux-gate.so.1 =>  (0x0091e000)
	libmysqlclient.so.15 => /usr/lib/libmysqlclient.so.15 (0x00a62000)
	libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x005e6000)
	libm.so.6 => /lib/tls/i686/cmov/libm.so.6 (0x00f8f000)
	libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x007f9000)
	libc.so.6 => /lib/tls/i686/cmov/libc.so.6 (0x00110000)
	libpthread.so.0 => /lib/tls/i686/cmov/libpthread.so.0 (0x00d08000)
	libcrypt.so.1 => /lib/tls/i686/cmov/libcrypt.so.1 (0x00549000)
	libnsl.so.1 => /lib/tls/i686/cmov/libnsl.so.1 (0x00406000)
	libz.so.1 => /lib/libz.so.1 (0x00254000)
	/lib/ld-linux.so.2 (0x00430000)

Everything seems all right but I get this:

Code:

daniel@Ubuntu1:~/TS3$ ./ts3server_linux_x86 inifile=ts3server.ini 
Logging started
2009-12-28 02:27:24.481414|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta9 [Build: 9527]
2009-12-28 02:27:24.481973|CRITICAL|DatabaseQuery |   | unable to load database plugin library, halting!

What the hades is the problem, I am using the t3db_mysql.ini

Code:

[config]
host=gatekeepersguildonline.net
port=3306
username=*********
password=**********
database=gatekeep_ts
socket=

and ts3server.ini i was using on the one that worked!

Code:

machine_id=
default_voice_port=9987
voice_ip=192.168.1.69
licensepath=licensekey.dat
filetransfer_port=30033
filetransfer_ip=192.168.1.69
query_port=10011
query_ip=192.168.1.69
dbplugin=ts3db_mysql
dbpluginparameter=ts3db_mysql.ini
dbsqlpath=sql/
dbsqlcreatepath=create_mysql/
logpath=logs
logquerycommands=1

Please Help!!!!!

**aeular** · 28-12-2009, 02:51

dlcerny, make sure you have an extra blank line at the end of the ini files, or you get parsing errors since it seems to be looking for key=value\n

**dlcerny** · 28-12-2009, 03:05

Originally Posted by aeular

dlcerny, make sure you have an extra blank line at the end of the ini files, or you get parsing errors since it seems to be looking for key=value\n

Nope still get this after checking, but TY for the reminder!

Code:

daniel@Ubuntu1:~/TS3$ ./ts3server_linux_x86 inifile=ts3server.ini
Logging started
2009-12-28 03:03:56.969565|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta9 [Build: 9527]
2009-12-28 03:03:56.970136|CRITICAL|DatabaseQuery |   | unable to load database plugin library, halting!

**phr3n1c** · 28-12-2009, 09:31

Please provide the output of "ls -la" of the TS3-directory.

**n4aed** · 29-12-2009, 19:53

I have the same issue. I think what the problem is, the file ts3db_mysql is not in the teamspeak directory. I can't seem to find it. Any help would be appreciated.

[root@ns1 tss3-10]# ls -la
total 6308
drwxr-xr-x 7 1002 1002 4096 2009-12-29 14:49 .
drwx------ 8 teamspeak teamspeak 4096 2009-12-28 15:18 ..
-rw-r--r-- 1 1002 1002 7553 2009-12-27 23:05 CHANGELOG
drwxr-xr-x 2 1002 1002 4096 2009-12-27 23:05 doc
drwx------ 3 root root 4096 2009-12-28 15:20 files
-rwxr-xr-x 1 1002 1002 194829 2009-12-27 23:05 libts3db_mysql.so
-rwxr-xr-x 1 1002 1002 821513 2009-12-27 23:05 libts3db_sqlite3.so
-rw-r--r-- 1 1002 1002 23747 2009-12-27 23:05 LICENSE
-rw-r--r-- 1 root root 902 2009-12-28 15:19 licensekey.dat
drwx------ 2 root root 4096 2009-12-29 14:51 logs
-rw-r--r-- 1 root root 112 2009-12-28 15:20 serverkey.dat
drwxr-xr-x 2 1002 1002 4096 2009-12-27 23:05 serverquerydocs
drwxr-xr-x 4 1002 1002 4096 2009-12-27 23:05 sql
-rw-r--r-- 1 root root 93 2009-12-29 14:38 ts3db_mysql.ini
-rw-r--r-- 1 root root 2772 2009-12-29 14:38 ts3.log
-rw-r--r-- 1 root root 2552 2009-12-29 14:38 ts3.log.crash
-rw-r--r-- 1 root root 295 2009-12-29 14:37 ts3server.ini
-rwxr-xr-x 1 1002 1002 5121692 2009-12-27 23:05 ts3server_linux_x86
-rw-r--r-- 1 root root 282 2009-12-29 14:35 ts3serverold.ini
-rw-r--r-- 1 root root 192512 2009-12-29 14:17 ts3server.sqlitedb
-rwxr-xr-x 1 root root 4269 2009-12-29 14:10 ts3ss

Thread: Can't get SQL to work.

Thread Tools

Rate This Thread

Display

Can't get SQL to work.

Had it, but 1st server died.........

Thread Information

Users Browsing this Thread

Similar Threads

[Howto] TS2 Server + MySQL 5.0

TS2 mit MYSQL Probleme

MySQL startup error: SQL files not found

Sever closes down

MySQL connection works but...

Posting Permissions