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?

[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

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

[ALpha__]

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