TeamSpeak + MySQL 4.1.7 (GA)

[McAfee]

Has anyone succesfully made TeamSpeak work
with the recently released MySQL 4.1.7 (GA) ??

The MySQL 3.x client library seems to be incompatible with MySQL 4.1 (and newer). Of course, I may be doing something wrong. But, I have applications using the 4.0 client library without problems.

Maybe it's time TeamSpeak had an updated MySQL client library.

I'm Using:
Windows XP SP2
MySQL 4.1.7 (Windows)
TeamSpeak 2.0.20.1-RC2 (Windows)

[Fisch.666]

Hi!

Do you get this:


---------------------------------------------------------------
30-10-04 11:15:07,ERROR,Info,server, EDatabaseError: dbExpress Error: Operation Not Supported


in your server.log? I can't start tss2 because i get the error above in my server.log. :(


*Edit*

Using Mysql 4.1.7 at my debian sarge box.

[McAfee]

Remember you need to use the libmysql.dll the came with MySQL 3.x
You error could be related to that. Just download a .ZIP release of MySQL 3.x to get the file.

The error I got was an authentification error:
30-10-04 01:59:22,ERROR,All,SQL, Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password

Which is probably caused by all the password changes MySQL has experienced since version 3.x. Of course, I may be doing something wrong. But I believe the 3.x library is incompatible with MySQL 4.1

I tried using the --old-passwords option of MySQL 4.1 and it didn't work. So, I had to go back to 4.0 for now.

[Fisch.666]

Hi!

Sorry, i didn't realised that you've posted this into "[English] Windows - Server".
I run a Linux Server, maybe i start a new thread in the Linux Server forum.

But i use the old libmysqlclient_r.so.10.0.0 from Mysql 3.x, not the new one from 4.1.7.

When i use the new libmysqlclient.so.14.0.0 from Mysql 4.1.7 then i get this error:


30-10-04 21:40:35,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load /usr/local/mysql/lib/mysql/libmysqlclient.so.14.0.0
30-10-04 21:40:35,ERROR,All,SERVER, Start_Server: unable to open database

[McAfee]

BUMP,

has anyone sucessfully made TeamSpeak work with MySQL 4.1.x ??
If so, how?

[Fisch.666]

No, i switch back to the included sqlite :(

[Chiroptera]

libsqlmy.so is too old for MySQL 4.1. :(

If someone can start TS with libsqlmda.so.2.00 ( http://crlab.com/dbx/ ) --> I'm very interested in the solution. ;)

[FunnyDingo]

Hello,

bad news. yesterday I tried to use libsqlmda.so.2.10, libmysqlclient_r.10.0.0 and MySQL 4.1.7. My DBEXPRESS part looked like this:

sqldir=mysql_sql/
Drivername=mysql
Database=xxx
Hostname=127.0.0.1
User_name=xxx
Password=xxx
GetDriverFunc=getSQLDriverMySQL
VendorLib=/usr/lib/libmysqlclient_r.so.10.0.0
LibraryName=./libsqlmda.so.2.10.so
Active=1
I had to change GetDriverFunc from getSQLDriverMYSQL to getSQLDriverMySQL (y in lower cases, in upper cases it said "Unable to Find Procedure getSQLDriverMYSQL"). But it don't work correctly. After starting ts2 the server-log said
04-12-04 01:58:27,ERROR,Info,server, EInvalidField: field b_server_active not found
I also tried to change the hostname from 127.0.0.1 to localhost. The same problem. So I downgraded to MySQL-4.0.22. I think we have to wait for TS3.

Greetz,


Funny

[McAfee]

BUMP

MySQL 4.1.x has been out for a while now,
anyone have a solution yet?

[xCav8r]

I had the same problem with 4.1.9, and after downgrading to 4.0.23, it worked. I speculated--with no or little knowledge--in another post (http://forum.goteamspeak.com/showthread.php?t=19619) that touched on this subject that the problem might be the new hashing (http://dev.mysql.com/doc/mysql/en/Password_hashing.html) they introduced in 4.1.

And, just in case someone is doing a search on this topic, I posted in another thread (http://forum.goteamspeak.com/showthread.php?t=20132) that I experienced problems connecting to a remote MySQL server with the ODBC driver 3.51.10, but I was able to connect to the MySQL server when I ran TS2 from that same machine. After upgrading to 3.51.11, however, the problem went away.

[Chiroptera]

I had the same problem with 4.1.9, and after downgrading to 4.0.23, it worked. I speculated--with no or little knowledge--in another post (http://forum.goteamspeak.com/showthread.php?t=19619) that touched on this subject that the problem might be the new hashing (http://dev.mysql.com/doc/mysql/en/Password_hashing.html) they introduced in 4.1.
I'm running MySQL 4.1.11 Generally Available (GA)!. But I'm going to switch back to the sqlite DB due to further problems with this version. I can't install 4.0.24, because I need some of the new features that come with 4.1. :(

You can set the password in the old style (pre 4.1.x) with SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('mypass'); This fixes the Invalid Username/Password entry in the log. But then you'll get this error: "EDatabaseError: dbExpress Error: Operation Not Supported". :mad:

@TS-developers: A new MySQL client would be great! ;)

My system: SuSE Linux 9.1 with MySQL 4.1.11.

[Rooter]

Hello,

bad news. yesterday I tried to use libsqlmda.so.2.10, libmysqlclient_r.10.0.0 and MySQL 4.1.7. My DBEXPRESS part looked like this:

sqldir=mysql_sql/
Drivername=mysql
Database=xxx
Hostname=127.0.0.1
User_name=xxx
Password=xxx
GetDriverFunc=getSQLDriverMySQL
VendorLib=/usr/lib/libmysqlclient_r.so.10.0.0
LibraryName=./libsqlmda.so.2.10.so
Active=1I had to change GetDriverFunc from getSQLDriverMYSQL to getSQLDriverMySQL (y in lower cases, in upper cases it said "Unable to Find Procedure getSQLDriverMYSQL"). But it don't work correctly. After starting ts2 the server-log said

I also tried to change the hostname from 127.0.0.1 to localhost. The same problem. So I downgraded to MySQL-4.0.22. I think we have to wait for TS3.

Greetz,
FunnyI realize your post is over 6 months old, but to help anyone else that may experience the problem I am replying anyway.

In regards to your specific error, I found a solution and posted about it in this thread.
http://forum.goteamspeak.com/showthread.php?t=24654

P.S. If you plan to use MySQL 4.1.x you may want to try it's newer Vendor Library, /usr/lib/libmysqlclient_r.so.14.0.0, in addition to the new driver.