TeamSpeak 2.x with MySQL 5.x (Tutorial) [Archive]

IceMatrix

13-11-2005, 14:58

Hi all,
I'm running SUSE 9.3 with MySQL 5.0 on my server. I installed the TeamSpeak 2 server and configured it the way the README file told me to do. But there was just one problem:
The server didn't start and there was this line in the server.log:
Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password.

After I removed the password of the TeamSpeak MySQL user account everything worked well, but that can't be satisfactory because everyone having access to the php web space would be able to access the teamspeak database.

I searched the internet and found out that there was a change of the password hashing process (MySQL 4.1 and later).
So I had a look at the MySQL manual (http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html), and there I found the solution:
Don't set the password for the TeamSpeak user using the MySQL command line client or phpMyAdmin. You have to set it using this SQL command:
SET PASSWORD FOR '<mysqluser>'@'<host>' = OLD_PASSWORD('<password>');

You can easily enter this command using phpMyAdmin or the MySQL command line client.

Now everything works fine!

McAfee

13-11-2005, 17:46

I tried using MySQL 5.0.15 shortly after my post and TS2 worked when using short passwords. I basicly made a custom mysqldump of the "MySQL" database and later cleared most entries on the default one and inserted my grants. This saves me from having to modify columns. I just copied the rest of the databases.

But MySQL was crashing after a while for unknown reasons. I found that specific problem was not TS related. I couldn't find what was causing the crash. Maybe it was PHP, but I don't understand how client apps can crash the server itself. That would be a security flaw, IMO. Maybe I shouldn't just have "copied" the rest of the databases. And just dumped and re-create ALL of them.

So I decided to test MySQL 4.1.15 while I was at it. Sounded like a good idea to upgrade to 4.1 for a while and then go 5.0, but this time TS2 didn't work. I used the same password scheme as with 5.0, but there was no Go. The client library just doesn't like 4.1.x

Note that the error I get is not invalid username/password. It's operation Not supported. So there seems to be more incompatibility problems than the authentification.

I might re-visit MySQL 5.0.x again, this time I will just dump everthing and re-create everything again.

EDIT:
My older post on this thread:
http://forum.goteamspeak.com/showthread.php?t=27009

McAfee

13-11-2005, 18:47

Using the dump seemed to do the trick. I get no more crashes. I should have known better not to just "copy" the databases over. That might work for small revisions but not major revisions.

I'll now continue explaining how I proceeded to dump and re-create my databases. You can get more info on mysqldump here:
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

I used a standard dump for all databases, except MySQL. You could just dump each one indivudually, or use the --databases option. Since my "mysql" database is small, I just dumped all of them at the same time, and removed that section from the results.

For the "mysql" I used a new custom dump, basicly I added these options:
--complete-insert, -c (includes column names)
--no-create-db, -n (not required as we will use the provided database)
--no-create-info, -t (not required as we will use the provided tables)

Please note that I'm on windows, but most tips should apply to linux. Here's the statement I used:
mysqldump.exe --user=root -p -c -n -t mysql > DUMP.sql

It's a good idea to revise both of your dump files before proceeding. The mysql one should only contain insert statements. You may remove the insert releated to the root account, but no harm is done if left there.

I continued by removing the system service and renaming the mysql folder for backup purposes. Installed MySQL 5.0.15 (ZIP Install, manual), and re-installed the system service. Then started the service.

Up to this point I have a default installation of MySQL 5. Next I removed the sample "test" database, and the related grants on the mysql.db table. Now I was ready to reinsert everthing.

I started with the dump of the rest of my databases (called dump2.sql). I just opened the mysql command line client with the default root account and used:
source dump2.sql

That took a LONG time, after that I did the same for the mysql database:
source dump.sql

You will get 1 error about the root account already existing (if you didnt remove the line before), but no harm is done. Now you should reload the privileges from the grant tables in the mysql database with:
FLUSH PRIVILEGES

Finally, I suggest stopping and restarting the service. Everthing should work as normal. But you are not done. Some security measures need to be taken.

You root account still has the default blank password. You may also proceed to update other user accounts, as long as the client libraries they use can support the new password scheme:
http://dev.mysql.com/doc/refman/5.0/en/set-password.html

DanDriff

10-03-2006, 17:25

this didn't work for me at all....my post is @ http://forum.goteamspeak.com/showthread.php?t=27200

still stumped :/

Rashnu

22-05-2006, 18:26

Well i'm half way there i set the password scheme to the old on my sql 5 server but now im getting a new error just says dbexpress Error:Operation not supported . when i try to load the server. soo any help woul be greatly appreciated...

Nom4d3_

13-06-2006, 15:57

link for libs please?

:D

madaut

21-08-2006, 12:28

I get this error message:

21-08-06 12:01:40,ALL,Info,server, Server init initialized
21-08-06 12:01:40,ALL,Info,server, Server version: 2.0.20.1 Linux
21-08-06 12:01:40,ERROR,All,SQL, Database initialization error: EDatabaseError.DLL/Shared Library Name not Set
21-08-06 12:01:40,ERROR,All,SERVER, Start_Server: unable to open database

looks like I have missed a line in my server.ini but I think that all needed is in
the libmysqlclient_r.so.10.0.0 file is in the right directory

[DBEXPRESS]
sqldir=/opt/teamspeak2-server/mysql_sql/
Drivername=mysql
Database=teamspeak
Hostname=localhost
User_name=dontTellYa
Password=**************
GetDriverFunc=getSQLDriverMYSQL
VendorLib=./libmysqlclient_r.so.10.0.0
LibaryName=./libsqlmy.so
Active=1

yahooadam

26-08-2006, 04:03

yahooadam

26-08-2006, 21:20

link for libs please?
this would be useful, i cant even get past making it start

---------------------------------------------------------------
-------------- log started at 26-08-06 20:01 -------------
---------------------------------------------------------------
26-08-06 20:01:06,ALL,Info,server, Server init initialized
26-08-06 20:01:06,ALL,Info,server, Server version: 2.0.20.1 Linux
26-08-06 20:01:06,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load /usr/lib/mysql/libmysqlclient_r.so.15.0.0
26-08-06 20:01:06,ERROR,All,SERVER, Start_Server: unable to open database
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 26-08-06 20:01 --------------
---------------------------------------------------------------
---------------------------------------------------------------
-------------- log started at 26-08-06 20:02 -------------
---------------------------------------------------------------
26-08-06 20:02:12,ALL,Info,server, Server init initialized
26-08-06 20:02:12,ALL,Info,server, Server version: 2.0.20.1 Linux
26-08-06 20:02:12,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load /usr/lib/mysql/libmysqlclient_r.so
26-08-06 20:02:12,ERROR,All,SERVER, Start_Server: unable to open database
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 26-08-06 20:02 --------------
---------------------------------------------------------------
---------------------------------------------------------------
-------------- log started at 26-08-06 20:12 -------------
---------------------------------------------------------------
26-08-06 20:12:42,ALL,Info,server, Server init initialized
26-08-06 20:12:42,ALL,Info,server, Server version: 2.0.20.1 Linux
26-08-06 20:12:42,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load /usr/lib/libmysqlclient_r.a
26-08-06 20:12:42,ERROR,All,SERVER, Start_Server: unable to open database
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 26-08-06 20:12 --------------
---------------------------------------------------------------
This isn't even a tutorial FFS, it doesn't explain HOW to set up TS2 on Mysql 5.x

Just about how much success someone had

orphan

08-09-2006, 17:29

ThorGoLucky

10-09-2006, 03:51

I'm getting a similar error under CentOS 4.4 64-bit with MySQL 4.1. I tried orphan's suggestion but still get an error when trying to start. By the way, my TeamSpeak works fine on my old Fedora Core 3 64-bit server with mysql 3.x.

---------------------------------------------------------------
-------------- log started at 09-09-06 18:38 -------------
---------------------------------------------------------------
09-09-06 18:38:01,ALL,Info,server, Server init initialized
09-09-06 18:38:01,ALL,Info,server, Server version: 2.0.20.1 Linux
09-09-06 18:38:01,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load /usr/lib64/mysql/libmysqlclient_r.so.10.0.0
09-09-06 18:38:01,ERROR,All,SERVER, Start_Server: unable to open database
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 09-09-06 18:38 --------------
---------------------------------------------------------------
---------------------------------------------------------------
-------------- log started at 09-09-06 18:46 -------------
---------------------------------------------------------------
09-09-06 18:46:29,ALL,Info,server, Server init initialized
09-09-06 18:46:29,ALL,Info,server, Server version: 2.0.20.1 Linux
09-09-06 18:46:29,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load ./libmysqlclient_r.so.10.0.0
09-09-06 18:46:29,ERROR,All,SERVER, Start_Server: unable to open database
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 09-09-06 18:46 --------------
---------------------------------------------------------------

Jubalint

29-11-2006, 23:24

Same error as the above, the "Database initialization error: EDatabaseError.DLL/Shared Library Name not Set" one. I'm running dotdeb's mysql 5.0 package. I really would like to get this working, so I'd appreciate any help people could give.

GYSMO

09-03-2007, 00:31

GYSMO

09-03-2007, 00:35

all i might say is, in the documentation they say

VendorLib=/usr/lib/libmysqlclient_r.so.10.0.0
LibraryName=./libsqlmy.so

maybe by using "VendorLib=./libmysqlclient_r.so.10.0.0" doesn't work

try using the full path

BTW this doesn't seem much like a tutorial ...

again as of this in MySQL ...VendorLib=/usr/lib/libmysqlclient_r.so.10.0.0
dot seen on only is VendorLib=/usr/lib/libmysqlclient_r.so.15.0.0
and didnt work also so do mess around it ...smiles
whats next to try out
LibraryName=./libsqlmy.so

GYSMO

09-03-2007, 00:39

Just put libmysqlclient_r.so.10.0.0 in the same directory as TS and alter the path

like this

VendorLib=./libmysqlclient_r.so.10.0.0
LibraryName=./libsqlmy.so

Download libmysqlclient_r.so.10.0.0 (http://files.fixertec.net/teamspeak/libmysqlclient_r.so.10.0.0)

again it would be a nice try but where would you get that VendorLib=/usr/lib/libmysqlclient_r.so.10.0.0
wish someone would tell me how to get it as its not seen anywhere in my usr/lib/ folder

GYSMO

AB2314

16-04-2007, 20:43

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

25-04-2007, 12:02

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

30-04-2007, 21:36

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

07-04-2008, 15:48

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 :confused:

thx in advance

ckx3009

10-05-2008, 20:15

you should obtain necessary libs. you can do this in the following way:
go to that link (http://www.wesmo.com/rpm2html/contributed/RPMS/MySQL-shared-compat-4.1.9-0.i386.html) 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

28-05-2008, 11:36

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

29-05-2008, 22:59

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

30-05-2008, 23:36

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-2008, 19:20

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

05-06-2008, 06:31

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

05-06-2008, 06:43

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

05-06-2008, 07:15

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/showthread.php?p=179849#post179849

WTF people!!!!!!!!

sgtbenc

23-07-2008, 19:08

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

24-07-2008, 03:31

Ok, so they are all on the FTP: ftp://ftp.freenet.de/pub/4players/teamspeak.org/developer/server/202401/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

24-08-2008, 00:59

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

Katana*GFR*

24-08-2008, 01:18

http://rpmfind.net/linux/rpm2html/search.php?query=libmysqlclient_r.so.10.0.0

karimali831

24-08-2008, 13:43

Thanks :)

What do I do with this RPM file?

karimali831

24-08-2008, 14:46

Extracted the files, run command and it seems I have gone past that now. It says "EDatabaseError.dbExpress Error: Invalid Username/Password" going to search the forums for help on this.

apolebourin

16-09-2008, 20:15

hi everybody !
When I try to lunch my server with SQL I've this error :
---------------------------------------------------------------
-------------- log started at 16-09-08 19:34 -------------
---------------------------------------------------------------
16-09-08 19:34:09,ALL,Info,server, Server init initialized
16-09-08 19:34:09,ALL,Info,server, Server version: 2.0.24.1 Linux
16-09-08 19:34:09,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load ./libmysqlclient_r.so.15.0.0
16-09-08 19:34:09,ERROR,All,SERVER, Start_Server: unable to open database

my server.ini

[Main Config]
BoundToIp1=
ExternalIPDectection=1
HTTPServer Port=9100
HTTPServer Enabled=1
DateTimeFormat=dd-mm-yyyy hh:nn:ss
TCPQueryPort=9101
AllowedClientNameChars=
DisAllowedClientNameChars=()[]{}

[debug]
MessageTypes=LMTALL
MessageDepths=LMDALL

[WebPost]
AdminEmail=na
ISPLinkURL=na
ISPName=Private
ISPCountryNumber=4426
Enabled=1
PostURL=
ListPublic=1
UserAgent=teamspeak

[log]
access_r=0
access_u=0
channel_registerred=0
channel_unregisterred=0
sa=0
chat=0
kick_server=0
kick_channel=0

[Spam]
max_commands=10
in_seconds=2

[DBEXPRESS]
sqldir=mysql_sql
Drivername=mysql
Database=ts
Hostname=127.0.0.1
User_name=******
Password=*********
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/libmysqlclient_r.so.15.0.0
LibraryName=./libsqlmy.so
Active=1

If any one can help me :)

Katana*GFR*

16-09-2008, 22:43

EDatabaseError.Unable to Load ./libmysqlclient_r.so.15.0.0

Find that client?

apolebourin

18-09-2008, 17:52

Yes ...... i've got it and its the right dir ...

Nagilum99

13-11-2008, 15:14

Hi ppl,

after getting mysql libs 10.0.0 (as described here), set the passwd with old_password and "EInvalidField.field b_sp_AdminEditServerWelcomeMessage not found -> Edit the table and change the type tyint to int and the value 1 to 11" I now get the following error (am I the only one?):

