TeamSpeak with MySQL > 4.0

**zionahead** · 04-09-2007, 19:47

This is strange. I stopped and then restarted the TS server.

Now, http://xxx.xxx.xxx.xxx:14534 is showing login prompt but when I input admin / default password (found in README) it just hangs there.

If I try again, it shows page not found.

**Computerman** · 06-09-2007, 13:55

Originally Posted by mokum

When using a mysql version > 4.0 you might expirience problems with starting the tss deamon. The server.log file will contain the errors.

meisenst solved the initial problem [EDatabaseError: dbExpress Error: Operation Not Supported] by changing the query in mysql_sql/read_servers.sql to read:

Code:

select * from ts2_servers WHERE i_server_id > 0;

Then there is a second problem with the changing of ChannelAttribs. Changes made to users rights [like CA etc] would be LOST after disconnection.

siepel fixed the second problem [GetChannelAttribs Exception: EDatabaseError.dbExpress Error: Operation Not Supported]

Code:

select * from ts2_channel_privileges where i_cp_server_id = :iServerID and i_cp_channel_id = :iChannelID and i_cp_client_id = :iClientID

put that in mysql_sql/read_channel_privilege.sql just on one single line exactly as above..

Please sticky this.

Cheers,
mokum

This is all well and good but my problem (haven't seen this covered anywhere in these forums) is that when starting the Linux server (any version) it just doesn't create any MySQL tables .. which would by itself explain the "Invalid Username/Password" errors I keep getting ... WHY isn't it creating any tables? I'm running tss2_rc2_20201 on a RedHat 9 server, I am now running MySQL 5.0.xx and am willing to try earlier versions although some people here say it doesn't matter what version or whatever. Yes, I've added the [DBEXPRESS] section to the bottom of my server.ini file:

[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=mydatabase
Hostname=127.0.0.1
User_name=databaseuserwithfullprivileges
Password=databaseuserpasswordforsameuser
GetDriverFunc=getSQLDriverMYSQL
VendorLib=./libmysqlclient_r.so.10.0.0
LibraryName=./libsqlmy.so
Active=1

and Yes, the above-named libmysql v.3 libraries are installed in the same directory (tss2_rc2) as all the other files. I've modified my.cnf per someone's instructions, to enable this 'old_passwords' format. I've stopped and started the mysql server. Nothing seems to create that MySQL database!

WHY don't Teamspeak developers just put all the libmysql libraries (v. 3, along with the modified read_servers.sql and read_channel_privilege.sql in mysql_sql folder, plus full and tested instructions for installation? I can't believe they want to charge people for slots for commercial use of a program that doesn't even install right and comes with basically zero tech support. Please help!!!

**Roman777** · 15-01-2008, 10:20

My SW:

Server version: 5.0.32-Debian_7etch1-log Debian etch distribution

Linux debianpc 2.6.18-5-amd64 #1 SMP Thu May 31 23:51:05 UTC 2007 x86_64 GNU/Linux

ts2_server_rc2_20319

end of server.ini:

Code:

[DBEXPRESS]
sqldir=mysql_sql
Drivername=mysql
Database=teamspeak
Hostname=localhost
User_name=teamspeak
#Password=fweruvfsa7f3hjsjcvh9
Password=password
GetDriverFunc=getSQLDriverMYSQL
VendorLib=./libmysqlclient_r.so.10.0.0
LibraryName=./libsqlmy.so
Active=1

i try this:

Code:

mysql> USE mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> update user set password = old_password('password') where user = 'teamspeak'; flush privileges;
Query OK, 2 rows affected (0.01 sec)
Rows matched: 2  Changed: 2  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

i find and download on this forum libmysqlclient_r.so.10.0.0 and copy to dir of TS

on phpmyadmin a can login with user "teamspeak" with pass "password" and i see

Code:

 * Projít ts2_bans
    * Projít ts2_channels
    * Projít ts2_channel_privileges
    * Projít ts2_clients
    * Projít ts2_servers
    * Projít ts2_server_privileges

on log still :

Code:

15-01-08 11:12:22,ALL,Info,server,      Server init initialized
15-01-08 11:12:22,ALL,Info,server,      Server version: 2.0.23.19 Linux
15-01-08 11:12:22,ERROR,All,SQL,        Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
15-01-08 11:12:22,ERROR,All,SERVER,     Start_Server: unable to open database
----------------------------------------------------------

Where is problem pls?

**CloneVince** · 27-01-2008, 02:05

I have the same problem, can anyone help us plz ?

**MiCRoPhoBIC** · 30-01-2008, 23:01

Hi,

I Want to give some hints to people with problems with MySQL 4/5 and the following error:

27-01-08 17:42:51,ALL,Info,server, Server init initialized
27-01-08 17:42:51,ALL,Info,server, Server version: 2.0.23.19 Linux
27-01-08 17:42:51,ERROR,All,SQL, Database initialization error: EDatabaseError.DLL/Shared Library Name not Set
27-01-08 17:42:51,ERROR,All,SERVER, Start_Server: unable to open database

This is what I get when I tried to run it with MySQL instead of SQLite support. I'm using the current debian testing package (2.0.23.19-1: amd64) This error was so persistent. I tried downgrading the mysql libs to 3.23.56-3: amd64 package from old sarge distro. I copied&pasted the additional MySQL config (the [DBEXPRESS] part of config) from some thread in this forum. After that I tried everything here, changing localhost, short passwords, putting libraries to different dirs. And finaly found my problem. The example config that I've got had a hard to spot typo:

[DBEXPRESS]
......
LibaryName=/usr/lib/teamspeak-server/libsqlmy.so
.....

Missing 'r' in name "LibraryName". This take me hours to find out. So, please if you have similar problems
with MySQL please check syntax very carefully. Don't just copy and paste other configs and change right part. Hope this helps someone ....

**Jikari** · 04-02-2008, 05:56

Originally Posted by Roman777

My SW:

Server version: 5.0.32-Debian_7etch1-log Debian etch distribution

Linux debianpc 2.6.18-5-amd64 #1 SMP Thu May 31 23:51:05 UTC 2007 x86_64 GNU/Linux

ts2_server_rc2_20319

end of server.ini:

Code:

[DBEXPRESS]
sqldir=mysql_sql
Drivername=mysql
Database=teamspeak
Hostname=localhost
User_name=teamspeak
#Password=fweruvfsa7f3hjsjcvh9
Password=password
GetDriverFunc=getSQLDriverMYSQL
VendorLib=./libmysqlclient_r.so.10.0.0
LibraryName=./libsqlmy.so
Active=1

i try this:

Code:

mysql> USE mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> update user set password = old_password('password') where user = 'teamspeak'; flush privileges;
Query OK, 2 rows affected (0.01 sec)
Rows matched: 2  Changed: 2  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

i find and download on this forum libmysqlclient_r.so.10.0.0 and copy to dir of TS

on phpmyadmin a can login with user "teamspeak" with pass "password" and i see

Code:

 * Projít ts2_bans
    * Projít ts2_channels
    * Projít ts2_channel_privileges
    * Projít ts2_clients
    * Projít ts2_servers
    * Projít ts2_server_privileges

on log still :

Code:

15-01-08 11:12:22,ALL,Info,server,      Server init initialized
15-01-08 11:12:22,ALL,Info,server,      Server version: 2.0.23.19 Linux
15-01-08 11:12:22,ERROR,All,SQL,        Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
15-01-08 11:12:22,ERROR,All,SERVER,     Start_Server: unable to open database
----------------------------------------------------------

Where is problem pls?

I am having an identical problem on the exact same OS

**half_cpc** · 20-02-2008, 13:32

Same error here and i try with lib mysql:

libmysqlclient.so.10
libmysqlclient.so.12
libmysqlclient.so.14
libmysqlclient.so.15

Resume :

OS : uname -r

Linux *************** 2.6.18-xenU #3 SMP Thu Jan 10 15:56:11 CET 2008 i686 GNU/Linux

MYSQL version : mysql --version

mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2

Conf server : server.ini

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

Connection mysql : sudo -u teamspeak mysql -u teamspeak -h localhost teamspeak -p

Enter password: toto
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 266
Server version: 5.0.32-Debian_7etch4-log Debian etch distribution

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

mysql>

Launching teamspeak : sudo -u teamspeak /home/teamspeak/tss2_rc2/teamspeak2-server_startscript start

starting the teamspeak2 server
Error starting daemon. Aborted

***in server.log ***
---------------------------------------------------------------
-------------- log started at 20-02-08 14:27 -------------
---------------------------------------------------------------
20-02-08 14:27:27,ALL,Info,server, Server init initialized
20-02-08 14:27:27,ALL,Info,server, Server version: 2.0.23.19 Linux
20-02-08 14:27:27,ERROR,All,SQL, Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
20-02-08 14:27:27,ERROR,All,SERVER, Start_Server: unable to open database
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 20-02-08 14:27 --------------
---------------------------------------------------------------

**half_cpc** · 20-02-2008, 13:45

Ok i resolved issue by changing password hash

Code:

SET PASSWORD FOR '<mysqluser>'@'<host>' = OLD_PASSWORD('<password>');

thanks to IceMatrix

**Socke** · 07-03-2008, 13:46

i've got it working so far too,

but changes in the config for virtual servers get lost. No matter if i set them in the webinterface or directly in the database. as soon as i restart the server or start the virtual-server (id2) it is set to the settings of id1 and of corse won't start.

any solutions?

**messiah** · 24-03-2008, 20:36

Hello,

My problem is:

---------------------------------------------------------------
-------------- log started at 24-03-08 22:33 -------------
---------------------------------------------------------------
24-03-08 22:33:20,ALL,Info,server, Server init initialized
24-03-08 22:33:20,ALL,Info,server, Server version: 2.0.24.1 Linux
24-03-08 22:33:20,ERROR,All,SQL, SQL file not found mysql_sql/read_servers.sql
24-03-08 22:33:20,ERROR,All,SQL, SQL file not found mysql_sql/new_server.sql
24-03-08 22:33:20,ERROR,All,SQL, SQL file not found mysql_sql/read_server_privilege.sql
24-03-08 22:33:20,ERROR,All,SQL, SQL file not found mysql_sql/new_server_privilege.sql
[...]

(log cutted, there are more files missing)

Why are these files missing? I've downloaded latest archive from this site and I don't see them in mysql_sql dir, that's very odd

Here are contents of mysql_sql:

-rw-r--r-- 1 teamspeak root 396 2007-08-02 14:25 create_bans.sql
-rw-r--r-- 1 teamspeak root 520 2007-08-02 14:25 create_channel_privileges.sql
-rw-r--r-- 1 teamspeak root 835 2007-08-02 14:25 create_channels.sql
-rw-r--r-- 1 teamspeak root 588 2007-08-02 14:25 create_clients.sql
-rw-r--r-- 1 teamspeak root 3706 2007-08-02 14:25 create_server_privileges.sql
-rw-r--r-- 1 teamspeak root 1504 2007-08-02 14:25 create_servers.sql

EDIT
Found possible solution here: http://forum.teamspeak.com/showthread.php?t=40814
and here: http://forum.goteamspeak.com/showthread.php?t=33504

Some notes to everybody:
1. Don't try to use mysql client libraries newer then mysql distribution version 3.x. Native dbExpress library (libsqlmy.so) supports ONLY 3.x (libmysqlclient.so.10)
2. You can use newer versions (even up to 5.x - libmysqlclient.so.15) with dbExpress linux driver 4.20 (http://www.crlab.com/dbx/download.html). Use it instead of libsqlmy.so.

Now I have a lot of strange problems with queries :|
OMG:
http://forum.teamspeak.com/showthread.php?t=24654
This is so freaking stupid

So far I can say, there is NO possible FREE solution to use latest mysql client/server with ts2...

**DeMiNe0** · 11-04-2008, 04:38

Yup, i've tried everything as well. Is there not a free alternative to the dbexpress? I dont feel like paying $100 to use TSS

**DaRkBoZ** · 12-04-2008, 16:53

I use mysql 5.0.32 with TSS + lib libmysqlclient_r.so.10.0.0 and it work just fine, put the lib in the TS home directory / fill the config file and it's done, you just have to watch out for the password because TSS need old_password encryption. For infos there is plenty of tutorial explaining this method in the forum look @ "TeamSpeak 2.x with MySQL 5.x (Tutorial)" in sticky

**AB2314** · 03-06-2008, 18:10

wrong topic

**smartino84** · 27-06-2008, 18:36

-------------- log started at 27-06-08 23:12 -------------
---------------------------------------------------------------
27-06-08 23:12:28,ALL,Info,server, Server init initialized
27-06-08 23:12:28,ALL,Info,server, Server version: 2.0.24.1 Linux
27-06-08 23:12:28,WARNING,Info,SQL, created table ts2_servers
27-06-08 23:12:28,WARNING,Info,SQL, created table ts2_server_privileges
27-06-08 23:12:28,WARNING,Info,SQL, created table ts2_channels
27-06-08 23:12:28,WARNING,Info,SQL, created table ts2_channel_privileges
27-06-08 23:12:28,WARNING,Info,SQL, created table ts2_clients
27-06-08 23:12:28,WARNING,Info,SQL, created table ts2_bans
27-06-08 23:12:28,ERROR,Info,server, EDatabaseError: dbExpress Error: Operation Not Supported
----------------------------------------------------------

Running on debian.. with mysql 4.1.10.

Please help me.

**MaZy.Ger** · 22-09-2008, 16:45

Hey guys,
got the same problems what most of u have.

ERROR,Info,server, EDatabaseError: dbExpress Error: Operation Not Supported
Still get this error nvm if i changed read_servers.sql too
It sux. Got Suse

EDIT:
OMG. Crazy. After 10 times tries its working. I dont know why. I have often changed read_servers.sql.. and now.. no errors.

Thread: TeamSpeak with MySQL > 4.0

Thread Tools

Rate This Thread

Display

sql files missing

same problem..

Thread Information

Users Browsing this Thread

Similar Threads

Howto: TeamSpeak 2.x mit MySQL-Server 5.x

Teamspeak Server with MySQL 5.0!!

Server will not remember

database problem

Posting Permissions