Forum

Page 1 of 2 12 LastLast
Results 1 to 15 of 51

Hybrid View

  1. #1
    Join Date
    January 2005
    Location
    Switzerland
    Posts
    8

    Sticky TeamSpeak with MySQL > 4.0

    When using a mysql version > 4.0 you might expirience problems with starting the tss deamon. The server.log file will contain the errors.

    meisenst solved the initial problem [EDatabaseError: dbExpress Error: Operation Not Supported] by changing the query in mysql_sql/read_servers.sql to read:

    Code:
    select * from ts2_servers WHERE i_server_id > 0;
    Then there is a second problem with the changing of ChannelAttribs. Changes made to users rights [like CA etc] would be LOST after disconnection.

    siepel fixed the second problem [GetChannelAttribs Exception: EDatabaseError.dbExpress Error: Operation Not Supported]

    Code:
    select * from ts2_channel_privileges where i_cp_server_id = :iServerID and i_cp_channel_id = :iChannelID and i_cp_client_id = :iClientID
    put that in mysql_sql/read_channel_privilege.sql just on one single line exactly as above..

    Please sticky this.

    Cheers,
    mokum

  2. #2
    Join Date
    November 2005
    Location
    Martinica
    Posts
    7
    Hi,

    First, sorry for my bad english plz.

    I tried several times to make my TS working with mysql 4.1 but never had it.
    I use gentoo.
    It worked very well with mysql 4.0, but, after upgrading mysql, I'm not able to connect to mysql :
    09-11-05 01:58:09,ALL,Info,server, Server init initialized
    09-11-05 01:58:09,ALL,Info,server, Server version: 2.0.20.1 Linux
    09-11-05 01:58:09,ERROR,All,SQL, Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
    09-11-05 01:58:09,ERROR,All,SERVER, Start_Server: unable to open database

    I didn't change anything to mysql tables, and teamspeak user in mysql.

    I searched here for a solution, tried with all tricks :
    # cat mysql_sql/read_channel_privilege.sql
    select * from ts2_channel_privileges where i_cp_server_id = :iServerID and i_cp_channel_id = :iChannelID and i_cp_client_id = :iClientID

    (in one line)

    # cat mysql_sql/read_servers.sql
    select * from ts2_servers WHERE i_server_id > 0;

    as indicated here http://forum.goteamspeak.com/showthr...582#post114582

    my server.ini :
    [DBEXPRESS]
    sqldir=/opt/teamspeak2-server/mysql_sql/
    Drivername=mysql
    Database=teamspeak
    Hostname=localhost
    User_name=teamspeak
    Password=******
    GetDriverFunc=getSQLDriverMYSQL
    VendorLib=/usr/lib/libmysqlclient_r.so.10.0.0
    LibraryName=/opt/teamspeak2-server/libsqlmy.so
    Active=1

    # ls -l /usr/lib/libmysqlclient_r.so.10.0.0
    -rwxr-xr-x 1 root root 198920 jan 29 2003 /usr/lib/libmysqlclient_r.so.10.0.0

    # ls -l /opt/teamspeak2-server/libsqlmy.so
    -rwxr-xr-x 1 teamspeak nogroup 131736 mar 30 2005 /opt/teamspeak2-server/libsqlmy.so

    Is it really possible to make TS work with mysql 4.1 ?

    Thanks for all help, but very simples words plz (or french ? ;-) ).

  3. #3
    Join Date
    October 2004
    Location
    Ohio
    Posts
    6
    You shouldnt have to make any sql changes. I have run TS on 4.0, 4.1, and currently on 5.0 with no problems or sql changes. As long as you have the old mysql3 library it should work fine.

  4. #4
    Join Date
    November 2005
    Location
    Martinica
    Posts
    7
    So, I don't understand why it doesn't work.

    If it worked well with mysql 4.0, that shows I use the correct librairy, no ?

  5. #5
    Join Date
    October 2004
    Location
    Ohio
    Posts
    6
    Have you tried connecting to Mysql through the commandline with those settings?

  6. #6
    Join Date
    November 2005
    Location
    Martinica
    Posts
    7
    Yes, no problem at all :

    # mysql -hlocalhost -uteamspeak -p*******
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 683 to server version: 4.1.14-log

    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

    mysql> connect teamspeak;
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A

    Connection id: 684
    Current database: teamspeak

    mysql> show tables;
    +------------------------+
    | Tables_in_teamspeak |
    +------------------------+
    | ts2_bans |
    | ts2_channel_privileges |
    | ts2_channels |
    | ts2_clients |
    | ts2_server_privileges |
    | ts2_servers |
    +------------------------+
    6 rows in set (0.00 sec)

    mysql>

    <edit>
    I have it working.
    I had to change mysql teamspeak password with old_password() function.
    </edit>
    Last edited by novazur; November 9th, 2005 at 04:26 PM. Reason: [solved]

  7. #7
    Join Date
    March 2006
    Location
    Switzerland
    Posts
    1
    Quote Originally Posted by mokum
    When using a mysql version > 4.0 you might expirience problems with starting the tss deamon. The server.log file will contain the errors.

    meisenst solved the initial problem [EDatabaseError: dbExpress Error: Operation Not Supported] by changing the query in mysql_sql/read_servers.sql to read:

    Code:
    select * from ts2_servers WHERE i_server_id > 0;
    Then there is a second problem with the changing of ChannelAttribs. Changes made to users rights [like CA etc] would be LOST after disconnection.

    siepel fixed the second problem [GetChannelAttribs Exception: EDatabaseError.dbExpress Error: Operation Not Supported]

    Code:
    select * from ts2_channel_privileges where i_cp_server_id = :iServerID and i_cp_channel_id = :iChannelID and i_cp_client_id = :iClientID
    put that in mysql_sql/read_channel_privilege.sql just on one single line exactly as above..

    Please sticky this.

    Cheers,
    mokum
    Thanks for your tips - now on OpenSuSE 10 TS2 works fine!

  8. #8
    Join Date
    May 2006
    Location
    MN
    Posts
    9
    Will you please sticky this as it would of saved me a lot of time

    My server is working just fine so far.

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

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

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

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

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

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

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

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
  •