TeamSpeak with MySQL > 4.0

[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:

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]

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

[novazur]

Hi,

First, sorry for my bad english plz.

I tried several times to make my TS working with mysql 4.1 but never had it.
I use gentoo.
It worked very well with mysql 4.0, but, after upgrading mysql, I'm not able to connect to mysql :
09-11-05 01:58:09,ALL,Info,server, Server init initialized
09-11-05 01:58:09,ALL,Info,server, Server version: 2.0.20.1 Linux
09-11-05 01:58:09,ERROR,All,SQL, Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
09-11-05 01:58:09,ERROR,All,SERVER, Start_Server: unable to open database

I didn't change anything to mysql tables, and teamspeak user in mysql.

I searched here for a solution, tried with all tricks :
# cat mysql_sql/read_channel_privilege.sql
select * from ts2_channel_privileges where i_cp_server_id = :iServerID and i_cp_channel_id = :iChannelID and i_cp_client_id = :iClientID

(in one line)

# cat mysql_sql/read_servers.sql
select * from ts2_servers WHERE i_server_id > 0;

as indicated here http://forum.goteamspeak.com/showthread.php?p=114582#post114582

my server.ini :
[DBEXPRESS]
sqldir=/opt/teamspeak2-server/mysql_sql/
Drivername=mysql
Database=teamspeak
Hostname=localhost
User_name=teamspeak
Password=******
GetDriverFunc=getSQLDriverMYSQL
VendorLib=/usr/lib/libmysqlclient_r.so.10.0.0
LibraryName=/opt/teamspeak2-server/libsqlmy.so
Active=1

# ls -l /usr/lib/libmysqlclient_r.so.10.0.0
-rwxr-xr-x 1 root root 198920 jan 29 2003 /usr/lib/libmysqlclient_r.so.10.0.0

# ls -l /opt/teamspeak2-server/libsqlmy.so
-rwxr-xr-x 1 teamspeak nogroup 131736 mar 30 2005 /opt/teamspeak2-server/libsqlmy.so

Is it really possible to make TS work with mysql 4.1 ?

Thanks for all help, but very simples words plz (or french ? ;-) ).

[Tenkawa]

You shouldnt have to make any sql changes. I have run TS on 4.0, 4.1, and currently on 5.0 with no problems or sql changes. As long as you have the old mysql3 library it should work fine.

[novazur]

So, I don't understand why it doesn't work.

If it worked well with mysql 4.0, that shows I use the correct librairy, no ?

[Tenkawa]

Have you tried connecting to Mysql through the commandline with those settings?

[novazur]

Yes, no problem at all :

# mysql -hlocalhost -uteamspeak -p*******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 683 to server version: 4.1.14-log

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

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

Connection id: 684
Current database: teamspeak

mysql> show tables;
+------------------------+
| Tables_in_teamspeak |
+------------------------+
| ts2_bans |
| ts2_channel_privileges |
| ts2_channels |
| ts2_clients |
| ts2_server_privileges |
| ts2_servers |
+------------------------+
6 rows in set (0.00 sec)

mysql>

<edit>
I have it working.
I had to change mysql teamspeak password with old_password() function.
</edit>

[Tenkawa]

Interesting. It almost seems like it is still using the wrong mysql library

[Tenkawa]

You might also want to double check if thats the newest pre-4.0 mysql client library. Mine has a much newer date than yours from your output earlier. If you are using Debian the package I am using is
libmysqlclient 3.23.56-3

[novazur]

I also compiled again mysql-3.23.58-r1, to have a new libmysqlclient_r.so.10.0.0, but I didn't work only with that change. But I always used the oldder libmysqlclient_r.so.10.0.0 with mysql 4.0 and it always worked.

As I said first, I use gentoo, and for my first use of teamspeak with it, I took libmysqlclient_r.so.10.0.0 from a rpm package I had with my old mandrake.

As I said in my last edit, the last change I done is to change mysql teamspeak password with old_password() function.
And now it works, but I don't really understand why because I use :
old_passwords=1
in my /etc/mysql/my.cnf
and it works fine with others applications...

[Tenkawa]

oh yeah.. I shouldve mentioned I have old_passwords set

[novazur]

