Teamspeak & MySQL 4.x [Archive] - TeamSpeak Community Forums

View Full Version : Teamspeak & MySQL 4.x

-FN-

02-09-2004, 01:06

I'm trying to setup a Teamspeak server under Redhat 9 running MySQL 4.0.16. I've untarred the whole deal, setup permisisons and such, and have my server.ini file as such:

[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=teamspeak
Hostname=localhost
User_name=db_user
Password=db_pass
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/local/mysql/lib/mysql/libmysqlclient.so.12.0.0
LibraryName=./libsqlmy.so
Active=1

When I try to fire up ./teamspeak2-server_startscript start, I get this in the server.log after the "Error starting daemon. Aborted" message:

-------------- log started at 01-09-04 17:59 -------------
---------------------------------------------------------------
01-09-04 17:59:50,ALL,Info,server, Server init initialized
01-09-04 17:59:50,ALL,Info,server, Server version: 2.0.20.1 Linux
01-09-04 17:59:50,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load /usr/local/mysql/lib/mysql/libmysqlclient.so.12.0.0
01-09-04 17:59:50,ERROR,All,SERVER, Start_Server: unable to open database
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 01-09-04 17:59 --------------
---------------------------------------------------------------

I did a search here for the EDatabaseError and only found a few threads in German :( But they made some mentions to MySQL 3 and 4 and I'm guessing I have to do something else to make the server use a MySQL 3 driver to communicate with the MySQL 4 server?

I'm currently trying out TS to possibly replace my Ventrilo 2.1.4 setup. I've scripted a lot of serverside user managability with Ventrilo though, and want to see how robust Teamspeak gets in that respect. Any help is appreciated :)

guldi

02-09-2004, 08:59

1) you can limit your search to one specific Forum, in your case I'd search in English-Linux-Server. There you'll find for sure some help.
E.g. this one. (http://forum.goteamspeak.com/showthread.php?t=14412&highlight=mysql)

-FN-

02-09-2004, 10:30

Alrighty - got MySQL-shared-compat installed, using a .10, connecting fine...

But now I'm at the exact same point I found in another thread - where the guy didn't get an answer :(

The user i set up works from the command line with no problem. And i know i've given that user the correct permissions. I've even triend root, which i know has no problems, but no success. Is there something that i'm over looking? The DB stores passwords encoded right? should i have the encoded password in the server.ini?

here is what's going on:

C:\>mysql -u teamspeak -pasdfasdf
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13 to server version: 4.0.20a-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use teamspeak
Database changed
mysql>

but here's the response from ts. (server.log)

---------------------------------------------------------------
-------------- log started at 12-06-04 11:36 -------------
---------------------------------------------------------------
12-06-04 11:36:36,ALL,Info,server, Server init initialized
12-06-04 11:36:36,ALL,Info,server, Server version: 2.0.20.1 Win32
12-06-04 11:36:36,ERROR,All,SQL, Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
12-06-04 11:36:36,ERROR,All,SERVER, Start_Server: unable to open database
12-06-04 11:36:36,ERROR,All,GENERAL, critical error, shutdown initiated

And my current [dbexpress] section in server.ini

[DBEXPRESS]
sqldir=C:/Program Files/Teamspeak2_RC2/mysql_sql/
Drivername=mysql
Database=teamspeak
Hostname=localhost
User_name=teamspeak
Password=asdfasdf
GetDriverFunc=getSQLDriverMYSQL
VendorLib=libmysql.dll
LibraryName=dbexpmysql.dll
Active=1

thanks.

Now I realize that the guy is working on a Windows server, but the principle is the same. I've tried several users, all who can access the database in command line and in phpMyAdmin, but teamspeak insists that the u/p is wrong :(

guldi

02-09-2004, 12:56

what if you change

Hostname=localhost
to
Hostname=127.0.0.1

-FN-

02-09-2004, 19:46

*tries*

Same error.

guldi

05-09-2004, 13:27

I had the user/passwd problem as well under Win2k. I had set the users with the MySQL controll center which somehow doesn't seems to set the password right.
Are you really sure you can connect to the empty TS database with the user you have linked in the server.ini ?
If I remember right, I had to set the rights in the end on the console as I didn't got it work with the controll center.

That's my server.ini section:

[DBEXPRESS]
sqldir=C:/Programme/Teamspeak2_RC2_2010/mysql_sql/
Drivername=mysql
Database=guldi_ts_1
Hostname=localhost
User_name=guldi
Password=******
GetDriverFunc=getSQLDriverMYSQL
VendorLib=C:/mysql/lib/opt/libmySQL.dll
LibraryName=C:/Programme/Teamspeak2_RC2_2010/dbexpmysql.dll
Active=1

For this I have a user:
'guldi@localhost' which has Global privilegs and the right to the guldi_ts_1 database.

Xipher

05-09-2004, 17:51

I am guessing you have restarted the Sql server at least once by now, if not, make sure you flush the privilage tables, since that can cause problems. If you want more info about it, MySQL's online docs cover it, just search for flushing privilage tables

=wH=Que

16-11-2004, 18:48

My steps and output match what is listed in this thread.

Did anyone ever figure out what was causing the issue with the username/password error?

- MySql was restarted to make sure all my rights etc were flushed.
- Login and password was verified with the mysqlclient
- Error in the server.log is the same as stated in this thread
- The server starts without error when removing the database section

Please feel free to e-mail me at que@wanderinghorde.com if you can help. Thanks in advance!!

=wH=Que

18-11-2004, 00:05

Has no other been able to get the configuration working? I would hate to have to use an older version of MySql...

McAfee

18-11-2004, 01:38

MySQL 4.1.x is not supported,
stick with version 4.0.x

=wH=Que

19-11-2004, 16:57

Not working with 4.0.2 either... same error as before.

Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
Start_Server: unable to open database

Please help.

Himself

01-12-2004, 17:27

anyone got a solution for this ?

i use mysql ver 4.0.x ,

i have the same problem, the login/pass works in mysql client and not int he TS server....

=wH=Que

02-12-2004, 01:21

I have not found a solution as of yet. Please post it here if you have better luck.

Duren

02-12-2004, 11:21

I came upon this problem long ago and came back to see if they'd updated the ts server to support mysql 4.x.x

there seems to be NO support for it, I got it working with mysql ver3 only which is of no use to me. as I run phpbb and need 4.x support.

guldi

02-12-2004, 12:56

no, mySQL 4.x is still not directly supported. TS2 is not developped anymore so bevore TS3 there will be (most surely) no update.

Broder

15-12-2004, 01:33

We successfully run TS with MySQL 4.0.18 for ages now

See my post here

http://forum.goteamspeak.com/showthread.php?t=13502

bchecketts

06-01-2005, 02:40

I still haven't gotten mine working completely, but I have managed to get the server to connect to the database and create the tables. I believe the database user authentication problem has to do with the new way the mysql stores passwords in the database. If you are using an older library, it most likely doesn't support the new method, so you have to tell mysql to use the old password format. The password change is described on mysql's site at http://dev.mysql.com/doc/mysql/en/Old_client.html
I used the following sql to set the password to the old version:

SET PASSWORD FOR 'tsuser'@'localhost' = OLD_PASSWORD('tspass');

After doing this, the server connected correctly, and created the appropriate tables, but now I get this error:

---------------------------------------------------------------
-------------- log started at 05-01-05 20:23 -------------
---------------------------------------------------------------
05-01-05 20:23:48,ALL,Info,server, Server init initialized
05-01-05 20:23:48,ALL,Info,server, Server version: 2.0.20.1 Linux
05-01-05 20:23:49,WARNING,Info,SQL, created table ts2_servers
05-01-05 20:23:49,WARNING,Info,SQL, created table ts2_server_privileges
05-01-05 20:23:49,WARNING,Info,SQL, created table ts2_channels
05-01-05 20:23:49,WARNING,Info,SQL, created table ts2_channel_privileges
05-01-05 20:23:49,WARNING,Info,SQL, created table ts2_clients
05-01-05 20:23:49,WARNING,Info,SQL, created table ts2_bans
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 05-01-05 20:23 --------------
---------------------------------------------------------------
05-01-05 20:23:49,ERROR,Info,server, EDatabaseError: dbExpress Error: Operation Not Supported

I'm using mysql 4.1.5 and libmysqlclient_r.so.10.0.0. Anybody know what to do now?

Thanks,
Brandon

-FN-

12-03-2005, 00:58

So this is kinda funny. After 7 Months, I thought I'd give setting up Teamspeak another go. Again, I'm running into problems getting TS to run on Linux with MySQL 4.0.16. I am getting this error:

----------------------------------------------------------
-------------- log started at 11-03-05 17:39 -------------
---------------------------------------------------------
11-03-05 17:39:06,ALL,Info,server, Server init initialized
11-03-05 17:39:06,ALL,Info,server, Server version: 2.0.20.1 Linux
11-03-05 17:39:06,ERROR,All,SQL, Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
11-03-05 17:39:06,ERROR,All,SERVER, Start_Server: unable to open database
----------------------------------------------------------
--------------- log ended at 11-03-05 17:39 --------------
----------------------------------------------------------

With this in my server.ini:

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

I am sure the username and password is correct because of this:

[root@fn tss2_rc2]# /usr/local/mysql/bin/mysql -u teamspeak -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1627 to server version: 4.0.16-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SHOW DATABASES;
+---------------+
| Database |
+---------------+
| teamspeak |
+---------------+
1 row in set (0.00 sec)

I can't use the OLD_PASSWORD() fix suggested as it's only available as of 4.1 (http://dev.mysql.com/doc/mysql/en/encryption-functions.html), and I believe from what I've read here, I have a better chance of getting this to work under 4.0.x than 4.1.x.

I had completely forgotten I posted this until I found it while searching the forum, hehe. So, 7 Months later, anyone have this successfully running under 4.0.x under Linux and care to shed some light?

Thanks in advance,
- FN -

einherjer

16-03-2005, 09:46

take the libmysqlclient.10.0.0 from this package

http://dev.mysql.com/get/Downloads/MySQL-4.0/MySQL-shared-compat-4.0.24-0.i386.rpm/from/http://ftp.gwdg.de/pub/misc/mysql/

for MySQL 4.0.x or from

http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-shared-compat-4.1.10a-0.i386.rpm/from/http://ftp.gwdg.de/pub/misc/mysql/

for MySQL 4.1.x

copy libmysqlclient.10.0.0 to your Teamspeak Directory (you don't need the old file in the fresh lib dir ;-)

VendorLib=./libmysqlclient.10.0.0

that's it

time for a newer TS Server....

-FN-

16-03-2005, 21:21

Downloaded: http://dev.mysql.com/get/Downloads/MySQL-4.0/MySQL-shared-compat-4.0.24-0.i386.rpm/from/http://ftp.gwdg.de/pub/misc/mysql/

Contents of the rpm:
usr/lib/libmysqlclient.so
usr/lib/libmysqlclient.so.10
usr/lib/libmysqlclient.so.10.0.0
usr/lib/libmysqlclient.so.12
usr/lib/libmysqlclient.so.12.0.0
usr/lib/libmysqlclient_r.so
usr/lib/libmysqlclient_r.so.10
usr/lib/libmysqlclient_r.so.10.0.0
usr/lib/libmysqlclient_r.so.12
usr/lib/libmysqlclient_r.so.12.0.0

There is no 'libmysqlclient.10.0.0' so I copied libmysqlclient.so.10.0.0 and libmysqlclient_r.10.0.0 to my tss_rc2 directory, tried both in my server.ini:

VendorLib=./libmysqlclient_r.so.10.0.0

... then ...

VendorLib=./libmysqlclient.so.10.0.0

Both yeild:

[root@fn tss2_rc2]# tail server.log
-------------- log started at 16-03-05 14:11 --------------
----------------------------------------------------------
16-03-05 14:11:35,ALL,Info,server, Server init initialized
16-03-05 14:11:35,ALL,Info,server, Server version: 2.0.20.1 Linux
16-03-05 14:11:35,ERROR,All,SQL, Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
16-03-05 14:11:35,ERROR,All,SERVER, Start_Server: unable to open database

----------------------------------------------------------
--------------- log ended at 16-03-05 14:11 --------------
----------------------------------------------------------

Again, I'm 500% sure the user can connect to my MySQL and see and alter the necessary table. I have MySQL 4.0.16 running.

*sigh* When's TS3 coming out? :(

einherjer

16-03-2005, 21:38

There is no 'libmysqlclient.10.0.0'
Sorry, my fault ;-)

Try to start it some times...

It sometimes needs 3 tries to start, but then ts runs stable.

If ts is critical to you, maybe a startup script that checks for the pid file would help. (trying to start the service until the pid file is there...)

And yes, its really time for an updated version...

Hmm, what will be released earlier... Hurd or TS 3.0.... ;-)

stewbeast

19-03-2005, 04:53

TRACING the problem:

[stewbeast@jackal tss2_rc2]$ strace -fF ./server_linux -pid=1.pid 2>&1 | grep sock
socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 6
setsockopt(6, SOL_SOCKET, SO_REUSEADDR, [1], 4) = 0
getsockname(6, {sa_family=AF_INET, sin_port=htons(51234), sin_addr=inet_addr("0.0.0.0")}, [16]) = 0
[pid 21917] socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) = 9
[pid 21917] socket(PF_UNIX, SOCK_STREAM, 0) = 10
[pid 21917] connect(10, {sa_family=AF_UNIX, path="/var/lib/mysql/mysql.sock"}, 110) = -1 ENOENT (No
such file or directory)

My sock happens to be:
/var/tmp/mysql.sock

So I cheesed it with:
[stewbeast@jackal tss2_rc2]$ sudo mkdir -p /var/lib/mysql
[stewbeast@jackal tss2_rc2]$ sudo ln -s /var/tmp/mysql.sock /var/lib/mysql/mysql.sock

And it works... crazy man... crazy

Looks like User/Pass error might be a "red herring" for other issues like "Where's the dern socket file?"

einherjer

19-03-2005, 05:02

/home/ts # locate mysql.sock
/var/lib/mysql/mysql.sock

this should not be the problem in my case...

-FN-

21-03-2005, 17:01

I think I'm going to hump stewbeast's leg... I did the same thing basically and HOLY CRAP IT WORKED!

7 months later, he got me up and running - thanks a million dude :D

rhoekstra

23-03-2005, 23:33

Unfortunately, I don't have good luck with this method either. I have 4.1.10a running (and with 4.1.9 it didn't help either).

