Community Forums Today's Posts     Member List     Archive    
Results 1 to 5 of 5
  1. 19-02-2010, 05:49 #1
    CLOWNISIUS
    CLOWNISIUS is offline -= TeamSpeak User =-
    Join Date
    Feb 2005
    Location
    San Francisco
    Posts
    12

    [solved]server unable to load mysql library

    I hope the title is descriptive enough.

    currently using beta 18, and unable to load the mysql library, but the sqlite library loads.

    I'm aware of the LD_LIBRARY_PATH, and it loads up the sqlite as intended, but not the mysql library.

    If anyone catches something wrong, let me know:

    output without mysql:
    Code:
    anthony@teamspeak:/opt/TS3$ export LD_LIBRARY_PATH=".:$LD_LIBRARY_PATH"
anthony@teamspeak:/opt/TS3$ echo $LD_LIBRARY_PATH
.:
anthony@teamspeak:/opt/TS3$ ./ts3server_linux_amd64
TeamSpeak Server 3.0.0-beta18 [Build: 10190]
(c)TeamSpeak Systems GmbH

Logging started
2010-02-19 05:44:15.088432|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta18 [Build: 10190]
2010-02-19 05:44:15.094780|INFO    |DatabaseQuery |   | dbPlugin name:    SQLite3 plugin, (c)TeamSpeak Systems GmbH
2010-02-19 05:44:15.095041|INFO    |DatabaseQuery |   | dbPlugin version: 3.6.21
2010-02-19 05:44:15.095892|INFO    |DatabaseQuery |   | checking database integrity (may take a while)
2010-02-19 05:44:15.115946|INFO    |SQL           |   | pruning old database log entries where timestamp is older than 90 days

    Output attempting to load mysql:
    Code:
    anthony@teamspeak:/opt/TS3$ export LD_LIBRARY_PATH=".:$LD_LIBRARY_PATH"
anthony@teamspeak:/opt/TS3$ echo $LD_LIBRARY_PATH
.:.:
anthony@teamspeak:/opt/TS3$ ./ts3server_linux_amd64 dbplugin=ts3db_mysql dbsqlcreatepath=create_mysql/
TeamSpeak Server 3.0.0-beta18 [Build: 10190]
(c)TeamSpeak Systems GmbH

Logging started
2010-02-19 05:45:19.706069|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta18 [Build: 10190]
2010-02-19 05:45:19.706611|INFO    |DatabaseQuery |   | Please make sure you use the supplied ts3server_minimal_runscript.sh to run the server, or set LD_LIBRARY_PATH yourself
2010-02-19 05:45:19.706662|CRITICAL|DatabaseQuery |   | unable to load database plugin library "libts3db_mysql.so", halting!
    I did do the exoprt of the LD_LIBRARY_PATH to include the current directory...

    I also tried the hax way of loading up the LD_LIBRARY_PATH into an application:
    Code:
    anthony@teamspeak:/opt/TS3$  /lib/ld-linux-x86-64.so.2 --library-path .:/opt/TS3 ./ts3server_linux_amd64 dbplugin=ts3db_mysql dbsqlcreatepath=create_mysql/
TeamSpeak Server 3.0.0-beta18 [Build: 10190]
(c)TeamSpeak Systems GmbH

Logging started
2010-02-19 05:46:12.646425|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta18 [Build: 10190]
2010-02-19 05:46:12.646914|INFO    |DatabaseQuery |   | Please make sure you use the supplied ts3server_minimal_runscript.sh to run the server, or set LD_LIBRARY_PATH yourself
2010-02-19 05:46:12.646963|CRITICAL|DatabaseQuery |   | unable to load database plugin library "libts3db_mysql.so", halting!

    my uname:
    Code:
    anthony@teamspeak:/opt/TS3$ uname -a
