Forum

Results 1 to 13 of 13
  1. #1
    Join Date
    February 2008
    Location
    NYC
    Posts
    35

    Mac OS X Server 10.6.2 - MySQL Problem

    I am trying to get TS3 to use the MySQL server that is included with Mac OS X Server 10.6.2. However, I cannot get the TS3 plugin to load. Here is the output from the Terminal:

    Code:
    Last login: Sat Feb 27 16:07:47 on console
    ns:~ serveradmin$ cd ~/desktop
    ns:desktop serveradmin$ cd teamspeak3-server_mac
    ns:teamspeak3-server_mac serveradmin$ ./ts3server_mac inifile=ts3server.iniTeamSpeak Server 3.0.0-beta18 [Build: 10190]
    (c)TeamSpeak Systems GmbH
    
    Logging started
    2010-02-27 21:09:14.828919|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta18 [Build: 10190]
    2010-02-27 21:09:14.911549|INFO    |DatabaseQuery |   | dbPlugin name:    SQLite3 plugin, (c)TeamSpeak Systems GmbH
    2010-02-27 21:09:14.925723|INFO    |DatabaseQuery |   | dbPlugin version: 3.6.21
    2010-02-27 21:09:14.947075|INFO    |DatabaseQuery |   | checking database integrity (may take a while)
    2010-02-27 21:09:15.009158|INFO    |SQL           |   | pruning old database log entries where timestamp is older than 90 days
    2010-02-27 21:09:16.375815|INFO    |Accounting    |   | Licensing Information
    2010-02-27 21:09:16.377357|INFO    |Accounting    |   | type              : Non-profit
    2010-02-27 21:09:16.378668|INFO    |Accounting    |   | starting date     : Thu Feb  4 18:00:00 2010
    2010-02-27 21:09:16.379726|INFO    |Accounting    |   | ending date       : Fri Feb  4 18:00:00 2011
    2010-02-27 21:09:16.380763|INFO    |Accounting    |   | max virtualservers: 10
    2010-02-27 21:09:16.381760|INFO    |Accounting    |   | max slots         : 512
    2010-02-27 21:09:16.418797|INFO    |FileManager   |   | listening on 0.0.0.0:30033
    2010-02-27 21:09:16.530956|INFO    |VirtualServer |  1| listening on 0.0.0.0:9987
    2010-02-27 21:09:16.552500|INFO    |Query         |   | whitelist ips: 127.0.0.1, 
    2010-02-27 21:09:16.558206|INFO    |Query         |   | listening on 0.0.0.0:10011
    ^C2010-02-27 21:10:20.813746|INFO    |ServerMain    |   | Received signal SIGINT, shutting down.
    2010-02-27 21:10:20.960279|INFO    |VirtualServer |  1| stopped
    ns:teamspeak3-server_mac serveradmin$ ./ts3server_mac dbplugin=ts3db_mysql dbsqlcreatepath=create_mysql/
    TeamSpeak Server 3.0.0-beta18 [Build: 10190]
    (c)TeamSpeak Systems GmbH
    
    Logging started
    2010-02-27 21:10:45.737953|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta18 [Build: 10190]
    2010-02-27 21:10:45.819958|CRITICAL|DatabaseQuery |   | unable to load database plugin library "libts3db_mysql.dylib", halting!
    ns:teamspeak3-server_mac serveradmin$ ./ts3server_mac inifile=ts3server.ini
    TeamSpeak Server 3.0.0-beta18 [Build: 10190]
    (c)TeamSpeak Systems GmbH
    
    Logging started
    2010-02-27 21:11:22.806177|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta18 [Build: 10190]
    2010-02-27 21:11:22.806792|CRITICAL|DatabaseQuery |   | unable to load database plugin library "libts3db_mysql.dylib", halting!
    ns:teamspeak3-server_mac serveradmin$
    My ts3server.ini file looks like this:

    Code:
    machine_id=
    default_voice_port=9987
    voice_ip=0.0.0.0
    liscensepath=
    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/
    logpath=logs
    logquerycommands=1
    and my ts3db_mysql.ini file looks like this:

    Code:
    [config]
    host=localhost
    port=3306
    username=teamspeak
    password=*******
    database=teamspeak
    socket=
    The server directory looks like this:

    Code:
    ns:teamspeak3-server_mac serveradmin$ ls -las
    total 25904
        0 drwxr-xr-x+  19 serveradmin  staff       646 Feb 27 16:11 .
        0 drwx------+   9 serveradmin  staff       306 Feb 27 15:43 ..
       16 [email protected]   1 serveradmin  staff      6148 Feb 27 15:23 .DS_Store
       32 [email protected]   1 serveradmin  staff     14710 Feb  8 10:54 changelog.txt
        0 [email protected]   6 serveradmin  staff       204 Feb  8 10:54 doc
        0 drwxrwxrwx+   3 serveradmin  staff       102 Feb  5 20:55 files
      240 [email protected]   1 serveradmin  staff    120232 Feb  8 10:54 libts3db_mysql.dylib
     3384 [email protected]   1 serveradmin  staff   1731320 Feb  8 10:54 libts3db_sqlite3.dylib
       48 [email protected]   1 serveradmin  staff     24099 Feb  8 10:54 license.txt
        8 [email protected]   1 serveradmin  staff       896 Feb 10 09:20 licensekey.dat
        0 drwxrwxrwx+  20 serveradmin  staff       680 Feb 27 16:17 logs
        8 -rwxrwxrwx+   1 serveradmin  staff        10 Feb  5 20:55 query_ip_whitelist.txt
        8 -rwxrwxrwx+   1 serveradmin  staff       112 Feb 10 09:52 serverkey.dat
        0 [email protected] 119 serveradmin  staff      4046 Feb  8 10:54 serverquerydocs
        0 [email protected]  92 serveradmin  staff      3128 Feb 27 15:18 sql
        8 [email protected]   1 serveradmin  staff        97 Feb 27 16:17 ts3db_mysql.ini
        8 [email protected]   1 serveradmin  staff       281 Feb 27 15:59 ts3server.ini
      368 -rwxrwxrwx+   1 serveradmin  staff    187392 Feb 27 16:10 ts3server.sqlitedb
    21776 [email protected]   1 serveradmin  staff  11145868 Feb  8 10:54 ts3server_mac
    ns:teamspeak3-server_mac serveradmin$
    I have no idea why the database plug-in won't load. I've gone through all of the Linux forums to see if I could learn anything new, but none of those solutions have helped.

    Any ideas?

  2. #2
    Join Date
    March 2010
    Location
    Pennsylvania
    Posts
    1
    I have nothing to add to this except for a "me too".

    I am using the latest Beta server on a Snow Leopard 10.6.2 system.

    FWIW- I notice that the mysql library is significantly smaller than the SQLite lib..possible this is broken during the build process, or maybe just not fully implemented?

  3. #3
    Join Date
    December 2009
    Location
    Austria
    Posts
    12

    me too

    Same for me!
    I have Mac osX Snow Leopard 10.6.2 and use a MySQL database based on MAMP. Don't know whats the problem with ts3 because everything else is working fine!

  4. #4
    Join Date
    February 2008
    Location
    NYC
    Posts
    35
    I've been trying to get the library to load. I am assuming that it's not implemented or it's broken. I cannot get a log generated from it with any additional detail.

  5. #5
    Join Date
    February 2008
    Location
    NYC
    Posts
    35
    I have tried to reach out for support via this forum and IRC, however, there doesn't seem to be any.

    At this juncture I will assume that TS Server on Mac OS X Server is not supported and is not being actively developed. The support for TS on this platform is non-existant.

  6. #6
    Join Date
    September 2004
    Location
    Pennsylvania
    Posts
    13
    Ok, I'm confused...

    I had TS running on an OS X 10.5 Server perfectly fine for over a month. I had to reinstall the OS for other reasons and when I had this clean install setup, I copied over my ts3 directory and now... after weeks of it working fine, I now have this error.

    I've tried every permission trick I can think of. The server will start with the sqlite3 plugin just fine, but not mysql. The output also says my license file is not valid when it was just yesterday...

    Any ideas?

    Update:

    I've tested the login info for the MySQL database, it works fine.
    Code:
    [config]
    host=localhost
    port=3306
    username=ts3
    password=******
    database=ts3
    socket=/path/to/mysql.sock
    The password and socket obviously are different, I'm sure they're right.

    Like I said, it was just working yesterday... so this is turning out to be VERY frustrating.
    Last edited by -FN-; May 18th, 2010 at 09:22 PM.

  7. #7
    Join Date
    February 2008
    Location
    NYC
    Posts
    35
    Can you post the output from Terminal?

  8. #8
    Join Date
    September 2004
    Location
    Pennsylvania
    Posts
    13
    Code:
    server:ts3 admin$ cd /var/ts3/
    server:ts3 admin$ ./ts3server_mac dbplugin=ts3db_mysql
    TeamSpeak Server 3.0.0-beta21 [Build: 10608]
    (c)TeamSpeak Systems GmbH
    
    Logging started
    2010-05-18 20:23:01.708867|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta21 [Build: 10608], MacOSX
    2010-05-18 20:23:01.709461|CRITICAL|DatabaseQuery |   | unable to load database plugin library "libts3db_mysql.dylib", halting!
    server:ts3 admin$
    Nice and useless I know there is a beta22 and I've tried that, no luck. Like I said, this install was working yesterday...

  9. #9
    Join Date
    July 2002
    Location
    Germany
    Posts
    2,192
    Hello,

    to have mysql support you *require* the libmysqlclient library installed on your system, please use the ldd equivalent on Mac OS X to make sure this library is available (I faintly recall "otool"?). Also note there are not many good reasons to use the mysql backend instead of sqlite (sqlite is faster and easier to set up), so unless for some obscure reason you *need* the server data to be backed in a mysql database you can save yourself some trouble
    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 ?

  10. #10
    Join Date
    February 2008
    Location
    NYC
    Posts
    35
    Quote Originally Posted by Peter View Post
    Hello,

    to have mysql support you *require* the libmysqlclient library installed on your system, please use the ldd equivalent on Mac OS X to make sure this library is available (I faintly recall "otool"?). Also note there are not many good reasons to use the mysql backend instead of sqlite (sqlite is faster and easier to set up), so unless for some obscure reason you *need* the server data to be backed in a mysql database you can save yourself some trouble
    Huh? I thought there was marketing material talking about how great it was to now have MySQL support built in.

    Are you recommending not using MySQL at all on any platform?

  11. #11
    Join Date
    July 2002
    Location
    Germany
    Posts
    2,192
    Quote Originally Posted by tmm4264 View Post
    Huh? I thought there was marketing material talking about how great it was to now have MySQL support built in.

    Are you recommending not using MySQL at all on any platform?
    I am saying use mysql only when you have a good reason to do so, sqlite is the default for multiple reasons . Sure our mysql support is great, but so is our sqlite support and sqlite is, for datasets below millions of entries (read: all ts3 server uses), just faster AND for ts3 it works out of the box. For >= 99% of all users sqlite is the way to go, the 1% either wants to take advantage of mysql backup scripts already in place or wants to integrate their ts3 data with already existing data that is in a mysql database or just feels much more comfortable with a mysql setup.
    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 ?

  12. #12
    Join Date
    February 2008
    Location
    NYC
    Posts
    35
    I'd love to get MySQL working on Mac OS Server 10.6.4, but I haven't gotten any "official" response from anyone regarding the issues I've been experiencing.

    Right now I am testing it locally, but I would prefer to use a MySQL database to integrate it into a bulletin board system and associate accounts on one system to the other.

    For example, I can put a TsUser field into the BBS and ask the registered users to enter in their TS username. I can then do a lookup in the MySQL database and see if there is a match.

    The attractiveness of using MySQL allows me to integrate TS into different products or solutions using that database. It's not so easy to do that with MySQLite.

  13. #13
    Join Date
    June 2011
    Posts
    1
    I fixed my problem using the otool suggested above
    i ran this...
    teamspeak3-server_mac Kneissl$ otool -L libts3db_mysql.dylib
    libts3db_mysql.dylib:
    libts3db_mysql.dylib (compatibility version 0.0.0, current version 0.0.0)
    /usr/local/mysql/lib/libmysqlclient.16.dylib (compatibility version 17.0.0, current version 17.0.0)
    /usr/lib/libstdc++.6.dylib (compatibility version 7.0.0, current version 7.4.0)
    /usr/lib/libgcc_s.1.dylib (compatibility version 1.0.0, current version 1.0.0)
    /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 111.0.0)

    under /usr/local/mysql/lib/libmysqlclient.16.dylib

    i noticed that the only similar file in the directory was libmysqlclient.18.dylib

    so i make a symlink in /usr/local/mysql/lib:

    sudo ln libmysqlclient.18.dylib libmysqlclient.16.dylib

    started the server and all is well!
    hope that helps anyone

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [Resolved] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
    By Svenskunganka in forum Server Support
    Replies: 2
    Last Post: September 12th, 2013, 10:59 PM
  2. Problem with MYSQl and Teamspeak Server
    By huskyone in forum Tools / Web Based
    Replies: 2
    Last Post: October 28th, 2011, 02:03 PM

Posting Permissions

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