Any other suggestions? I mean even after the update to 4.1.10a and with the suggested workaround, the message " EDatabaseError: dbExpress Error: Operation Not Supported" keeps coming. it's all the log says:

---------------------------------------------------------------
-------------- log started at 23-03-05 23:24 -------------
---------------------------------------------------------------
23-03-05 23:24:46,ALL,Info,server, Server init initialized
23-03-05 23:24:46,ALL,Info,server, Server version: 2.0.20.1 Linux
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 23-03-05 23:24 --------------
---------------------------------------------------------------
23-03-05 23:24:47,ERROR,Info,server, EDatabaseError: dbExpress Error: Operation Not Supported

Any additional info or help would be appreciated

Oh, and.. I'm running it on Fedora Core 3, with kernel 2.6.10, fwiw.

meisenst

25-06-2005, 18:05

If you have "Operation Not Supported", and not the username/password issue, try doing what I did here (http://forum.goteamspeak.com/showthread.php?t=22077). It should work for you.

joev

06-07-2005, 13:08

no, mySQL 4.x is still not directly supported. TS2 is not developped anymore so bevore TS3 there will be (most surely) no update.

Why is it not possible to simply recompile the TS2 Linux server against the latest version of the DBExpress driver? That way it would still be backward compatible with MySQL 3.x but also compatible with MySQL 4.x and even 5.x

This will alleviate these problems for a large part of your user (server) base. It's long since that this should have been done.

Given the historical speed of development of TS (measured usually in eons) it would make sense to do this now and ensure the future usability of the TS server -> MySQL connectivity... If I've to wait for TS3 for this (given that it's likely to be a really *really* long wait from past experience) then I'm more inclined to dump TS in favour of a solution that is more adaptable and kept up to date.

