Forum

Results 1 to 5 of 5
  1. #1
    Join Date
    February 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:
    [email protected]:/opt/TS3$ export LD_LIBRARY_PATH=".:$LD_LIBRARY_PATH"
    [email protected]:/opt/TS3$ echo $LD_LIBRARY_PATH
    .:
    [email protected]:/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:
    [email protected]:/opt/TS3$ export LD_LIBRARY_PATH=".:$LD_LIBRARY_PATH"
    [email protected]:/opt/TS3$ echo $LD_LIBRARY_PATH
    .:.:
    [email protected]:/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:
    [email protected]:/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:
    [email protected]:/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:
    [email protected]:/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:
    [email protected]:/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; February 20th, 2010 at 03:40 PM.

  2. #2
    Join Date
    July 2002
    Location
    Germany
    Posts
    2,192
    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. #3
    Join Date
    February 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; February 19th, 2010 at 04:34 PM.

  4. #4
    Join Date
    December 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:
    [email protected]:~/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
    [email protected]:~/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 [email protected]
    Last edited by dathoschy; February 20th, 2010 at 08:43 AM. Reason: Nachtrag

  5. #5
    Join Date
    July 2002
    Location
    Germany
    Posts
    2,192
    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 ?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. unable to load database plugin library, halting!
    By jeremyr in forum Linux / FreeBSD
    Replies: 16
    Last Post: July 27th, 2012, 11:50 AM
  2. Replies: 1
    Last Post: June 12th, 2011, 10:24 PM
  3. WIN XP. unable to load database plugin library
    By bailenforcer in forum Windows
    Replies: 4
    Last Post: April 8th, 2011, 01:51 PM
  4. [Solved] Problem: Unable to load database mysql
    By Xumari in forum Linux / FreeBSD
    Replies: 4
    Last Post: July 9th, 2010, 03:58 PM
  5. Replies: 3
    Last Post: February 5th, 2010, 05:54 AM

Posting Permissions

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