TeamSpeak 2.x with MySQL 5.x (Tutorial)

[AB2314]

I get every time username/passwort.... I think there is not really a connection to mysql... I tried without pass and the same error... anybody a idea?

Swen

[sy5tem]

with Fedora Core 6 all you have to do when you get the cannot find lib ... you get

MySQL-shared-compat-4.1.22-0.i386.rpm from mysql web site. once installed using full path it work with :
mysql Ver 14.12 Distrib 5.0.27, for redhat-linux-gnu (i686) using readline 5.0
================================================== ========
[DBEXPRESS]
sqldir=/usr/bin/tss2_rc2/mysql_sql/
Drivername=mysql
Database=ts_domainname_com
Hostname=127.0.0.1
User_name=ts_linux
Password=long-ass-password
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/libmysqlclient_r.so.10.0.0
LibraryName=/usr/bin/tss2_rc2/libsqlmy.so
Active=1
================================================== ========

no problem for now.

[DaFox]

I get every time username/passwort.... I think there is not really a connection to mysql... I tried without pass and the same error... anybody a idea?

Swen

1. Has your mysql server networking enabled? Check your /etc/mysql/my.cnf and comment out the line "skip-networking".

2. You have to use old passwords, since the authentication mechanism within mysql changed. Connect to the database as root-user and type the following:

SET PASSWORD FOR '<your-ts-db-user>'@'localhost' = OLD_PASSWORD('<your-ts-db-pass>')

3. Does your teamspeak-server connect to "127.0.0.1" instead of "localhost"? If your database server supports sockets, you have to use the ip address of the loopback device (127.0.0.1) instead of the hostname (localhost) to prevent the teamspeak-server from using the unix socket.

server.ini example:

sqldir=mysql_sql/
Drivername=mysql
Database=teamspeak
Hostname=127.0.0.1
User_name=teamspeak
Password=xxxxxx
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/libmysqlclient_r.so.10
LibraryName=./libsqlmy.so
Active=1

Note: The property "User_name" is correct, don't use "Username" (without the underscore) here as told elsewhere in this forum, it won't work.

[Bloody-wave]

Hello,

I'm on debian (last version updated)

My server don't work on mysql and i don't find why.

[DBEXPRESS]
sqldir=home/teamspeak/serv/mysql_sql
Drivername=mysql
Database=teamspeak
Hostname=127.0.0.1
User_name=my_username
Password=my_password
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/libmysqlclient_r.so.15.0.0
LibraryName=./libsqlmy.so
Active=1

07-04-08 14:40:57,ALL,Info,server, Server init initialized
07-04-08 14:40:57,ALL,Info,server, Server version: 2.0.24.1 Linux
07-04-08 14:40:57,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load /usr/lib/libmysqlclient_r.so.15.0.0
07-04-08 14:40:57,ERROR,All,SERVER, Start_Server: unable to open database

I've tested with many configuration, but it don't work, here's the differently configuration i've used:

VendorLib=/usr/lib/libmysqlclient_r.so.15.0.0
VendorLib=/usr/lib/libmysqlclient_r.so.15
VendorLib=/usr/lib/libmysqlclient.so.15.0.0
VendorLib=/usr/lib/libmysqlclient.so.15
VendorLib=./libmysqlclient_r.so.15.0.0
VendorLib=./libmysqlclient.so.15.0.0

If anybody have solution for me it's very cool, my test server on windows is on mysql and it work perfectly at the first time, i don't understand why it doesn't work on linux

thx in advance

[ckx3009]