Cwac

11-07-2005, 08:43

Ok I hope I can shed a little bit of light on this issue. I ran into this with a Windows installation of TS while trying to port to MySQL 4.1. As a developer my first instinct was to google the error messages I was getting. I found ALOT of programmers running into the same problem with dbExpress. It seems that it is not a TS issue that recompilation will resolve, but a Borland/Delphi and MySQL issue. So some further searching and I found a company that writes a commercial driver specifically to solve this. They have a Linux version as well. I downloaded the trial version (which has limited features) and it worked well. The caveat is there is a 70$ one time fee to the developer who packages the driver (aka Teamspeak).

I did not find any free/open source equivelants to this driver, but would be thrilled if someone else knows of one. If I reach the point that I am ready to put TS into production I will probably suck it up and just pay the fee if TS hasnt done so yet. If I have to do this I will speak to the company that develops the driver and see if I cant act in TS's behalf and make it available to the rest of you.

Here is my initial write up with the same information, and installation instructions for windows...

http://forum.goteamspeak.com/showthread.php?p=99797

TRI0N

22-08-2005, 03:54

While their still working on something to work in MySQL 4.x they are still behind since MySQL 5 is already out... So the idea of wanting to run a TS2 server on a Linux box you must have Old Out Of Date Software to be compatible.

