Results 1 to 25 of 27
Thread: cannot install teampseak
-
08-25-2007, 10:32 AM #1Web Hosting Master
- Join Date
- Jan 2007
- Posts
- 688
cannot install teampseak
Trying to setup Teamspeak
24-08-07 23:16:41,ALL,Info,server, Server init initialized
24-08-07 23:16:41,ALL,Info,server, Server version: 2.0.23.19 Linux
24-08-07 23:16:41,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load ./libmysqld.a
24-08-07 23:16:41,ERROR,All,SERVER, Start_Server: unable to open database
This is what I have (with actual db info)
Code:[DBEXPRESS] sqldir=/var/lib/mysql Drivername=mysql Database=database_name Hostname=localhost User_name=database_username Password=database_password GetDriverFunc=getSQLDriverMYSQL VendorLib=/usr/lib/libmysqlclient_r.so.14.0.0 LibraryName=./libmysqld.a Active=1
Code:root@server [/usr/lib]# ls *mysql* libmysqlclient_r.so@ libmysqlclient_r.so.14.0.0* libmysqlclient.so.14@ libmysqlclient.so.6@ libmysqlclient_r.so.14@ libmysqlclient.so@ libmysqlclient.so.14.0.0* mysql: ./ libheap.a libmyisam.a libmysqlclient.la* libmysqld.a libnisam.a libz.la* ../ libmerge.a libmyisammrg.a libmysqlclient_r.a libmystrings.a libvio.a mysqld.sym libdbug.a libmygcc.a libmysqlclient.a libmysqlclient_r.la* libmysys.a libz.a
I'm using Centos 4.5 / mysql 4.1
-
08-25-2007, 10:51 AM #2Web Hosting Master
- Join Date
- Oct 2004
- Location
- Kerala, India
- Posts
- 4,771
Was the mysql server running earlier and it broke after you tried to install the software?
David | www.cliffsupport.com
Affordable Server Management Solutions sales AT cliffsupport DOT com
CliffWebManager | Access WHM from iPhone and Android
-
08-25-2007, 11:00 AM #3Web Hosting Master
- Join Date
- Jan 2007
- Posts
- 688
Database is vbulletin integrated, so it didn't do anything.
-
08-26-2007, 02:42 PM #4Newbie
- Join Date
- Aug 2007
- Location
- Texas
- Posts
- 19
Try 127.0.0.1 instead of localhost. Also are you sure that the mysql username and password are correct?
I belive you also need libmysqlclient installed in the teamspeak server directory and thats likely where the missing files are.
-
08-26-2007, 02:47 PM #5Web Hosting Master
- Join Date
- Jan 2007
- Posts
- 688
How do I get libmysqlclient and set it up correctly? Please explain
-
08-26-2007, 03:20 PM #6Newbie
- Join Date
- Aug 2007
- Location
- Texas
- Posts
- 19
Not sure exactly how to do it on centos, but I would look for an rpm installer or just a archive for libmysqlclient_r.so.10.0.0 as the newer lib files don't work with Teamspeak.
libmysqlclient_r.so.10.0.0 should be a part of mysql 3.x client files. I cannot post links so just do this google search:
intitle:"index.of" "libmysqlclient_r.so.10.0.0"
-
08-29-2007, 07:42 PM #7Web Hosting Master
- Join Date
- Jan 2007
- Posts
- 688
I deleted the entire directory and redownloaded / unapcked TS and the shared mysql library files.
Code: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
Code: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
[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
Code: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
Code:--------------------------------------------------------------- -------------- 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: <<removed>> 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: <<removed>> 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 -------------- --------------------------------------------------------------- ----------------------------------------------------------
Last edited by bear; 08-29-2007 at 09:46 PM. Reason: removed (another) password
-
08-29-2007, 09:01 PM #8Newbie
- Join Date
- Aug 2007
- Location
- Texas
- Posts
- 19
Try this, copy libmysqlclient_r.so.10.0.0 to your Teamspeak Directory and change VendorLib to: VendorLib=./libmysqlclient.10.0.0
Also I think you need to change mysql password to use pre mysql 4.1 passwords
SET PASSWORD FOR 'tsuser'@'localhost' = OLD_PASSWORD('tspass');
If that does not work I would try MySQL 4.0 seems thats the version most people have success with.Last edited by AClarkTXTS; 08-29-2007 at 09:05 PM.
-
08-29-2007, 09:04 PM #9Web Hosting Master
- Join Date
- Jan 2007
- Posts
- 688
I cannot just downgrade my mysql version. Plus, their forums has tutorials for 4x and 5x mysql. I'm using 4.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
Error starting daemon. Aborted
[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
-
08-29-2007, 11:59 PM #10Newbie
- Join Date
- Aug 2007
- Location
- Texas
- Posts
- 19
Found this on bugs.mysql maybe worth a try:
Description:
When using a default install on Fedora Core 3 with a charset that is not compiled in, the
client gives the following warning, even if the file is indeed preset:
File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
Character set '#30' is not a compiled character set and is not specified in the
'/usr/share/mysql/charsets/Index' file
The problem is caused by:
a) The lack of an Index file
b) File extension being .xml while client looks for .xml.conf
Suggested fix:
My workaround was:
1) Create a file named "Index" under /usr/share/mysql/charsets that looks like this:
latin5.xml 30
2) To avoid extension problem, link the original latin5.xml file as latin5.xml.conf file.
cd /usr/share/mysql/charsets
ln -s latin5.xml latin5.xml.conf
This solved the problem, however, is only a workaround. I suggest to:
a) include the Index file in further distributions or move whole functionality to the
Index.xml file
b) Fix the file extension problem by making client look for the filename specified in
Index file, without appending an additional .conf extension.
-
08-30-2007, 12:54 PM #11Web Hosting Master
- Join Date
- Jan 2007
- Posts
- 688
This is not making any sense at all
I did this
touch Index
nano Index
Added:
latin5.xml 48
teamspeak@server [~/public_html/teamspeak]# ./teamspeak2-server_startscript start
starting the teamspeak2 server
Error starting daemon. Aborted
Logs
---------------------------------------------------------------
-------------- log started at 30-08-07 11:53 -------------
---------------------------------------------------------------
30-08-07 11:53:11,ALL,Info,server, Server init initialized
30-08-07 11:53:11,ALL,Info,server, Server version: 2.0.23.19 Linux
30-08-07 11:53:11,ERROR,All,SQL, SQL file not found mysql_sqlcreate_servers.sql
30-08-07 11:53:11,ERROR,All,SQL, unable to create table
30-08-07 11:53:11,ERROR,All,SERVER, Start_Server: unable to create tables
----------------------------------------------------------
---------------------------------------------------------------
--------------- log ended at 30-08-07 11:53 --------------
---------------------------------------------------------------
-
08-30-2007, 01:38 PM #12Newbie
- Join Date
- Aug 2007
- Location
- Texas
- Posts
- 19
In your TS ini Change sqldir=mysql_sql to sqldir=mysql_sql/
Last edited by AClarkTXTS; 08-30-2007 at 01:49 PM.
-
08-30-2007, 01:49 PM #13Web Hosting Master
- Join Date
- Jan 2007
- Posts
- 688
Now the server logs shows these errors after adding "/" to the ini file
Code:--------------------------------------------------------------- -------------- log started at 30-08-07 12:47 ------------- --------------------------------------------------------------- 30-08-07 12:47:49,ALL,Info,server, Server init initialized 30-08-07 12:47:49,ALL,Info,server, Server version: 2.0.23.19 Linux 30-08-07 12:47:49,WARNING,Info,SQL, created table ts2_servers 30-08-07 12:47:49,WARNING,Info,SQL, created table ts2_server_privileges 30-08-07 12:47:49,WARNING,Info,SQL, created table ts2_channels 30-08-07 12:47:49,WARNING,Info,SQL, created table ts2_channel_privileges 30-08-07 12:47:49,WARNING,Info,SQL, created table ts2_clients 30-08-07 12:47:49,WARNING,Info,SQL, created table ts2_bans 30-08-07 12:47:49,ERROR,All,SQL, SQL file not found mysql_sql/read_servers.sql 30-08-07 12:47:49,ERROR,All,SQL, OpenSQL Error: EDatabaseError.Table 'ts2_bans' already exists in query: CREATE TABLE `ts2_b$ `i_ban_id` int(8) NOT NULL auto_increment, `i_ban_server_id` int(8) default NULL, `s_ban_ip` varchar(16) default NULL, `s_ban_by` varchar(128) default NULL, `dt_ban_created` varchar(24) default NULL, `i_ban_minutes` int(8) default NULL, PRIMARY KEY (`i_ban_id`), KEY `i_ban_server_id` (`i_ban_server_id`), KEY `s_ban_ip` (`s_ban_ip`) ) ENGINE=MyISAM ; 30-08-07 12:47:49,ERROR,Info,server, EInvalidField: OpenSQL Error: EDatabaseError.Table 'ts2_bans' already exists in query: CREA$ `i_ban_id` int(8) NOT NULL auto_increment, `i_ban_server_id` int(8) default NULL, `s_ban_ip` varchar(16) default NULL, `s_ban_by` varchar(128) default NULL, `dt_ban_created` varchar(24) default NULL, `i_ban_minutes` int(8) default NULL, PRIMARY KEY (`i_ban_id`), KEY `i_ban_server_id` (`i_ban_server_id`), KEY `s_ban_ip` (`s_ban_ip`) ) ENGINE=MyISAM ; ---------------------------------------------------------- --------------------------------------------------------------- --------------- log ended at 30-08-07 12:47 -------------- ---------------------------------------------------------------
Code:teamspeak@server [~/public_html/teamspeak]# ls -lh total 2.0M drwxr-xr-x 9 1002 users 4.0K Aug 29 20:03 ./ 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 root root 226K Aug 29 20:03 libmysqlclient_r.so.10.0.0 -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:33 server.dbs -rw-r--r-- 1 teamspeak teamspeak 774 Aug 30 12:00 server.ini -rwxr--r-- 1 teamspeak teamspeak 927K Aug 2 06:50 server_linux* -rw-r--r-- 1 teamspeak teamspeak 15K Aug 30 12:00 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 teamspeak@server [~/public_html/teamspeak]# cd my* teamspeak@server [~/public_html/teamspeak/mysql_sql]# ls -lh total 32K drwx------ 2 teamspeak teamspeak 4.0K Aug 2 06:25 ./ drwxr-xr-x 9 1002 users 4.0K Aug 29 20:03 ../ -rw-r--r-- 1 teamspeak teamspeak 396 Aug 2 06:25 create_bans.sql -rw-r--r-- 1 teamspeak teamspeak 520 Aug 2 06:25 create_channel_privileges.sql -rw-r--r-- 1 teamspeak teamspeak 835 Aug 2 06:25 create_channels.sql -rw-r--r-- 1 teamspeak teamspeak 588 Aug 2 06:25 create_clients.sql -rw-r--r-- 1 teamspeak teamspeak 3.7K Aug 2 06:25 create_server_privileges.sql -rw-r--r-- 1 teamspeak teamspeak 1.5K Aug 2 06:25 create_servers.sql
-
08-30-2007, 01:51 PM #14Newbie
- Join Date
- Aug 2007
- Location
- Texas
- Posts
- 19
delete the mysql database and recreate it and try again.
-
08-30-2007, 01:54 PM #15Web Hosting Master
- Join Date
- Jan 2007
- Posts
- 688
Same error
-
08-30-2007, 02:17 PM #16Newbie
- Join Date
- Aug 2007
- Location
- Texas
- Posts
- 19
post your ini file again please. I see that the "read_servers.sql" file does exist in the "sqlite_sql" folder but not in the mysql_sql.
Try this: Backup the mysql_sql folder and place the contents of sqlite_sql folder in the mysql_sql folder and don't overwrite any of the existing mysql_sql files.
-
08-30-2007, 03:34 PM #17Web Hosting Master
- Join Date
- Jan 2007
- Posts
- 688
server.ini (db portion)
[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
I moved all files (not overwriting) from sqlite_sql to mysql_sql directory
---------------------------------------------------------------
-------------- log started at 30-08-07 14:31 -------------
---------------------------------------------------------------
30-08-07 14:31:55,ALL,Info,server, Server init initialized
30-08-07 14:31:55,ALL,Info,server, Server version: 2.0.23.19 Linux
30-08-07 14:31:55,ERROR,All,SQL, SQL file not found mysql_sqlread_servers.sql
30-08-07 14:31:55,ERROR,All,SQL, SQL file not found mysql_sqlnew_server.sql
30-08-07 14:31:55,ERROR,All,SQL, SQL file not found mysql_sqlread_server_privilege.sql
30-08-07 14:31:55,ERROR,All,SQL, SQL file not found mysql_sqlnew_server_privilege.sql
30-08-07 14:31:55,ERROR,All,SQL, SQL file not found mysql_sqlread_server_privilege.sql
30-08-07 14:31:55,ERROR,All,SQL, SQL file not found mysql_sqlnew_server_privilege.sql
30-08-07 14:31:55,ERROR,All,SQL, SQL file not found mysql_sqlread_server_privilege.sql
30-08-07 14:31:55,ERROR,All,SQL, SQL file not found mysql_sqlnew_server_privilege.sql
30-08-07 14:31:55,ERROR,All,SQL, SQL file not found mysql_sqlread_server_privilege.sql
30-08-07 14:31:55,ERROR,All,SQL, SQL file not found mysql_sqlnew_server_privilege.sql
30-08-07 14:31:55,ERROR,All,SQL, SQL file not found mysql_sqlread_server_privilege.sql
30-08-07 14:31:55,ERROR,All,SQL, SQL file not found mysql_sqlnew_server_privilege.sql
30-08-07 14:31:55,ERROR,All,SQL, SQL file not found mysql_sqlread_server_privilege.sql
30-08-07 14:31:55,ERROR,All,SQL, SQL file not found mysql_sqlnew_server_privilege.sql
30-08-07 14:31:55,ALL,Info,server, Starting VirtualServer id:0 with port:8767
30-08-07 14:31:55,ERROR,All,SQL, SQL file not found mysql_sqledit_server.sql
30-08-07 14:31:55,ERROR,All,SQL, SQL file not found mysql_sqlread_channels.sql
30-08-07 14:31:55,ERROR,All,SQL, SQL file not found mysql_sqlnew_channel.sql
30-08-07 14:31:55,ERROR,All,SQL, SQL file not found mysql_sqlread_bans.sql
30-08-07 14:31:55,ALL,Info,server, Started VirtualServer id:0 with port:8767
30-08-07 14:31:55,WARNING,Info,SERVER, Default VirtualServer created
30-08-07 14:31:55,ERROR,All,SQL, SQL file not found mysql_sqlread_clients_name.sql
30-08-07 14:31:55,ERROR,All,SQL, SQL file not found mysql_sqlnew_client.sql
30-08-07 14:31:55,WARNING,Info,SERVER, admin account info: username: admin password: <<removed>>
30-08-07 14:31:55,ERROR,All,SQL, SQL file not found mysql_sqlread_clients_name.sql
30-08-07 14:31:55,ERROR,All,SQL, SQL file not found mysql_sqlnew_client.sql
30-08-07 14:31:55,WARNING,Info,SERVER, superadmin account info: username: superadmin password: <<removed>>
30-08-07 14:31:56,ALL,Info,server, Server init finished
30-08-07 14:31:56,ERROR,Info,server, Unable to createpid file, stopping daemon
30-08-07 14:31:56,ALL,Info,server, Server shutdown initialized
30-08-07 14:31:56,ALL,Info,server, Stopping VirtualServer id:0 with port:8767
30-08-07 14:31:56,ALL,Info,server, Stopped VirtualServer id:0 with port:8767
30-08-07 14:31:59,ALL,Info,server, Server shutdown finished
---------------------------------------------------------------
--------------- log ended at 30-08-07 14:31 --------------
---------------------------------------------------------------Last edited by bear; 08-30-2007 at 08:31 PM. Reason: Removed passwords again
-
08-30-2007, 03:45 PM #18Web Hosting Master
- Join Date
- Jan 2007
- Posts
- 688
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
Code: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
-
08-30-2007, 04:39 PM #19Newbie
- Join Date
- Aug 2007
- Location
- Texas
- Posts
- 19
OK this is why teamspeak says mysql is experimental.
Start fresh with the new 2.0.23.22 it already has the sql files in the proper folders and there have been some mysql fixes since 2.0.23.19. Use the same ini settings and libmysqlclient_r.so.10.0.0.
http://forum.teamspeak.com/showthread.php?t=38801
direct link: ftp://ftp.freenet.de/pub/4players/te...server/202322/
-
08-30-2007, 04:43 PM #20Web Hosting Master
- Join Date
- Jan 2007
- Posts
- 688
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;
I tried starting it in root user mode, it works just not in teamspeak user mode
-
08-30-2007, 04:46 PM #21Web Hosting Master
- Join Date
- Jan 2007
- Posts
- 688
I also cannot pull up the admin interface
http://myip:14534/
CSF firewall config:
# Allow incoming TCP ports
TCP_IN = "20,21,25,53,80,110,143,443,465,953,993,995,2083,2087,2096,2250,8767,10055,14534,51234"
# Allow outgoing TCP ports
TCP_OUT = "20,21,22,25,37,43,53,80,110,113,443,587,873,953,2087,2089,2703,8767,14534,51234"
# Allow incoming UDP ports
UDP_IN = "20,21,53,953"
# Allow outgoing UDP ports
# To allow outgoing traceroute add 33434:33523 to this list
UDP_OUT = "20,21,53,113,123,873,953,6277"
-
08-30-2007, 05:18 PM #22Newbie
- Join Date
- Aug 2007
- Location
- Texas
- Posts
- 19
So when you start it with root its running with no errors? but you cannot access the server?
-
09-03-2007, 03:37 PM #23Web Hosting Master
- Join Date
- Jan 2007
- Posts
- 688
Yes, works in root mode as I said before but not user mode
-
09-05-2007, 04:27 PM #24Web Hosting Master
- Join Date
- Jan 2007
- Posts
- 688
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.
The admin user to login to TS web interface is "admin". However, the owner of the teamspeak directory is "teamspeak" just as the document suggested to do.
chown teamspeak:teamspeak teamspeak -R
I did that. "teamspeak" is the name of the directory
Code:root@server [/home/teamspeak/public_html/teamspeak]# ls -lh total 4.5M drwxr-xr-x 9 teamspeak teamspeak 4.0K Sep 4 13:46 ./ 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 -rw------- 1 teamspeak teamspeak 13M Sep 4 13:46 core.13488 -rw------- 1 teamspeak teamspeak 13M Sep 3 20:30 core.20075 -rw------- 1 teamspeak teamspeak 11M Aug 30 15:16 core.2313 -rw------- 1 teamspeak teamspeak 11M Aug 30 15:00 core.450 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 226K Aug 29 20:03 libmysqlclient_r.so.10.0.0 -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 30 14:30 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:33 server.dbs -rw-r--r-- 1 teamspeak teamspeak 775 Sep 4 13:44 server.ini -rwxr--r-- 1 teamspeak teamspeak 927K Aug 2 06:50 server_linux* -rw-r--r-- 1 teamspeak teamspeak 696 Sep 4 13:44 server.log -rw-r--r-- 1 teamspeak teamspeak 247K Mar 9 2004 sqlite.so drwx------ 2 teamspeak teamspeak 4.0K Aug 30 14:30 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/ -rw------- 1 teamspeak teamspeak 5 Sep 4 13:44 tsserver2.pid 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
-
09-06-2007, 10:47 AM #25Newbie
- Join Date
- Aug 2007
- Location
- Texas
- Posts
- 19
The admin login for your server is not going to be in the readme it should be at the begining of the server.log. What happens when you run "telnet xxx.xxx.xxx.xxx:51234" ?