Linux teamspeak 2.6.31-16-server #53-Ubuntu SMP Tue Dec 8 05:08:02 UTC 2009 x86_64 GNU/Linux
    ldd output of the shared library:
    Code:
    anthony@teamspeak:/opt/TS3$ ldd libts3db_mysql.so
        linux-vdso.so.1 =>  (0x00007fff941ff000)
        libmysqlclient.so.15 => not found
        libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x00007f8555d7e000)
        libm.so.6 => /lib/libm.so.6 (0x00007f8555af9000)
        libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00007f85558e2000)
        libc.so.6 => /lib/libc.so.6 (0x00007f8555573000)
        /lib64/ld-linux-x86-64.so.2 (0x00007f855629a000)
    and for ts3server_linux_amd64:
    Code:
    anthony@teamspeak:/opt/TS3$ ldd ts3server_linux_amd64
        linux-vdso.so.1 =>  (0x00007fffad3af000)
        libdl.so.2 => /lib/libdl.so.2 (0x00007fa37ba07000)
        librt.so.1 => /lib/librt.so.1 (0x00007fa37b7ff000)
        libpthread.so.0 => /lib/libpthread.so.0 (0x00007fa37b5e3000)
        libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x00007fa37b2d3000)
        libm.so.6 => /lib/libm.so.6 (0x00007fa37b04f000)
        libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00007fa37ae38000)
        libc.so.6 => /lib/libc.so.6 (0x00007fa37aac9000)
        /lib64/ld-linux-x86-64.so.2 (0x00007fa37bc0b000)
    32bit version works fine btw...

    If I need to attach more output, please let me know what else I should put up.

    Thanks.
    Last edited by Peter; 20-02-2010 at 15:40.
  2. 19-02-2010, 09:44 #2
    Peter
    Peter is offline -= TeamSpeak Team =-
    Join Date
    Jul 2002
    Location
    Germany
    Posts
    2,836
    This is the problem:

    libmysqlclient.so.15 => not found
    To use mysql you need the (right) mysqlclient library installed.
    You think my answer is stupid ? Read This:
    http://www.catb.org/~esr/faqs/smart-...ons.html#intro

    In a world without fences and walls - who needs windows and gates ?
  3. 19-02-2010, 14:12 #3
    CLOWNISIUS
    CLOWNISIUS is offline -= TeamSpeak User =-
    Join Date
    Feb 2005
    Location
    San Francisco
    Posts
    12
    doh' ... I spent too much time looking at the configs that I didn't notice the LDD, thank you for that spot... just so tired. *sigh*

    EDIT: Installed the "libmysqlclient15off" package from the ubuntu 9.10 repos, and that resolved my issue.

    Thanks again.
    Last edited by CLOWNISIUS; 19-02-2010 at 16:34.
  4. 20-02-2010, 08:19 #4
    dathoschy
    dathoschy is offline -= TeamSpeak User =-
    Join Date
    Dec 2009
    Location
    Germany
    Posts
    4
    Hi there,

    i've got the same problem with the current beta.

    I tried to update from beta15 to current and i got this:

    Code:
    tsuser@midgard:~/teamspeak3-server_linux-x86$ ./ts3server_startscript.sh start
ts3server.pid found, but no server running. Possibly your previously started server crashed
Please view the logfile for details.
Starting the TeamSpeak 3 server
TeamSpeak 3 server started, for details please view the log file
tsuser@midgard:~/teamspeak3-server_linux-x86$ 2010-02-20 08:08:22.508712|CRITICAL|SQL           |   | unable to remove old log entries
    LogFile:

    Code:
    2010-02-20 08:08:22.491665|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta18 [Build: 10190]
2010-02-20 08:08:22.492109|INFO    |DatabaseQuery |   | dbPlugin name:    SQLite3 plugin, (c)TeamSpeak Systems GmbH
2010-02-20 08:08:22.492219|INFO    |DatabaseQuery |   | dbPlugin version: 3.6.21
2010-02-20 08:08:22.492642|INFO    |DatabaseQuery |   | checking database integrity (may take a while)
2010-02-20 08:08:22.508218|INFO    |SQL           |   | pruning old database log entries where timestamp is older than 90 days
2010-02-20 08:08:22.508543|ERROR   |DatabaseQuery |   | db_exec failed attempt to write a readonly database
2010-02-20 08:08:22.508645|ERROR   |DatabaseQuery |   | db_exec() delete from log where log_timestamp <= 1258877302; error: attempt to write a readonly database
2010-02-20 08:08:22.508712|CRITICAL|SQL           |   | unable to remove old log entries
    I'm wondering why it doesn't use the mysql plugin. Couse if i do:

    Code:
    screen -A -m -d -S tsuser ./ts3server_linux_x86 dbplugin=ts3db_mysql inifile=ts3server.ini
    as root i've got this entry in the logs:

    Code:
    2010-02-20 08:14:58.208389|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta18 [Build: 10190]
