TeamSpeak with MySQL > 4.0

[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

[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

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