13-11-08 15:05:36,ALL,Info,server, Server init initialized
13-11-08 15:05:36,ALL,Info,server, Server version: 2.0.24.1 Linux
13-11-08 15:05:37,ERROR,All,SERVER, VirtualServer Startup(1) Exception: EInvalidField.field b_sp_ChannelJoinChannelWithoutPassword not found
13-11-08 15:05:39,ALL,Info,server, Server init finished
13-11-08 15:05:39,WARNING,Info,server, TeamSpeak Server daemon activated

Does anyone have any Idea what I did wrong?
The Table exists in Server: localhost - Datenbank: <database> - Tabelle: ts2_server_privileges
So whay doesn't it work?

If I select the server superadmin (webinterface), the server now quielty dies.

Regards
- Nagilum

dlm1065

17-11-2008, 08:11

http://rpmfind.net/linux/rpm2html/search.php?query=libmysqlclient_r.so.10.0.0

Note: to all those out there like me running x64 use the i386 rpm and put it in the TS folder.
That will work if you have the x64 libs you'll get as frustrated as me as TS is 32 only ap
till version 3

Legremlins_Keitaro

17-11-2008, 10:53

I have a problem when I launch TS 2.x on a DEbian 64 with mysql 5.x

---------------------------------------------------------------
-------------- log started at 17-11-08 10:42 -------------
---------------------------------------------------------------
17-11-08 10:42:31,ALL,Info,server, Server init initialized
17-11-08 10:42:31,ALL,Info,server, Server version: 2.0.23.19 Linux
17-11-08 10:42:32,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load /usr/lib/libmysqlclient_r.so.10.0.0
17-11-08 10:42:32,ERROR,All,SERVER, Start_Server: unable to open database
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 17-11-08 10:42 --------------
---------------------------------------------------------------

Here the end of my config file:

[DBEXPRESS]
sqldir=/backup/teamspeak/tss2_rc2/mysql_sql/
Drivername=mysql
Database=ts
Hostname=127.0.0.1
User_name=ts
Password=ts2008
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/libmysqlclient_r.so.10.0.0
LibraryName=./libsqlmy.so
Active=1

I already change the hash password, modify read_servers.sql, replace localhost by 127.0.0.1, I have in /usr/lib the libmysqlclient_r.so.10.0.0, i restart the linux but nothing change i already have the same problem.
Someone can help me please

Nagilum99

20-11-2008, 13:24

Does noone have a clue where my problem is and how to solve it?
Did noone have the same problem?

Regards
- Nagilum

morris

21-11-2008, 01:46

What about:

ls -l /usr/lib/libmysqlclient_r.so.10.0.0

Legremlins_Keitaro

22-11-2008, 23:08

the lib was in chmod 777, nothing change alwas same problem, please help :(

ALpha__

28-03-2009, 01:33

Hello,

I installed the teamspeak server, in the file server.ini, I put:
[DBEXPRESS]
sqldir=mysql5_sql/
Drivername=mysql
Database=ts
Hostname=localhost
User_name=root
Password=my_password
GetDriverFunc=getSQLDriverMYSQL
Vendorlib=/usr/lib/libmysqlclient_r.so.15.0.0
LibraryName=./libsqlmy.so
Active=1

or :
[DBEXPRESS]
sqldir=/home/serveur/serveurts/mysql5_sql/
Drivername=mysql
Database=ts
Hostname=localhost
User_name=root
Password=my_password
GetDriverFunc=getSQLDriverMYSQL
Vendorlib=/usr/lib/libmysqlclient_r.so.15.0.0
LibraryName=/home/serveur/serveurts/libsqlmy.so
Active=1

I create a database ts :
mysql -u root -p and CREATE DATABASE ts; use ts.

I start the server and error :
28-03-09 01:28:06,ERROR,All,SQL, Database initialization error: EDatabaseError.DLL/Shared Library Name not Set
28-03-09 01:28:06,ERROR,All,SERVER, Start_Server: unable to open database

I type >> locate libmysqlclient_r.so >> /usr/lib/libmysqlclient_r.so
/usr/lib/libmysqlclient_r.so.15
/usr/lib/libmysqlclient_r.so.15.0.0

privilege for libmysqlclient_r.so.15 > root (chmod 644, I tested 777 but no change)....

OS : Debian Lenny :
uname -a
Linux *******.ovh.net 2.6.27.10-grsec-xxxx-grs-ipv4-32 #4 SMP Wed Feb 18 16:30:23 UTC 2009 i686 GNU/Linux

mysql (phpinfo.php) :
mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.0.51a
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/run/mysqld/mysqld.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient_r

thanks for answer...