Makes a Ton of sence. Right.....

innerspace

27-03-2006, 23:47

of course, and no solution... only coments like "use the search function"... (which does not solve any problem)

Quinntum

03-08-2007, 23:50

Hello everyone.

I seem to be having some issues setting up TS with MySQL4.x Here are the logs of whats going on.

Centos 4.5
MySQL 4.1.20

---------------------------------------------------------------
03-08-07 11:31:20,ALL,Info,server, Server init initialized
03-08-07 11:31:20,ALL,Info,server, Server version: 2.0.23.19 Linux
03-08-07 11:31:20,ERROR,All,SQL, SQL file not found mysql_sql/read_servers.sql
03-08-07 11:31:20,ERROR,All,SQL, SQL file not found mysql_sql/new_server.sql
03-08-07 11:31:20,ERROR,All,SQL, SQL file not found mysql_sql/read_server_privilege.sql
03-08-07 11:31:20,ERROR,All,SQL, SQL file not found mysql_sql/new_server_privilege.sql
03-08-07 11:31:20,ERROR,All,SQL, SQL file not found mysql_sql/read_server_privilege.sql
03-08-07 11:31:20,ERROR,All,SQL, SQL file not found mysql_sql/new_server_privilege.sql
03-08-07 11:31:20,ERROR,All,SQL, SQL file not found mysql_sql/read_server_privilege.sql
03-08-07 11:31:20,ERROR,All,SQL, SQL file not found mysql_sql/new_server_privilege.sql
03-08-07 11:31:20,ERROR,All,SQL, SQL file not found mysql_sql/read_server_privilege.sql
03-08-07 11:31:20,ERROR,All,SQL, SQL file not found mysql_sql/new_server_privilege.sql
03-08-07 11:31:20,ERROR,All,SQL, SQL file not found mysql_sql/read_server_privilege.sql
03-08-07 11:31:20,ERROR,All,SQL, SQL file not found mysql_sql/new_server_privilege.sql
03-08-07 11:31:20,ERROR,All,SQL, SQL file not found mysql_sql/read_server_privilege.sql
03-08-07 11:31:20,ERROR,All,SQL, SQL file not found mysql_sql/new_server_privilege.sql
03-08-07 11:31:20,ALL,Info,server, Starting VirtualServer id:0 with port:8767
03-08-07 11:31:20,ERROR,All,SQL, SQL file not found mysql_sql/edit_server.sql
03-08-07 11:31:20,ERROR,All,SQL, SQL file not found mysql_sql/read_channels.sql
03-08-07 11:31:20,ERROR,All,SQL, SQL file not found mysql_sql/new_channel.sql
03-08-07 11:31:20,ERROR,All,SQL, SQL file not found mysql_sql/read_bans.sql
03-08-07 11:31:20,ALL,Info,server, Started VirtualServer id:0 with port:8767
03-08-07 11:31:20,WARNING,Info,SERVER, Default VirtualServer created
03-08-07 11:31:20,ERROR,All,SQL, SQL file not found mysql_sql/read_clients_name.sql
03-08-07 11:31:20,ERROR,All,SQL, SQL file not found mysql_sql/new_client.sql
03-08-07 11:31:20,WARNING,Info,SERVER, admin account info: username: admin password: jj2rwi
03-08-07 11:31:20,ERROR,All,SQL, SQL file not found mysql_sql/read_clients_name.sql
03-08-07 11:31:20,ERROR,All,SQL, SQL file not found mysql_sql/new_client.sql
03-08-07 11:31:20,WARNING,Info,SERVER, superadmin account info: username: superadmin password: ya3hsb
03-08-07 11:31:21,ALL,Info,server, Server init finished
03-08-07 11:31:21,WARNING,Info,server, TeamSpeak Server daemon activated

