Forum

Page 1 of 4 123 ... LastLast
Results 1 to 15 of 51
  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
    October 2004
    Location
    Ohio
    Posts
    6
    Interesting. It almost seems like it is still using the wrong mysql library

  8. #8
    Join Date
    October 2004
    Location
    Ohio
    Posts
    6
    You might also want to double check if thats the newest pre-4.0 mysql client library. Mine has a much newer date than yours from your output earlier. If you are using Debian the package I am using is
    libmysqlclient 3.23.56-3

  9. #9
    Join Date
    November 2005
    Location
    Martinica
    Posts
    7
    I also compiled again mysql-3.23.58-r1, to have a new libmysqlclient_r.so.10.0.0, but I didn't work only with that change. But I always used the oldder libmysqlclient_r.so.10.0.0 with mysql 4.0 and it always worked.

    As I said first, I use gentoo, and for my first use of teamspeak with it, I took libmysqlclient_r.so.10.0.0 from a rpm package I had with my old mandrake.

    As I said in my last edit, the last change I done is to change mysql teamspeak password with old_password() function.
    And now it works, but I don't really understand why because I use :
    old_passwords=1
    in my /etc/mysql/my.cnf
    and it works fine with others applications...

  10. #10
    Join Date
    October 2004
    Location
    Ohio
    Posts
    6
    oh yeah.. I shouldve mentioned I have old_passwords set

  11. #11
    Join Date
    November 2005
    Location
    Martinica
    Posts
    7
    I also have it but obviously it is not sufficient

  12. #12
    Join Date
    July 2004
    Location
    NL
    Posts
    29
    try putting the libmysqlclient_r.so.10 in the same dir:

    Code:
    [DBEXPRESS]
    sqldir=mysql_sql/
    Drivername=mysql
    Database=teamspeak
    Hostname=localhost
    User_name=teamspeak
    Password=secret
    GetDriverFunc=getSQLDriverMYSQL
    VendorLib=./libmysqlclient_r.so.10
    LibraryName=./libsqlmy.so
    Active=1
    That with the changed sql files.

    Also note, if u made users thru phpmyadmin, that does not seem to work all the time. With Debian unstable, the current phpmyadmin version does not support the new method of adding mysql users to the mysql version packed with debian unstable.

    Try adding them on the command line.

    Frank and i encountered that problem. We fixed it by straight commands in mysql.

  13. #13
    Join Date
    November 2005
    Location
    Germany
    Posts
    2
    Hatte den gleichen Fehler
    Meine Lösung unter Linux :

    Ich habe den Hostname von localhost auf 127.0.0.1 geändert

    Hostname=127.0.0.1


    Mysql 4.0.25-r2
    libmysqlclient.so.10.0.0 von :

    http://www.pack-eis.de/index.php?p=libmysql-shared

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

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

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
  •