Linux TS and MySQL 5

[dcooper]

I am hoping someone can give me a hand with getting TeamSpeak 2.0.20.1 working with MySQL 5.0.21.

My teamspeak installation lives in: /srv/teamspeak
I have created a database called teamspeak in MySQL and assigned all privs to the teamspeak@localhost user to that database.

I have the following setup in my server.ini file:

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


When I start teamspeak up, I get the following error in the log:

24-05-06 10:28:29,ALL,Info,server, Server init initialized
24-05-06 10:28:29,ALL,Info,server, Server version: 2.0.20.1 Linux
24-05-06 10:28:29,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load /usr/lib/libmysqlclient_r.so
24-05-06 10:28:29,ERROR,All,SERVER, Start_Server: unable to open database


FYI: /usr/lib/libmysqlcilent_r.so is a symlink to /usr/lib/mysql/libmysqlclient_r.so.15.0.0

The permissions on those files allow anyone to read and execute the file. I have even run the server as root and it still fails in this fashion. I have also tried specifying /usr/lib/mysql/libmysqlclient_r.so.15.0.0 in the server.ini but that also fails.

Regards,
Daniel

[guldi]

FYI: /usr/lib/libmysqlcilent_r.so is a symlink to /usr/lib/mysql/libmysqlclient_r.so.15.0.0
Please do a little forum search. You'll notice that TS does not "support" mySQL versions newer then 3.x (as stated in the Readme). You'll have to use a old library.... (search)


EDITED: note that the mySQL interface in TS is currently not recommended for productive use. That's one reason why newer mySQL versions are not integrated into TS2 as they are released. I assume this will be "corrected in TS3

[dcooper]

Thankyou guldi for your reply.
I have done a fair amount of searching, and did read that people were using old libraries to get MySQL working.

MySQL3 as you know is so old and pretty much featureless / of little use, so my post was to encourage discussion on MySQL5 and see if anyone has had any luck with it.

For now, I have given up on MySQL and TeamSpeak and now eagerly awaiting TeamSpeak3. Perhaps it will even have LDAP support! :)

Thanks again,
Daniel

[guldi]

MySQL3 as you know is so old and pretty much featureless / of little use, so my post was to encourage discussion on MySQL5 and see if anyone has had any luck with it.

there is no need to restart that discussion again and again as many threads deal with it ;) Fact is:

- using an old library is the only known working way with TS2
- an update to TS2 to make it compatible with newer mySQL versions is highly unlikely

=> TS3