2010-02-20 08:14:58.208931|INFO    |DatabaseQuery |   | Please make sure you use the supplied ts3server_minimal_runscript.sh to run the server, or set LD_LIBRARY_PATH yourself
2010-02-20 08:14:58.209039|CRITICAL|DatabaseQuery |   | unable to load database plugin library "libts3db_mysql.so", halting!
    ldd shows this:

    Code:
    ldd libts3db_mysql.so
	linux-gate.so.1 =>  (0xb7f80000)
	libmysqlclient.so.15 => /usr/lib/libmysqlclient.so.15 (0xb7d88000)
	libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0xb7c9a000)
	libm.so.6 => /lib/i686/cmov/libm.so.6 (0xb7c73000)
	libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xb7c66000)
	libc.so.6 => /lib/i686/cmov/libc.so.6 (0xb7b0b000)
	libpthread.so.0 => /lib/i686/cmov/libpthread.so.0 (0xb7af2000)
	libcrypt.so.1 => /lib/i686/cmov/libcrypt.so.1 (0xb7ac0000)
	libnsl.so.1 => /lib/i686/cmov/libnsl.so.1 (0xb7aa7000)
	libz.so.1 => /usr/lib/libz.so.1 (0xb7a91000)
	/lib/ld-linux.so.2 (0xb7f81000)
    and here next:
    Code:
    ldd ts3server_linux_x86
	linux-gate.so.1 =>  (0xb7f85000)
	libdl.so.2 => /lib/i686/cmov/libdl.so.2 (0xb7f78000)
	librt.so.1 => /lib/i686/cmov/librt.so.1 (0xb7f6f000)
	libpthread.so.0 => /lib/i686/cmov/libpthread.so.0 (0xb7f55000)
	libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0xb7e67000)
	libm.so.6 => /lib/i686/cmov/libm.so.6 (0xb7e41000)
	libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xb7e34000)
	libc.so.6 => /lib/i686/cmov/libc.so.6 (0xb7cd9000)
	/lib/ld-linux.so.2 (0xb7f86000)
    I'm running Debian Lenny 32bit with Kernel 2.6.26-2-686

    I make another one try with this ./ts3server_minimal_runscript.sh inifile=ts3server.ini and here is the output

    Code:
    *** glibc detected *** ./ts3server_linux_x86: corrupted double-linked list: 0x0a506ce0 ***