I also have it but obviously it is not sufficient

[siepel]

try putting the libmysqlclient_r.so.10 in the same dir:


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


That with the changed sql files.

Also note, if u made users thru phpmyadmin, that does not seem to work all the time. With Debian unstable, the current phpmyadmin version does not support the new method of adding mysql users to the mysql version packed with debian unstable.

Try adding them on the command line.

Frank and i encountered that problem. We fixed it by straight commands in mysql.

[to10]

Hatte den gleichen Fehler
Meine Lösung unter Linux :

Ich habe den Hostname von localhost auf 127.0.0.1 geändert

Hostname=127.0.0.1


Mysql 4.0.25-r2
libmysqlclient.so.10.0.0 von :

http://www.pack-eis.de/index.php?p=libmysql-shared

[Pasci]

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:

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]

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

Thanks for your tips - now on OpenSuSE 10 TS2 works fine!

[donnti]

Will you please sticky this as it would of saved me a lot of time

My server is working just fine so far.

[Beelooo]

Hi everyone, and sorry for my poor english...

My TS server wont start. I'm under Fedora 4 with Mysql 4.1.

Here is my server.ini :

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


And there is the log file:

---------------------------------------------------------------
-------------- log started at 25-06-06 12:43 -------------
---------------------------------------------------------------
25-06-06 12:43:28,ALL,Info,server, Server init initialized
25-06-06 12:43:28,ALL,Info,server, Server version: 2.0.20.1 Linux
25-06-06 12:43:28,WARNING,Info,SQL, created table ts2_servers
25-06-06 12:43:29,WARNING,Info,SQL, created table ts2_server_privileges
25-06-06 12:43:29,WARNING,Info,SQL, created table ts2_channels
25-06-06 12:43:29,WARNING,Info,SQL, created table ts2_channel_privileges
25-06-06 12:43:29,WARNING,Info,SQL, created table ts2_clients
25-06-06 12:43:29,WARNING,Info,SQL, created table ts2_bans
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 25-06-06 12:43 --------------
---------------------------------------------------------------
25-06-06 12:43:29,ERROR,Info,server, EDatabaseError: dbExpress Error: Operation Not Supported


Everytime i start the server, i'v the same error "EDatabaseError: dbExpress Error: Operation Not Supported" . I try to modify the "read_servers.sql", but i dont work anymore.

Got an idea ?

[Mcfly91]

I would like to give many many many thanks to all !!!, after reading this post i was able to start TS with MySQL !!!
For info, the server in the .ini file is set to localhost...

Best regards :cool:

[Spooky]

sorry for my bad english, but i've no idea what i have to do. here some logs:

22-08-06 14:53:20,ALL,Info,server, Server init initialized
22-08-06 14:53:20,ALL,Info,server, Server version: 2.0.23.2 Linux
22-08-06 14:53:20,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load /usr/lib/libmysqlclient_r.so.14.0.0
22-08-06 14:53:20,ERROR,All,SERVER, Start_Server: unable to open database

i'm not sure that the libmysqlclient is the correct one. it is possible to use
ts2 with this version?

and what i have to do?

i'm confused :eek:

please help

[fauvi]

I had the same issue and all I had to do was to change the Hostname=localhost to Hostname=<real hostname or ip>

[zionahead]

I deleted the entire directory and redownloaded / unapcked TS and the shared mysql library files.


root@server [/home/teamspeak/public_html/teamspeak]# chown teamspeak:teamspeak * -R

