PDA

View Full Version : TeamSpeak 2 on MySQL 5.0

Dimedo
04-11-2005, 10:09
Is there someone who is running a full-tested TeamSpeak 2 Server with MySQL 5.0 on Linux (especially Debian 3.1), yet?

And if so, isn't there more to do than described here (http://forum.goteamspeak.com/showthread.php?t=26982). (No more alternative drivers? :confused: )

This would be very nice to know before I try to establish it myself on my new server.
notpappy
04-11-2005, 10:46
you may try editing the sql queries so they all appear on one line as described at the end of http://forum.goteamspeak.com/showthread.php?t=22077 that is what worked for me.
marcelrx
04-11-2005, 13:51
Is there someone who is running a full-tested TeamSpeak 2 Server with MySQL 5.0 on Linux (especially Debian 3.1), yet?

And if so, isn't there more to do than described here (http://forum.goteamspeak.com/showthread.php?t=26982). (No more alternative drivers? :confused: )

This would be very nice to know before I try to establish it myself on my new server.

It isn't possible to run Teamspeak with MySQL 5.0 only <4.1.
But you must also have the old libarys (libmysqlclient_10...) from the old 3.X MySQL. Also I advise you not to run teamspeak with mysql because it only makes more problems as fun. If you need MySQL because you would use the data with a forum DB or something else you also can use the normal sqlite. With PHP it should be no problem to connect to the sqlite file.
Dimedo
04-11-2005, 13:51
that is what worked for me.

Do you use MySQL 5.0 or 4.1?

I need to work with 5.0 and don't want to use an 4.0 instance simulanously. I know there is a (untested?) way with non-freeware, 3rd party database drivers to use MySQL 4.1. And there is this new solution with the altered SQL command scripts.

And my question is if anyone has tested a system over a while running with TeamSpeak 2 on MySQL 5.0 on some Linux or better Debian Linux 3.1 and is sure it works fine.

So please give me more infomation. :)
marcelrx
04-11-2005, 13:54
Do you use MySQL 5.0 or 4.1?

I need to work with 5.0 and don't want to use an 4.0 instance simulanously. I know there is a (untested?) way with non-freeware, 3rd party database drivers to use MySQL 4.1. And there is this new solution with the altered SQL command scripts.

And my question is if anyone has tested a system over a while running with TeamSpeak 2 on MySQL 5.0 on some Linux or better Debian Linux 3.1 and is sure it works fine.

So please give me more infomation. :)

You need Mysql 4.1 or lower. It dosen't work with MySQL 5.0
Dimedo
04-11-2005, 14:16
You need Mysql 4.1 or lower. It dosen't work with MySQL 5.0

Have you tested it with the drivers by yourself? - If so, ok!

But the guy who found out about the drivers told something about MySQL 5.0 but he couldn't test very much because the demo version of the driver had some ugly limits that prevented him from doing so.

It would be extremely nice if there would be some way.
Tenkawa
08-11-2005, 20:04
I have 2 servers on my box one runs against SQLite and the other one is running against Mysql 5.0.15 server using the mysql3 library. I am not having any issues currently.

Tenkawa
siepel
12-11-2005, 02:34
You need Mysql 4.1 or lower. It dosen't work with MySQL 5.0

Several people have it runnunong on 4,1 and higher so that is not a problem!

Personally, i have a server running on Ver 4.1.14-Debian_6-log
the second backup server is on mysqld Ver 5.00.15 Also Debian box.

It uses the normal mysql 3.x client, no drivers where u have to pay for, and no weird tricks.
php and sqlite works, but its sucks hard.

Using mysql is way better, and if u get more and more users the performance of mysql is way better, extra md5 security.
McAfee
12-11-2005, 18:14
MySQL 4.1 and newer use a new password hashing theme that the old 3.x client library doesn't support. And attempting to use a newer client library won't work, because you would need new dbExpress drivers (which you have to pay for)

I remember trying this before, and configuring my server to use old passwords, and it just didn't work. There is an old thread about running TS2 on MySQL 4.1.x. Many have tried it and failed. Both Linux and Windows users. (I'm on windows)

Some people now say they can run on MySQL 5.0.x without problems. I have not upgraded the MySQL server in a while, with fear it might break TS2.

May I ask what non-default options you are using on the MySQL 5.0.x server? (example: old-passwords)
Can you confirm you are using the supplied dbExpress driver?
And from where are you using the 3.x library? mysql-3.23.58?

I don't want to migrate to MySQL 5.0 just to discover TS2 doesn't work again.

Edit: (the old thread)
http://forum.goteamspeak.com/showthread.php?t=18157
siepel
13-11-2005, 04:59
MySQL 4.1 and newer use a new password hashing theme that the old 3.x client library doesn't support. And attempting to use a newer client library won't work, because you would need new dbExpress drivers (which you have to pay for)

May I ask what non-default options you are using on the MySQL 5.0.x server? (example: old-passwords)
Can you confirm you are using the supplied dbExpress driver?
And from where are you using the 3.x library? mysql-3.23.58?


Mysql 4.x has old_password= 1 default enabled in cnf.my
I`m not sure if that is default for mysql 5.x, but you can safely use that option.

As i said, it runs without any errors, or problems. For 11 days straight now.

i use libmysqlclient_r.so.10.0.0 (not sure wich exact 3.x version it came with, but i can send u the file if u want)

It wasnt easy to get it running, but now i have, its very easy. I just did another install for a friend, up and running within 10 mins.