you should obtain necessary libs. you can do this in the following way:
go to that link and download the .rpm file. so now you should open that file.
if you are under linux (i'll hope), you should install a program called alien (available, i know, for gentoo and debian; probably also for other distros).
by command line type

alien -t /YOURPATH/MySQL-shared-compat-4.1.9-0.i386.rpm

with the -t option, you will make a .tgz file from the .rpm file.
now in your .tgz (you can open it with some archive managers) there will be the necessary libs: libmysqlclient_r.so.10 is the one who interest you




doing that i've obtained a starting and running server on my gentoo, using a mysql 5.0 database..but now i've a problem:
from server.log:
when i try to use webadmin interface from superadmin managing permissions that message is shown:

,ERROR,All,WEBINTERFACE,       SetVariables Exception: EInvalidField.field b_sp_AdminEditServerWelcomeMessage not found

and in the permissions sections of the webadmin, all values are shown like "%!SERVERCFG_GROUP_PERMISSIONS_SA!%" (as in their htmls).
if i restart server, every time, it is shown that message:

,ERROR,All,SERVER,     VirtualServer Startup(1) Exception: EInvalidField.field b_sp_AdminEditServerWelcomeMessage not found

so i'm unable to manage my server...
an other user had my same problem, but the replies to his post are not useful for me..
so can someone help me?

[Bloody-wave]

i have the same problem :s

if you have this error


EInvalidField.field b_sp_AdminEditServerWelcomeMessage not found
Edit the table and change the type tyint to int and the value 1 to 11

for the moment my problem is solved, i work on it

I confirm, problem solved

Now i have a new question, how i can update my server.dbs on mysql table?

[dani1988]

dear helpers!

[DBEXPRESS]
sqldir=mysql_sql\
Drivername=mysql
Database=test
Hostname=localhost
User_name=team
Password=****
GetDriverFunc=getSQLDriverMYSQL
VendorLib=libmysql.dll
LibraryName=dbexpmysql.dll
Active=1

----------
29-05-08 22:49:37,ALL,Info,server, Server init initialized
29-05-08 22:49:37,ALL,Info,server, Server version: 2.0.24.1 Win32
29-05-08 22:49:37,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load libmysql.dll
29-05-08 22:49:37,ERROR,All,SERVER, Start_Server: unable to open database
29-05-08 22:49:37,ERROR,All,GENERAL, critical error, shutdown initiated


------

mysql ver: 5.0.45

what is the problem(s)?

[Elbandi]

TS server is not working with mysql 5 library, because libsqlmy.so want a function (called mysql_connect) which isnt exists in 5.x library:

# grep mysql_connect /usr/lib/libmysqlclient_r.so.10
Binary file /usr/lib/libmysqlclient_r.so.10 matches
# grep mysql_connect /usr/lib/libmysqlclient_r.so.15
#

I added the missing function to mysql 5 source:

MYSQL*  STDCALL mysql_connect(MYSQL *mysql, const char *host, const char *user, const char *passwd)
{
    return NULL;
}

After recompile and install:

# grep mysql_connect /usr/lib/libmysqlclient_r.so.15
Binary file /usr/lib/libmysqlclient_r.so.15 matches
#

I write a little mysql wrapper. With this, i can "monitor" the mysql calls.
Run ts2 server with mysql 3.x library working good:
http://pastebin.com/f4004fa0a

Run ts2 server with mysql 5.x library still not working:
http://pastebin.com/f6872c01e

Watch out to: own_mysql_real_query called:SHOW TABLES.
TS dont call own_mysql_fetch_row to get the showtable result! Why?

(Ubuntu Hardy)

[AB2314]

03-06-08 19:00:06,ALL,Info,server, Server init initialized
03-06-08 19:00:06,ALL,Info,server, Server version: 2.0.20.1 Linux
03-06-08 19:00:06,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load /usr/lib/libmysqlclient_r.so.10.0.0
03-06-08 19:00:06,ERROR,All,SERVER, Start_Server: unable to open database

But the file is exist in folder... Any ideas?

[FoolyCooly]

all I can say is:

Please document this better.


edit: after reflection, I can also say:

Linux isn't that hard to understand, and developing for it is almost as hard. So please, help a "brotha" out and begin the love for mysql on linux!!!

[FoolyCooly]

further elaboration:

if one searches for "libmysqlclient_r.so.10.0.0" with google.com, the first result is:

libmysqlclient_r.so.10.0.0 - TeamSpeak Community Forums


??????


within the thread there's a statement further explaining the lack of regard for this demand for "support":

Why wont people give these things away as a comunity

It's hard to see a leg snap on a titanium-alloy reinforced bench, wtf is going on here??????

[FoolyCooly]

some MAJOR problems with the release of both the binary and "non existant" documentation:



1) wont work if you use relative path names in the settings file
2) binary distribution does not contain REQUIRED sql files in the mysql_sql folder
3) Not sure, but I belive if you try to use (any) release other than 10.0.0 of the client library, then you're in a world of hurt.
4) SET PASSWORD FOR '%%%%%%%%%%'@'%%%%%%%%' = OLD_PASSWORD( '%%%%%%%%%%%%%%%%%%' ) OR DIEEEEEEEE
5) Impossible to administer server unless stock sql files edited before install: http://forum.teamspeak.com/showthrea...849#post179849

WTF people!!!!!!!!

[sgtbenc]

It seems that most of the scripts in the mysql_sql directory are missing. We supposed to rewrite those for MySQL? Anyone else written them? No sense in reinventing the wheel.

[sgtbenc]

Ok, so they are all on the FTP: ftp://ftp.freenet.de/pub/4players/te...2401/mysql_sql For some reason, they were left out of Windows and Linux server downloads.

Rather than you having to copy all the text and save it to individual files, I thought I'd zip and tar them for you. See attached files.

EDIT:

delete_channel_privileges.sql

in my zip and tar should be

delete_channel_privilege.sql

[karimali831]

Anyone know where I can get libmysqlclient_r.so.10.0.0 as the server won't allow libmysqlclient_r.so.15.0.0?