root@server [/home/teamspeak/public_html/teamspeak]# ls -lh
total 1.8M
drwxr-xr-x 9 1002 users 4.0K Aug 29 14:33 ./
drwxr-xr-x 4 teamspeak teamspeak 4.0K Aug 29 14:31 ../
-rw-r--r-- 1 teamspeak teamspeak 7 Aug 29 14:32 bad_names.txt
drwxr-xr-x 4 teamspeak teamspeak 4.0K Aug 2 12:57 httpdocs/
-rw-r--r-- 1 teamspeak teamspeak 2.6K Aug 2 07:07 INSTALL
-rw-r--r-- 1 teamspeak teamspeak 3.1K Aug 2 06:38 INSTALL.mysql
-rw-r--r-- 1 teamspeak teamspeak 232K Jul 8 2004 libmysql-shared.tar.gz
-rw-r--r-- 1 teamspeak teamspeak 229K Mar 9 2004 libsqlmy.so
-rw-r--r-- 1 teamspeak teamspeak 21K Aug 2 06:38 LICENSE
drwxr-xr-x 2 teamspeak teamspeak 4.0K Mar 9 2004 Manual/
-rw-r--r-- 1 teamspeak teamspeak 353 Mar 9 2004 manual.html
drwx------ 2 teamspeak teamspeak 4.0K Aug 2 06:25 mysql_sql/
-rw-r--r-- 1 teamspeak teamspeak 3.9K Aug 2 06:49 README
-rw-r--r-- 1 teamspeak teamspeak 20K Aug 29 14:32 server.dbs
-rw-r--r-- 1 teamspeak teamspeak 533 Aug 29 14:32 server.ini
-rwxr--r-- 1 teamspeak teamspeak 927K Aug 2 06:50 server_linux*
-rw-r--r-- 1 teamspeak teamspeak 1.7K Aug 29 14:33 server.log
-rw-r--r-- 1 teamspeak teamspeak 247K Mar 9 2004 sqlite.so
drwx------ 2 teamspeak teamspeak 4.0K Aug 2 06:25 sqlite_sql/
drwxr-xr-x 2 teamspeak teamspeak 4.0K Mar 9 2004 tcpquerydocs/
-rwxr-xr-x 1 teamspeak teamspeak 2.5K Mar 9 2004 teamspeak2-server_startscript*
drwxr-xr-x 3 teamspeak teamspeak 4.0K Jul 8 2004 tmp/
drwxr-xr-x 3 teamspeak teamspeak 4.0K Mar 8 2004 var/
-rw-r--r-- 1 teamspeak teamspeak 0 Aug 29 14:32 whitelist.txt

root@server [/home/teamspeak/public_html/teamspeak]# su teamspeak
teamspeak@server [~/public_html/teamspeak]# ./teamspeak2-server_startscript start
starting the teamspeak2 server
Error starting daemon. Aborted
teamspeak@server [~/public_html/teamspeak]# exit
exit

root@server [/home/teamspeak/public_html/teamspeak]# ./teamspeak2-server_startscript start
WARNING ! For security reasons we advise: DO NOT RUN THE SERVER AS ROOT
!!!!!!!!!!!
starting the teamspeak2 server
TeamSpeak Server Daemon started with PID 2959

root@server [/home/teamspeak/public_html/teamspeak]# ./teamspeak2-server_startscript stop
stopping the teamspeak2 server....done


root@server [/home/teamspeak/public_html/teamspeak]# wget http://romstadt.net/eisfair/libmysql-shared.tar.gz
--14:31:29-- http://romstadt.net/eisfair/libmysql-shared.tar.gz
=> `libmysql-shared.tar.gz'
Resolving romstadt.net... 192.67.198.52
Connecting to romstadt.net|192.67.198.52|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 236,926 (231K) [application/x-tar]

100%[================================================== ======================================>] 236,926 167.94K/s

14:31:31 (167.39 KB/s) - `libmysql-shared.tar.gz' saved [236926/236926]

root@server [/home/teamspeak/public_html/teamspeak]# tar -xvzf libmysql-shared.tar.gz
tmp/
tmp/install.sh
tmp/preinstall.sh
tmp/libmysql-shared/
tmp/libmysql-shared/libmysqlclient.so.10.0.0
tmp/libmysql-shared/libmysqlclient_r.so.10.0.0
var/
var/install/
var/install/deinstall/
var/install/deinstall/libmysql-shared
var/install/packages/
var/install/packages/libmysql-shared


As you suggested....


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


teamspeak@server [~/public_html/teamspeak]# ./teamspeak2-server_startscript start
starting the teamspeak2 server
File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Character set '#48' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file
File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Character set '#48' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file
File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Character set '#48' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file
File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Character set '#48' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file
File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Character set '#48' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file
File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Character set '#48' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file
File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Character set '#48' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index' file
Error starting daemon. Aborted




---------------------------------------------------------------
-------------- log started at 29-08-07 14:38 -------------
---------------------------------------------------------------
29-08-07 14:38:29,ALL,Info,server, Server init initialized
29-08-07 14:38:29,ALL,Info,server, Server version: 2.0.23.19 Linux
29-08-07 14:38:30,ERROR,All,SQL, SQL file not found mysql_sqlread_servers.sql
29-08-07 14:38:30,ERROR,All,SQL, SQL file not found mysql_sqlnew_server.sql
29-08-07 14:38:30,ERROR,All,SQL, SQL file not found mysql_sqlread_server_privilege.sql
29-08-07 14:38:30,ERROR,All,SQL, SQL file not found mysql_sqlnew_server_privilege.sql
29-08-07 14:38:30,ERROR,All,SQL, SQL file not found mysql_sqlread_server_privilege.sql
29-08-07 14:38:30,ERROR,All,SQL, SQL file not found mysql_sqlnew_server_privilege.sql
29-08-07 14:38:30,ERROR,All,SQL, SQL file not found mysql_sqlread_server_privilege.sql
29-08-07 14:38:30,ERROR,All,SQL, SQL file not found mysql_sqlnew_server_privilege.sql
29-08-07 14:38:30,ERROR,All,SQL, SQL file not found mysql_sqlread_server_privilege.sql
29-08-07 14:38:30,ERROR,All,SQL, SQL file not found mysql_sqlnew_server_privilege.sql
29-08-07 14:38:30,ERROR,All,SQL, SQL file not found mysql_sqlread_server_privilege.sql
29-08-07 14:38:30,ERROR,All,SQL, SQL file not found mysql_sqlnew_server_privilege.sql
29-08-07 14:38:30,ERROR,All,SQL, SQL file not found mysql_sqlread_server_privilege.sql
29-08-07 14:38:30,ERROR,All,SQL, SQL file not found mysql_sqlnew_server_privilege.sql
29-08-07 14:38:30,ALL,Info,server, Starting VirtualServer id:0 with port:8767
29-08-07 14:38:30,ERROR,All,SQL, SQL file not found mysql_sqledit_server.sql
29-08-07 14:38:30,ERROR,All,SQL, SQL file not found mysql_sqlread_channels.sql
29-08-07 14:38:30,ERROR,All,SQL, SQL file not found mysql_sqlnew_channel.sql
29-08-07 14:38:30,ERROR,All,SQL, SQL file not found mysql_sqlread_bans.sql
29-08-07 14:38:30,ALL,Info,server, Started VirtualServer id:0 with port:8767
29-08-07 14:38:30,WARNING,Info,SERVER, Default VirtualServer created
29-08-07 14:38:30,ERROR,All,SQL, SQL file not found mysql_sqlread_clients_name.sql
29-08-07 14:38:30,ERROR,All,SQL, SQL file not found mysql_sqlnew_client.sql
29-08-07 14:38:30,WARNING,Info,SERVER, admin account info: username: admin password: vnomk1
29-08-07 14:38:30,ERROR,All,SQL, SQL file not found mysql_sqlread_clients_name.sql
29-08-07 14:38:30,ERROR,All,SQL, SQL file not found mysql_sqlnew_client.sql
29-08-07 14:38:30,WARNING,Info,SERVER, superadmin account info: username: superadmin password: 44u1p9
29-08-07 14:38:31,ALL,Info,server, Server init finished
29-08-07 14:38:31,ERROR,Info,server, Unable to createpid file, stopping daemon
29-08-07 14:38:31,ALL,Info,server, Server shutdown initialized
29-08-07 14:38:31,ALL,Info,server, Stopping VirtualServer id:0 with port:8767
29-08-07 14:38:31,ALL,Info,server, Stopped VirtualServer id:0 with port:8767
29-08-07 14:38:34,ALL,Info,server, Server shutdown finished
---------------------------------------------------------------
--------------- log ended at 29-08-07 14:38 --------------
---------------------------------------------------------------
----------------------------------------------------------

[zionahead]

I get this now

---------------------------------------------------------------
-------------- log started at 30-08-07 14:42 -------------
---------------------------------------------------------------
30-08-07 14:42:30,ALL,Info,server, Server init initialized
30-08-07 14:42:30,ALL,Info,server, Server version: 2.0.23.19 Linux
30-08-07 14:42:31,ERROR,Info,server, EDatabaseError: dbExpress Error: Operation Not Supported
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 30-08-07 14:42 --------------
---------------------------------------------------------------


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



teamspeak@server [~/public_html/teamspeak/mysql_sql]# ls
./ delete_channel.sql new_server_privilege.sql read_server_port.sql
../ delete_client.sql new_server.sql read_server_privilege.sql
create_bans.sql delete_server.sql read_active_servers.sql read_server.sql
create_channel_privileges.sql edit_channel_privilege.sql read_bans.sql read_servers.sql
create_channels.sql edit_channel.sql read_channel_privilege.sql remove_bans.sql
create_clients.sql edit_client_lastonline.sql read_channel_privileges.sql remove_moderatedattribs.sql
create_nicks.sql edit_client.sql read_channel.sql search_client.sql
create_server_privileges.sql edit_server_privilege.sql read_channels.sql upgrade_1.sql
create_servers.sql edit_server.sql read_client_channels_privileges.sql upgrade_2.sql
create_settings.sql new_ban.sql read_client_login.sql upgrade_3.sql
delete_ban_ip.sql new_channel_privilege.sql read_clients_id.sql
delete_ban.sql new_channel.sql read_clients_name.sql
delete_channel_privilege.sql new_client.sql read_clients.sql

[maxi1990]

Read the first post of this thread ;)

[zionahead]

Getting closer


---------------------------------------------------------------
-------------- log started at 30-08-07 14:58 -------------
---------------------------------------------------------------
30-08-07 14:58:54,ALL,Info,server, Server init initialized
30-08-07 14:58:54,ALL,Info,server, Server version: 2.0.23.19 Linux
30-08-07 14:58:54,ERROR,All,SERVER, VirtualServer Startup(1) Exception: EDatabaseError.dbExpress Error: Operation Not Supported
30-08-07 14:58:54,ALL,Info,server, Server init finished
30-08-07 14:58:54,ERROR,Info,server, Unable to createpid file, stopping daemon
30-08-07 14:58:54,ALL,Info,server, Server shutdown initialized
30-08-07 14:58:54,ALL,Info,server, Stopping VirtualServer id:0 with port:8767
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 30-08-07 14:59 --------------
---------------------------------------------------------------

File: read_servers.sql

SELECT * FROM ts2_servers WHERE i_server_id > 0;

[zionahead]

I tried starting it in root user mode, it works just not in teamspeak user mode

[maxi1990]

do as root:
chown -R [user] [path to tss] For EXAMPLE: chown -R ts /home/ts

And then try to start the server with your ts user.

[zionahead]

That was already done before

[maxi1990]

That was already done before

Try chown -R [user]:users [path]
Example: chown -R ts:users /home/ts

[zionahead]

I am able to start in usermode, but now I get this error

http://xxx.xxx.xxx.xxx:14534/login.tscmd

Page not found *after* I input the default login details found in README. The main web page shows up with login form. Once I input the default info, it shows page not found.

Firewall shows this

tcp_in
20,21,25,53,80,110,143,443,465,953,993,995,2083,20 87,2096,2250,8767,10055,14534,51234

tcp_out
20,21,22,25,37,43,53,80,110,113,443,587,873,953,20 87,2089,2703,8767,14534,51234

udp_in
20,21,53,953

udp_out
20,21,53,113,123,873,953,6277

[BHKai]

The page should be login.html not login.tscmd

[zionahead]

It is redirecting to that link and showing page not found.

I purposely go to the login

http://xxx.xxx.xxx.xxx:14534 and input my login details

[zionahead]

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]

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:

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]

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]

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:

[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:
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
* 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 :

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]

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

[MiCRoPhoBIC]

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]

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:

[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:
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
* 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 :

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]

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]

Ok i resolved issue by changing password hash

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

thanks to IceMatrix

[Socke]

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]

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 :confused:

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]

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]

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]

wrong topic

[smartino84]

-------------- 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]

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.

[Dutch2005]

---------------------------------------------------------------
21-05-09 15:48:56,ALL,Info,server, Server init initialized
21-05-09 15:48:56,ALL,Info,server, Server version: 2.0.24.1 Linux
21-05-09 15:48:56,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load ./home/evets/tss2_rc2/liblibmysqlclient_r.so.16.0.0
21-05-09 15:48:56,ERROR,All,SERVER, Start_Server: unable to open database
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 21-05-09 15:48 --------------
---------------------------------------------------------------
---------------------------------------------------------------
-------------- log started at 21-05-09 15:49 -------------
---------------------------------------------------------------
21-05-09 15:49:35,ALL,Info,server, Server init initialized
21-05-09 15:49:35,ALL,Info,server, Server version: 2.0.24.1 Linux
21-05-09 15:49:35,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load ./tss2_rc2/liblibmysqlclient_r.so.16.0.0
21-05-09 15:49:35,ERROR,All,SERVER, Start_Server: unable to open database
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 21-05-09 15:49 --------------
---------------------------------------------------------------


is what i got... i downloaded a compiles mysql 5.1 for all linux from mysql.com

suggestions?

[tgcsniper]

Im trying to setup ts with mysql.

Im using the mysql from my webhost which is: 5.0.67-community (linux)
The server im running ts on is windows based.

Im using this in the config:

[DBEXPRESS]
sqldir=mysql_sql/
Drivername=mysql
Database=ts
Hostname=93.174.***.53
User_name=*********
Password=************
GetDriverFunc=getSQLDriverMYSQL
VendorLib=C:\GameServers\Teamspeak2_RC2\libmysqlcl ient_r.so.10.0.0
LibraryName=C:\GameServers\Teamspeak2_RC2\libsqlmy .so
Active=1

But i keep getting this error:

---------------------------------------------------------------
17-10-06 01:01:31,ALL,Info,server, Server init initialized
17-10-06 01:01:31,ALL,Info,server, Server version: 2.0.23.19 Win32
17-10-06 01:01:31,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load libmysqlclient_r.so.10.0.0
17-10-06 01:01:31,ERROR,All,SERVER, Start_Server: unable to open database
17-10-06 01:01:31,ERROR,All,GENERAL, critical error, shutdown initiated
---------------------------------------------------------------

Can someone point me in the right direction please??? :)

[valantis]

My SW:

on phpmyadmin a can login with user "teamspeak" with pass "password" and i see
* 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 :

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?

same here any solution ?

thanks

[valantis]

---------------------------------------------------------------
21-05-09 15:48:56,ALL,Info,server, Server init initialized
21-05-09 15:48:56,ALL,Info,server, Server version: 2.0.24.1 Linux
21-05-09 15:48:56,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load ./home/evets/tss2_rc2/liblibmysqlclient_r.so.16.0.0
21-05-09 15:48:56,ERROR,All,SERVER, Start_Server: unable to open database
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 21-05-09 15:48 --------------
---------------------------------------------------------------
---------------------------------------------------------------
-------------- log started at 21-05-09 15:49 -------------
---------------------------------------------------------------
21-05-09 15:49:35,ALL,Info,server, Server init initialized
21-05-09 15:49:35,ALL,Info,server, Server version: 2.0.24.1 Linux
21-05-09 15:49:35,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load ./tss2_rc2/liblibmysqlclient_r.so.16.0.0
21-05-09 15:49:35,ERROR,All,SERVER, Start_Server: unable to open database
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 21-05-09 15:49 --------------
---------------------------------------------------------------


is what i got... i downloaded a compiles mysql 5.1 for all linux from mysql.com

suggestions?

do you find any solution? i have this problem too

[chaoskreator]

The problem I have with this is that it only seems to run on libmysqlclient10. My server has libmysqlclient15. I attempted to install 10, but there is one dependency that I can't overcome. Libmysqlclient10 requires postun_ldconfig, which is included in glibc. Which is required by everything else on the system.

Is there a way to utilize the libmysqlclient15, at all?

*EDIT* - You know, after re-reading this thread several times, I've come to the conclusion that tss2 will not work with MySQL 5.0.x or greater. And if anyone has been successful in their endeavors, they obviously do not wish to contribute a description to their fellow gamers.

[seriouz]

Hi Guys!

Is it still possible, to connect with the teamspeak-server to a mysql-database?