======= Backtrace: =========
/lib/i686/cmov/libc.so.6[0xb7da1624]
/lib/i686/cmov/libc.so.6[0xb7da3573]
/lib/i686/cmov/libc.so.6(cfree+0x96)[0xb7da3826]
/usr/lib/libmysqlclient.so.15(my_no_flags_free+0x21)[0xb7a490a1]
/usr/lib/libmysqlclient.so.15(mysql_close+0xe8)[0xb7a6fe48]
./libts3db_mysql.so(ts3dbplugin_shutdown+0x21)[0xb7bf1a01]
./ts3server_linux_x86[0x8050481]
======= Memory map: ========
08048000-08589000 r-xp 00000000 08:01 565744     /home/jimpanse/teamspeak3-server_linux-x86/ts3server_linux_x86
08589000-0858d000 rw-p 00541000 08:01 565744     /home/jimpanse/teamspeak3-server_linux-x86/ts3server_linux_x86
0858d000-08591000 rw-p 0858d000 00:00 0 
0a4e1000-0a578000 rw-p 0a4e1000 00:00 0          [heap]
b7100000-b7121000 rw-p b7100000 00:00 0 
b7121000-b7200000 ---p b7121000 00:00 0 
b7254000-b7273000 r--p 00000000 08:01 4370605    /usr/share/locale/de/LC_MESSAGES/libc.mo
b7273000-b7274000 ---p b7273000 00:00 0 
b7274000-b7374000 rw-p b7274000 00:00 0 
b7374000-b7375000 ---p b7374000 00:00 0 
b7375000-b7475000 rw-p b7375000 00:00 0 
b7475000-b7476000 ---p b7475000 00:00 0 
b7476000-b7576000 rw-p b7476000 00:00 0 
b7576000-b7577000 ---p b7576000 00:00 0 
b7577000-b7677000 rw-p b7577000 00:00 0 
b7677000-b7678000 ---p b7677000 00:00 0 
b7678000-b7778000 rw-p b7678000 00:00 0 
b7778000-b7788000 r-xp 00000000 08:01 2228278    /lib/i686/cmov/libresolv-2.7.so
b7788000-b778a000 rw-p 0000f000 08:01 2228278    /lib/i686/cmov/libresolv-2.7.so
b778a000-b778c000 rw-p b778a000 00:00 0 
b778c000-b7790000 r-xp 00000000 08:01 2228276    /lib/i686/cmov/libnss_dns-2.7.so
b7790000-b7792000 rw-p 00003000 08:01 2228276    /lib/i686/cmov/libnss_dns-2.7.so
b7792000-b7793000 ---p b7792000 00:00 0 
b7793000-b7893000 rw-p b7793000 00:00 0 
b7893000-b7894000 ---p b7893000 00:00 0 
b7894000-b7994000 rw-p b7894000 00:00 0 
b7994000-b799e000 r-xp 00000000 08:01 2228279    /lib/i686/cmov/libnss_files-2.7.so
b799e000-b79a0000 rw-p 00009000 08:01 2228279    /lib/i686/cmov/libnss_files-2.7.so
b79a0000-b79b4000 r-xp 00000000 08:01 4368669    /usr/lib/libz.so.1.2.3.3
b79b4000-b79b5000 rw-p 00013000 08:01 4368669    /usr/lib/libz.so.1.2.3.3
b79b5000-b79ca000 r-xp 00000000 08:01 2228268    /lib/i686/cmov/libnsl-2.7.so
b79ca000-b79cc000 rw-p 00014000 08:01 2228268    /lib/i686/cmov/libnsl-2.7.so
b79cc000-b79ce000 rw-p b79cc000 00:00 0 
b79ce000-b79d7000 r-xp 00000000 08:01 2228261    /lib/i686/cmov/libcrypt-2.7.so
b79d7000-b79d9000 rw-p 00008000 08:01 2228261    /lib/i686/cmov/libcrypt-2.7.so
b79d9000-b7a00000 rw-p b79d9000 00:00 0 
b7a00000-b7ba4000 r-xp 00000000 08:01 7970932    /usr/lib/libmysqlclient.so.15.0.0
b7ba4000-b7be8000 rw-p 001a3000 08:01 7970932    /usr/lib/libmysqlclient.so.15.0.0
b7be8000-b7be9000 rw-p b7be8000 00:00 0 
b7bf0000-b7bf5000 r-xp 00000000 08:01 565523     /home/jimpanse/teamspeak3-server_linux-x86/libts3db_mysql.so
b7bf5000-b7bf6000 rw-p 00005000 08:01 565523     /home/jimpanse/teamspeak3-server_linux-x86/libts3db_mysql.so
b7bf6000-b7bf7000 rw-p b7bf6000 00:00 0 
b7bf7000-b7d31000 r--p 00000000 08:01 4383679    /usr/lib/locale/locale-archive
b7d31000-b7d33000 rw-p b7d31000 00:00 0 
b7d33000-b7e88000 r-xp 00000000 08:01 2228274    /lib/i686/cmov/libc-2.7.so
b7e88000-b7e89000 r--p 00155000 08:01 2228274    /lib/i686/cmov/libc-2.7.so
b7e89000-b7e8b000 rw-p 00156000 08:01 2228274    /lib/i686/cmov/libc-2.7.so
b7e8b000-b7e8e000 rw-p b7e8b000 00:00 0 
b7e8e000-b7e9a000 r-xp 00000000 08:01 2220035    /lib/libgcc_s.so.1
b7e9a000-b7e9b000 rw-p 0000b000 08:01 2220035    /lib/libgcc_s.so.1
b7e9b000-b7ebf000 r-xp 00000000 08:01 2228257    /lib/i686/cmov/libm-2.7.so
b7ebf000-b7ec1000 rw-p 00023000 08:01 2228257    /lib/i686/cmov/libm-2.7.so
b7ec1000-b7fa4000 r-xp 00000000 08:01 4366847    /usr/lib/libstdc++.so.6.0.10
b7fa4000-b7fa7000 r--p 000e2000 08:01 4366847    /usr/lib/libstdc++.so.6.0.10
b7fa7000-b7fa9000 rw-p 000e5000 08:01 4366847    /usr/lib/libstdc++.so.6.0.10
b7fa9000-b7faf000 rw-p b7fa9000 00:00 0 
b7faf000-b7fc4000 r-xp 00000000 08:01 2228266    /lib/i686/cmov/libpthread-2.7.so
b7fc4000-b7fc6000 rw-p 00014000 08:01 2228266    /lib/i686/cmov/libpthread-2.7.so
b7fc6000-b7fc9000 rw-p b7fc6000 00:00 0 
b7fc9000-b7fd0000 r-xp 00000000 08:01 2228277    /lib/i686/cmov/librt-2.7.so
b7fd0000-b7fd2000 rw-p 00006000 08:01 2228277    /lib/i686/cmov/librt-2.7.so
b7fd2000-b7fd4000 r-xp 00000000 08:01 2228271    /lib/i686/cmov/libdl-2.7.so
b7fd4000-b7fd6000 rw-p 00001000 08:01 2228271    /lib/i686/cmov/libdl-2.7.so
b7fd6000-b7fdd000 r--s 00000000 08:01 4366342    /usr/lib/gconv/gconv-modules.cache
b7fdd000-b7fdf000 rw-p b7fdd000 00:00 0 
b7fdf000-b7fe0000 r-xp b7fdf000 00:00 0          [vdso]
b7fe0000-b7ffa000 r-xp 00000000 08:01 2221704    /lib/ld-2.7.so
b7ffa000-b7ffc000 rw-p 0001a000 08:01 2221704    /lib/ld-2.7.so
bfb86000-bfb9b000 rw-p bffeb000 00:00 0          [stack]
./ts3server_minimal_runscript.sh: line 9:  7181 Abgebrochen             ./ts3server_linux_x86 $@
    Last edited by dathoschy; 20-02-2010 at 08:43. Reason: Nachtrag
  5. 20-02-2010, 15:39 #5
    Peter
    Peter is offline -= TeamSpeak Team =-
    Join Date
    Jul 2002
    Location
    Germany
    Posts
    2,836
    dathoschy: You are totally off-topic here, your problem is very different from the thread starters problem, please make a separate thread.
    You think my answer is stupid ? Read This:
    http://www.catb.org/~esr/faqs/smart-...ons.html#intro

    In a world without fences and walls - who needs windows and gates ?
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Instructions to set up TeamSpeak 2.0 client and server
    By {nUg}DankRider in forum [TeamSpeak 2] Server Support
    Replies: 496
    Last Post: 05-06-2010, 07:57
  2. Server Issue's When PC Reboots
    By gokub27 in forum [TeamSpeak 2] Client Support
    Replies: 3
    Last Post: 14-09-2006, 21:32
  3. I cant clik administration after TS restart
    By Schirmer in forum [TeamSpeak 2] Server Support
    Replies: 9
    Last Post: 13-06-2003, 04:20
  4. TS server and wn 98 probs ?
    By ghboom in forum [TeamSpeak 2] Server Support
    Replies: 0
    Last Post: 30-05-2003, 06:05
  5. Scheisse habe QDSL alles geht nur keine REG
    By Creeper in forum [TeamSpeak 2] Server Support
    Replies: 6
    Last Post: 29-08-2002, 09:06

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules