Page 1 of 2 12 LastLast
Results 1 to 25 of 27
  1. #1
    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
    How do I correct this? Where can I get the libsqlmy.so file?

    I'm using Centos 4.5 / mysql 4.1

  2. #2
    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

  3. #3
    Join Date
    Jan 2007
    Posts
    688
    Database is vbulletin integrated, so it didn't do anything.

  4. #4
    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.

  5. #5
    Join Date
    Jan 2007
    Posts
    688
    How do I get libmysqlclient and set it up correctly? Please explain

  6. #6
    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"

  7. #7
    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

  8. #8
    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.

  9. #9
    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

  10. #10
    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.

  11. #11
    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 --------------
    ---------------------------------------------------------------

  12. #12
    In your TS ini Change sqldir=mysql_sql to sqldir=mysql_sql/
    Last edited by AClarkTXTS; 08-30-2007 at 01:49 PM.

  13. #13
    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

  14. #14
    delete the mysql database and recreate it and try again.

  15. #15
    Join Date
    Jan 2007
    Posts
    688
    Same error

  16. #16
    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.

  17. #17
    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

  18. #18
    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

  19. #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/

  20. #20
    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

  21. #21
    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"

  22. #22
    So when you start it with root its running with no errors? but you cannot access the server?

  23. #23
    Join Date
    Jan 2007
    Posts
    688
    Yes, works in root mode as I said before but not user mode

  24. #24
    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

  25. #25
    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" ?

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •