Mac OS X Server 10.6.2 - MySQL Problem

[tmm4264]

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:

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:

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:

[config]
host=localhost
port=3306
username=teamspeak
password=*******
database=teamspeak
socket=

The server directory looks like this:

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 -rw-r--r--@   1 serveradmin  staff      6148 Feb 27 15:23 .DS_Store
   32 -rwxrwxrwx@   1 serveradmin  staff     14710 Feb  8 10:54 changelog.txt
    0 drwxrwxrwx@   6 serveradmin  staff       204 Feb  8 10:54 doc
    0 drwxrwxrwx+   3 serveradmin  staff       102 Feb  5 20:55 files
  240 -rwxrwxrwx@   1 serveradmin  staff    120232 Feb  8 10:54 libts3db_mysql.dylib
 3384 -rwxrwxrwx@   1 serveradmin  staff   1731320 Feb  8 10:54 libts3db_sqlite3.dylib
   48 -rwxrwxrwx@   1 serveradmin  staff     24099 Feb  8 10:54 license.txt
    8 -rwxrwxrwx@   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 drwxrwxrwx@ 119 serveradmin  staff      4046 Feb  8 10:54 serverquerydocs
    0 drwxrwxrwx@  92 serveradmin  staff      3128 Feb 27 15:18 sql
    8 -rwxrwxrwx@   1 serveradmin  staff        97 Feb 27 16:17 ts3db_mysql.ini
    8 -rw-r--r--@   1 serveradmin  staff       281 Feb 27 15:59 ts3server.ini
  368 -rwxrwxrwx+   1 serveradmin  staff    187392 Feb 27 16:10 ts3server.sqlitedb
21776 -rwxrwxrwx@   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?

[hanzo]

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?

[Redasurc]

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!

[tmm4264]

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.

[tmm4264]

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.

[-FN-]

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.

[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.

[tmm4264]

Can you post the output from Terminal?

[-FN-]

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...

[Peter]

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

[tmm4264]

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?

[Peter]

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.

[tmm4264]

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.

[kneissl]

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