Portal Home > Knowledgebase > Articles Database > cannot install teampseak
Posted by Calibaba, 08-25-2007, 10:32 AM 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) How do I correct this? Where can I get the libsqlmy.so file? I'm using Centos 4.5 / mysql 4.1
Posted by david510, 08-25-2007, 10:51 AM Was the mysql server running earlier and it broke after you tried to install the software?
Posted by Calibaba, 08-25-2007, 11:00 AM Database is vbulletin integrated, so it didn't do anything.
Posted by AClarkTXTS, 08-26-2007, 02:42 PM 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.
Posted by Calibaba, 08-26-2007, 02:47 PM How do I get libmysqlclient and set it up correctly? Please explain
Posted by AClarkTXTS, 08-26-2007, 03:20 PM 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"
Posted by Calibaba, 08-29-2007, 07:42 PM I deleted the entire directory and redownloaded / unapcked TS and the shared mysql library files. [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 Last edited by bear; 08-29-2007 at 09:46 PM. Reason: removed (another) password
Posted by AClarkTXTS, 08-29-2007, 09:01 PM 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.
Posted by Calibaba, 08-29-2007, 09:04 PM 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
Posted by AClarkTXTS, 08-29-2007, 11:59 PM 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.
Posted by Calibaba, 08-30-2007, 12:54 PM 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 -------------- ---------------------------------------------------------------
Posted by AClarkTXTS, 08-30-2007, 01:38 PM In your TS ini Change sqldir=mysql_sql to sqldir=mysql_sql/ Last edited by AClarkTXTS; 08-30-2007 at 01:49 PM.
Posted by Calibaba, 08-30-2007, 01:49 PM Now the server logs shows these errors after adding "/" to the ini file
Posted by AClarkTXTS, 08-30-2007, 01:51 PM delete the mysql database and recreate it and try again.
Posted by Calibaba, 08-30-2007, 01:54 PM Same error
Posted by AClarkTXTS, 08-30-2007, 02:17 PM 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.
Posted by Calibaba, 08-30-2007, 03:34 PM 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: < > 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: < > 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
Posted by Calibaba, 08-30-2007, 03:45 PM 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
Posted by AClarkTXTS, 08-30-2007, 04:39 PM 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/
Posted by Calibaba, 08-30-2007, 04:43 PM 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
Posted by Calibaba, 08-30-2007, 04:46 PM 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"
Posted by AClarkTXTS, 08-30-2007, 05:18 PM So when you start it with root its running with no errors? but you cannot access the server?
Posted by Calibaba, 09-03-2007, 03:37 PM Yes, works in root mode as I said before but not user mode
Posted by Calibaba, 09-05-2007, 04:27 PM 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
Posted by AClarkTXTS, 09-06-2007, 10:47 AM 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" ?
Posted by Calibaba, 09-06-2007, 10:55 AM How can you tell me it won't be in the readme when I'm looking at the original readme right that tells me the link to login with and the admin user/pw to login with?
Posted by AClarkTXTS, 09-06-2007, 11:00 AM Maybe you missed it this is from the README Last edited by AClarkTXTS; 09-06-2007 at 11:05 AM.
Add to Favourites 
Print this Article