Here is my server.ini file.

[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=teamspeak
Hostname=sqlaxx.xxxx.com
User_name=xxxxxxx
Password=xxxxx
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/mysql/libmysqlclient_r.so.10.0.0
LibraryName=./libsqlmy.so
Active=1

I've made sure that permissions on the users and the folders were correct, I've run this with in root as well just to make sure everything was ok there.

I feel that Im missing something so little, that Im gonna kick myself.

Any suggestions?

Quinntum

valantis

14-08-2009, 13:05

Tomas

16-08-2009, 15:25

....
I feel that Im missing something so little, that Im gonna kick myself.

Any suggestions?

Quinntum

I am afraid you do miss something little. Its RTFM. where you can find out that if you want to use MySQL you should copy files from lite_sql or how is that other folder named to mysql_sql

i have the same problem i check all forum and all google i cant fix it.. can someone help me??
i can login from bronswer but ts2 cant.. he said

thanks.
at first make sure you did put the correct name and password in both ends(in MySQL server account and TeamSpeak server.ini file) then of course try to check for weird characters that might be after the login or pass on line in ini file like <tabelator>.

umm what is MySQL version ??

if its the problem I think then :
http://tpc.webyt.net/files/TeamSpeak2/MySQL-files/server.ini.txt
that refers to the SQL statements inside the file do OLD_PASSWORD for teamspeak account in MySQL then try start TeamSpeak

I might get and put my SQL ....10.0.so for linux in that folder if you need it