Forum

Page 2 of 4 FirstFirst 1234 LastLast
Results 16 to 30 of 51
  1. #16
    Join Date
    June 2006
    Location
    France
    Posts
    1

    dbExpress Error

    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 :

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

    Code:
    ---------------------------------------------------------------
    -------------- 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 ?

  2. #17
    Join Date
    June 2006
    Location
    France
    Posts
    7

    Thumbs up

    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

  3. #18
    Join Date
    June 2006
    Location
    Germany
    Posts
    13

    Unhappy

    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

  4. #19
    Join Date
    December 2006
    Location
    Canada
    Posts
    3

    Got it working

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

  5. #20
    Join Date
    August 2007
    Location
    USA
    Posts
    25
    I deleted the entire directory and redownloaded / unapcked TS and the shared mysql library files.


    Code:
    [email protected] [/home/teamspeak/public_html/teamspeak]# chown teamspeak:teamspeak * -R
    
    [email protected] [/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
    
    [email protected] [/home/teamspeak/public_html/teamspeak]# su teamspeak
    [email protected] [~/public_html/teamspeak]# ./teamspeak2-server_startscript start
    starting the teamspeak2 server
    Error starting daemon. Aborted
    [email protected] [~/public_html/teamspeak]# exit
    exit
    
    [email protected] [/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
    
    [email protected] [/home/teamspeak/public_html/teamspeak]# ./teamspeak2-server_startscript stop
    stopping the teamspeak2 server....done

    Code:
    [email protected] [/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]
    
    [email protected] [/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


    Code:
    [email protected] [~/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: 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 --------------
    ---------------------------------------------------------------
    ----------------------------------------------------------

  6. #21
    Join Date
    August 2007
    Location
    USA
    Posts
    25
    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:
    [email protected] [~/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

  7. #22
    Join Date
    July 2006
    Posts
    1,600
    Read the first post of this thread

  8. #23
    Join Date
    August 2007
    Location
    USA
    Posts
    25
    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;

  9. #24
    Join Date
    August 2007
    Location
    USA
    Posts
    25
    I tried starting it in root user mode, it works just not in teamspeak user mode

  10. #25
    Join Date
    July 2006
    Posts
    1,600
    do as root:
    Code:
    chown -R [user] [path to tss] For EXAMPLE: chown -R ts /home/ts
    And then try to start the server with your ts user.

  11. #26
    Join Date
    August 2007
    Location
    USA
    Posts
    25
    That was already done before

  12. #27
    Join Date
    July 2006
    Posts
    1,600
    Quote Originally Posted by zionahead View Post
    That was already done before
    Try
    Code:
    chown -R [user]:users [path]
    Example: chown -R ts:users /home/ts

  13. #28
    Join Date
    August 2007
    Location
    USA
    Posts
    25
    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

  14. #29
    BHKai is offline -= Undercover TeamSpeak Fanatic =-
    Join Date
    January 2007
    Location
    LA
    Posts
    4,576
    The page should be login.html not login.tscmd

  15. #30
    Join Date
    August 2007
    Location
    USA
    Posts
    25
    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [Resolved] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
    By Svenskunganka in forum Server Support
    Replies: 2
    Last Post: September 12th, 2013, 10:59 PM
  2. Teamspeak goes MySql
    By Forces in forum Linux / FreeBSD
    Replies: 17
    Last Post: August 19th, 2011, 12:28 PM
  3. Teamspeak 3 <> MySQL
    By DeadHunter in forum Linux / FreeBSD
    Replies: 5
    Last Post: November 25th, 2010, 03:16 PM

Posting Permissions

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