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

[IceMatrix]

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

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]

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/...-password.html

[DanDriff]

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

still stumped :/

[Rashnu]

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_]

link for libs please?

[madaut]

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]

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

[yahooadam]

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]

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

[ThorGoLucky]

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]

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]

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

hmmm wonder what seetings are you talking about here ...
this in your unix server ???

[DBEXPRESS]
sqldir=mysql_sql\
Drivername=mysql
Database=TeamspeakDatabase
Hostname=localhost
User_name=TeamspeakUsername
Password=TeampspeakUserPassword
GetDriverFunc=getSQLDriverMYSQL
VendorLib=libmySQL.dll
LibraryName=dbexpmysql.dll
Active=1

strange hmmm are you running microsoft for running on dbexpmysql.dll

[GYSMO]

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]

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

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