Forum

Page 2 of 3 FirstFirst 123 LastLast
Results 16 to 30 of 44
  1. #16
    Join Date
    April 2007
    Location
    Ger
    Posts
    4
    I get every time username/passwort.... I think there is not really a connection to mysql... I tried without pass and the same error... anybody a idea?

    Swen

  2. #17
    Join Date
    April 2007
    Location
    Quebec
    Posts
    1
    with Fedora Core 6 all you have to do when you get the cannot find lib ... you get

    MySQL-shared-compat-4.1.22-0.i386.rpm from mysql web site. once installed using full path it work with :
    mysql Ver 14.12 Distrib 5.0.27, for redhat-linux-gnu (i686) using readline 5.0
    ================================================== ========
    [DBEXPRESS]
    sqldir=/usr/bin/tss2_rc2/mysql_sql/
    Drivername=mysql
    Database=ts_domainname_com
    Hostname=127.0.0.1
    User_name=ts_linux
    Password=long-ass-password
    GetDriverFunc=getSQLDriverMYSQL
    VendorLib=/usr/lib/libmysqlclient_r.so.10.0.0
    LibraryName=/usr/bin/tss2_rc2/libsqlmy.so
    Active=1
    ================================================== ========

    no problem for now.

  3. #18
    Join Date
    April 2007
    Location
    Germany
    Posts
    33
    Quote Originally Posted by AB2314 View Post
    I get every time username/passwort.... I think there is not really a connection to mysql... I tried without pass and the same error... anybody a idea?

    Swen
    1. Has your mysql server networking enabled? Check your /etc/mysql/my.cnf and comment out the line "skip-networking".

    2. You have to use old passwords, since the authentication mechanism within mysql changed. Connect to the database as root-user and type the following:

    SET PASSWORD FOR '<your-ts-db-user>'@'localhost' = OLD_PASSWORD('<your-ts-db-pass>')

    3. Does your teamspeak-server connect to "127.0.0.1" instead of "localhost"? If your database server supports sockets, you have to use the ip address of the loopback device (127.0.0.1) instead of the hostname (localhost) to prevent the teamspeak-server from using the unix socket.

    server.ini example:

    sqldir=mysql_sql/
    Drivername=mysql
    Database=teamspeak
    Hostname=127.0.0.1
    User_name=teamspeak
    Password=xxxxxx
    GetDriverFunc=getSQLDriverMYSQL
    VendorLib=/usr/lib/libmysqlclient_r.so.10
    LibraryName=./libsqlmy.so
    Active=1

    Note: The property "User_name" is correct, don't use "Username" (without the underscore) here as told elsewhere in this forum, it won't work.

  4. #19
    Join Date
    October 2007
    Location
    France
    Posts
    70

    Question

    Hello,

    I'm on debian (last version updated)

    My server don't work on mysql and i don't find why.

    Quote Originally Posted by configuration
    [DBEXPRESS]
    sqldir=home/teamspeak/serv/mysql_sql
    Drivername=mysql
    Database=teamspeak
    Hostname=127.0.0.1
    User_name=my_username
    Password=my_password
    GetDriverFunc=getSQLDriverMYSQL
    VendorLib=/usr/lib/libmysqlclient_r.so.15.0.0
    LibraryName=./libsqlmy.so
    Active=1
    Quote Originally Posted by error
    07-04-08 14:40:57,ALL,Info,server, Server init initialized
    07-04-08 14:40:57,ALL,Info,server, Server version: 2.0.24.1 Linux
    07-04-08 14:40:57,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load /usr/lib/libmysqlclient_r.so.15.0.0
    07-04-08 14:40:57,ERROR,All,SERVER, Start_Server: unable to open database
    I've tested with many configuration, but it don't work, here's the differently configuration i've used:

    VendorLib=/usr/lib/libmysqlclient_r.so.15.0.0
    VendorLib=/usr/lib/libmysqlclient_r.so.15
    VendorLib=/usr/lib/libmysqlclient.so.15.0.0
    VendorLib=/usr/lib/libmysqlclient.so.15
    VendorLib=./libmysqlclient_r.so.15.0.0
    VendorLib=./libmysqlclient.so.15.0.0

    If anybody have solution for me it's very cool, my test server on windows is on mysql and it work perfectly at the first time, i don't understand why it doesn't work on linux

    thx in advance

  5. #20
    Join Date
    May 2008
    Location
    Milano, Italy
    Posts
    3
    you should obtain necessary libs. you can do this in the following way:
    go to that link and download the .rpm file. so now you should open that file.
    if you are under linux (i'll hope), you should install a program called alien (available, i know, for gentoo and debian; probably also for other distros).
    by command line type
    Code:
    alien -t /YOURPATH/MySQL-shared-compat-4.1.9-0.i386.rpm
    with the -t option, you will make a .tgz file from the .rpm file.
    now in your .tgz (you can open it with some archive managers) there will be the necessary libs: libmysqlclient_r.so.10 is the one who interest you




    doing that i've obtained a starting and running server on my gentoo, using a mysql 5.0 database..but now i've a problem:
    from server.log:
    when i try to use webadmin interface from superadmin managing permissions that message is shown:
    Code:
    ,ERROR,All,WEBINTERFACE,       SetVariables Exception: EInvalidField.field b_sp_AdminEditServerWelcomeMessage not found
    and in the permissions sections of the webadmin, all values are shown like "%!SERVERCFG_GROUP_PERMISSIONS_SA!%" (as in their htmls).
    if i restart server, every time, it is shown that message:
    Code:
    ,ERROR,All,SERVER,     VirtualServer Startup(1) Exception: EInvalidField.field b_sp_AdminEditServerWelcomeMessage not found
    so i'm unable to manage my server...
    an other user had my same problem, but the replies to his post are not useful for me..
    so can someone help me?

  6. #21
    Join Date
    October 2007
    Location
    France
    Posts
    70
    i have the same problem :s

    if you have this error


    EInvalidField.field b_sp_AdminEditServerWelcomeMessage not found
    Edit the table and change the type tyint to int and the value 1 to 11

    for the moment my problem is solved, i work on it

    I confirm, problem solved

    Now i have a new question, how i can update my server.dbs on mysql table?
    Last edited by Bloody-wave; May 28th, 2008 at 11:38 AM.

  7. #22
    Join Date
    May 2008
    Location
    Hungary
    Posts
    2

    i have a problem

    dear helpers!

    [DBEXPRESS]
    sqldir=mysql_sql\
    Drivername=mysql
    Database=test
    Hostname=localhost
    User_name=team
    Password=****
    GetDriverFunc=getSQLDriverMYSQL
    VendorLib=libmysql.dll
    LibraryName=dbexpmysql.dll
    Active=1

    ----------
    29-05-08 22:49:37,ALL,Info,server, Server init initialized
    29-05-08 22:49:37,ALL,Info,server, Server version: 2.0.24.1 Win32
    29-05-08 22:49:37,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load libmysql.dll
    29-05-08 22:49:37,ERROR,All,SERVER, Start_Server: unable to open database
    29-05-08 22:49:37,ERROR,All,GENERAL, critical error, shutdown initiated


    ------

    mysql ver: 5.0.45

    what is the problem(s)?

  8. #23
    Join Date
    May 2008
    Location
    Hungary
    Posts
    17

    mysql 5 problema

    TS server is not working with mysql 5 library, because libsqlmy.so want a function (called mysql_connect) which isnt exists in 5.x library:
    Code:
    # grep mysql_connect /usr/lib/libmysqlclient_r.so.10
    Binary file /usr/lib/libmysqlclient_r.so.10 matches
    # grep mysql_connect /usr/lib/libmysqlclient_r.so.15
    #
    I added the missing function to mysql 5 source:
    Code:
    MYSQL*  STDCALL mysql_connect(MYSQL *mysql, const char *host, const char *user, const char *passwd)
    {
        return NULL;
    }
    After recompile and install:
    Code:
    # grep mysql_connect /usr/lib/libmysqlclient_r.so.15
    Binary file /usr/lib/libmysqlclient_r.so.15 matches
    #
    I write a little mysql wrapper. With this, i can "monitor" the mysql calls.
    Run ts2 server with mysql 3.x library working good:
    http://pastebin.com/f4004fa0a

    Run ts2 server with mysql 5.x library still not working:
    http://pastebin.com/f6872c01e

    Watch out to: own_mysql_real_query called:SHOW TABLES.
    TS dont call own_mysql_fetch_row to get the showtable result! Why?

    (Ubuntu Hardy)

  9. #24
    Join Date
    April 2007
    Location
    Ger
    Posts
    4
    03-06-08 19:00:06,ALL,Info,server, Server init initialized
    03-06-08 19:00:06,ALL,Info,server, Server version: 2.0.20.1 Linux
    03-06-08 19:00:06,ERROR,All,SQL, Database initialization error: EDatabaseError.Unable to Load /usr/lib/libmysqlclient_r.so.10.0.0
    03-06-08 19:00:06,ERROR,All,SERVER, Start_Server: unable to open database
    But the file is exist in folder... Any ideas?

  10. #25
    Join Date
    November 2006
    Location
    US
    Posts
    8

    Thumbs down

    all I can say is:

    Please document this better.


    edit: after reflection, I can also say:

    Linux isn't that hard to understand, and developing for it is almost as hard. So please, help a "brotha" out and begin the love for mysql on linux!!!

  11. #26
    Join Date
    November 2006
    Location
    US
    Posts
    8
    further elaboration:

    if one searches for "libmysqlclient_r.so.10.0.0" with google.com, the first result is:

    libmysqlclient_r.so.10.0.0 - TeamSpeak Community Forums


    ??????


    within the thread there's a statement further explaining the lack of regard for this demand for "support":

    Quote Originally Posted by ozman View Post
    Why wont people give these things away as a comunity

    It's hard to see a leg snap on a titanium-alloy reinforced bench, wtf is going on here??????

  12. #27
    Join Date
    November 2006
    Location
    US
    Posts
    8
    some MAJOR problems with the release of both the binary and "non existant" documentation:



    1) wont work if you use relative path names in the settings file
    2) binary distribution does not contain REQUIRED sql files in the mysql_sql folder
    3) Not sure, but I belive if you try to use (any) release other than 10.0.0 of the client library, then you're in a world of hurt.
    4) SET PASSWORD FOR '%%%%%%%%%%'@'%%%%%%%%' = OLD_PASSWORD( '%%%%%%%%%%%%%%%%%%' ) OR DIEEEEEEEE
    5) Impossible to administer server unless stock sql files edited before install: http://forum.teamspeak.com/showthrea...849#post179849

    WTF people!!!!!!!!
    Last edited by FoolyCooly; June 5th, 2008 at 08:34 AM.

  13. #28
    Join Date
    February 2005
    Location
    .
    Posts
    679
    It seems that most of the scripts in the mysql_sql directory are missing. We supposed to rewrite those for MySQL? Anyone else written them? No sense in reinventing the wheel.

  14. #29
    Join Date
    February 2005
    Location
    .
    Posts
    679
    Ok, so they are all on the FTP: ftp://ftp.freenet.de/pub/4players/te...2401/mysql_sql For some reason, they were left out of Windows and Linux server downloads.

    Rather than you having to copy all the text and save it to individual files, I thought I'd zip and tar them for you. See attached files.

    EDIT:
    Code:
    delete_channel_privileges.sql
    in my zip and tar should be
    Code:
    delete_channel_privilege.sql
    Last edited by sgtbenc; July 25th, 2008 at 12:04 AM.

  15. #30
    Join Date
    June 2006
    Location
    England, Hertfordshire
    Posts
    249
    Anyone know where I can get libmysqlclient_r.so.10.0.0 as the server won't allow libmysqlclient_r.so.15.0.0?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Ts3+Mysql tutorial (windows) ?
    By deviss in forum General Questions
    Replies: 1
    Last Post: October 11th, 2010, 07:49 AM
  2. [Mini-Tutorial] Fix ServerAdmin Lost Password (MYSQL)
    By Appleboy in forum Server Support
    Replies: 2
    Last Post: December 24th, 2009, 01:32 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
  •