Forum

Page 3 of 4 FirstFirst 1234 LastLast
Results 31 to 45 of 51
  1. #31
    Join Date
    August 2007
    Location
    USA
    Posts
    25
    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.

  2. #32
    Join Date
    August 2006
    Location
    Hawai'i
    Posts
    2

    Angry

    Quote Originally Posted by mokum View Post
    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


    This is all well and good but my problem (haven't seen this covered anywhere in these forums) is that when starting the Linux server (any version) it just doesn't create any MySQL tables .. which would by itself explain the "Invalid Username/Password" errors I keep getting ... WHY isn't it creating any tables? I'm running tss2_rc2_20201 on a RedHat 9 server, I am now running MySQL 5.0.xx and am willing to try earlier versions although some people here say it doesn't matter what version or whatever. Yes, I've added the [DBEXPRESS] section to the bottom of my server.ini file:

    [DBEXPRESS]
    sqldir=mysql_sql/
    Drivername=mysql
    Database=mydatabase
    Hostname=127.0.0.1
    User_name=databaseuserwithfullprivileges
    Password=databaseuserpasswordforsameuser
    GetDriverFunc=getSQLDriverMYSQL
    VendorLib=./libmysqlclient_r.so.10.0.0
    LibraryName=./libsqlmy.so
    Active=1

    and Yes, the above-named libmysql v.3 libraries are installed in the same directory (tss2_rc2) as all the other files. I've modified my.cnf per someone's instructions, to enable this 'old_passwords' format. I've stopped and started the mysql server. Nothing seems to create that MySQL database!


    WHY don't Teamspeak developers just put all the libmysql libraries (v. 3, along with the modified read_servers.sql and read_channel_privilege.sql in mysql_sql folder, plus full and tested instructions for installation? I can't believe they want to charge people for slots for commercial use of a program that doesn't even install right and comes with basically zero tech support. Please help!!!

  3. #33
    Join Date
    May 2007
    Location
    Czech
    Posts
    4

    Thumbs down

    My SW:

    Server version: 5.0.32-Debian_7etch1-log Debian etch distribution

    Linux debianpc 2.6.18-5-amd64 #1 SMP Thu May 31 23:51:05 UTC 2007 x86_64 GNU/Linux

    ts2_server_rc2_20319

    end of server.ini:

    Code:
    [DBEXPRESS]
    sqldir=mysql_sql
    Drivername=mysql
    Database=teamspeak
    Hostname=localhost
    User_name=teamspeak
    #Password=fweruvfsa7f3hjsjcvh9
    Password=password
    GetDriverFunc=getSQLDriverMYSQL
    VendorLib=./libmysqlclient_r.so.10.0.0
    LibraryName=./libsqlmy.so
    Active=1
    i try this:
    Code:
    mysql> USE mysql
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A
    
    Database changed
    mysql> update user set password = old_password('password') where user = 'teamspeak'; flush privileges;
    Query OK, 2 rows affected (0.01 sec)
    Rows matched: 2  Changed: 2  Warnings: 0
    
    Query OK, 0 rows affected (0.00 sec)
    i find and download on this forum libmysqlclient_r.so.10.0.0 and copy to dir of TS

    on phpmyadmin a can login with user "teamspeak" with pass "password" and i see
    Code:
     * Projít ts2_bans
        * Projít ts2_channels
        * Projít ts2_channel_privileges
        * Projít ts2_clients
        * Projít ts2_servers
        * Projít ts2_server_privileges
    on log still :

    Code:
    15-01-08 11:12:22,ALL,Info,server,      Server init initialized
    15-01-08 11:12:22,ALL,Info,server,      Server version: 2.0.23.19 Linux
    15-01-08 11:12:22,ERROR,All,SQL,        Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
    15-01-08 11:12:22,ERROR,All,SERVER,     Start_Server: unable to open database
    ----------------------------------------------------------
    Where is problem pls?

  4. #34
    Join Date
    February 2007
    Location
    Marly-le-Roi
    Posts
    4
    I have the same problem, can anyone help us plz ?

  5. #35
    Join Date
    January 2008
    Location
    Sofia,Bulgaria
    Posts
    1
    Hi,

    I Want to give some hints to people with problems with MySQL 4/5 and the following error:

    27-01-08 17:42:51,ALL,Info,server, Server init initialized
    27-01-08 17:42:51,ALL,Info,server, Server version: 2.0.23.19 Linux
    27-01-08 17:42:51,ERROR,All,SQL, Database initialization error: EDatabaseError.DLL/Shared Library Name not Set
    27-01-08 17:42:51,ERROR,All,SERVER, Start_Server: unable to open database

    This is what I get when I tried to run it with MySQL instead of SQLite support. I'm using the current debian testing package (2.0.23.19-1: amd64) This error was so persistent. I tried downgrading the mysql libs to 3.23.56-3: amd64 package from old sarge distro. I copied&pasted the additional MySQL config (the [DBEXPRESS] part of config) from some thread in this forum. After that I tried everything here, changing localhost, short passwords, putting libraries to different dirs. And finaly found my problem. The example config that I've got had a hard to spot typo:

    [DBEXPRESS]
    ......
    LibaryName=/usr/lib/teamspeak-server/libsqlmy.so
    .....

    Missing 'r' in name "LibraryName". This take me hours to find out. So, please if you have similar problems
    with MySQL please check syntax very carefully. Don't just copy and paste other configs and change right part. Hope this helps someone ....

  6. #36
    Join Date
    February 2008
    Location
    USA
    Posts
    3
    Quote Originally Posted by Roman777 View Post
    My SW:

    Server version: 5.0.32-Debian_7etch1-log Debian etch distribution

    Linux debianpc 2.6.18-5-amd64 #1 SMP Thu May 31 23:51:05 UTC 2007 x86_64 GNU/Linux

    ts2_server_rc2_20319

    end of server.ini:

    Code:
    [DBEXPRESS]
    sqldir=mysql_sql
    Drivername=mysql
    Database=teamspeak
    Hostname=localhost
    User_name=teamspeak
    #Password=fweruvfsa7f3hjsjcvh9
    Password=password
    GetDriverFunc=getSQLDriverMYSQL
    VendorLib=./libmysqlclient_r.so.10.0.0
    LibraryName=./libsqlmy.so
    Active=1
    i try this:
    Code:
    mysql> USE mysql
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A
    
    Database changed
    mysql> update user set password = old_password('password') where user = 'teamspeak'; flush privileges;
    Query OK, 2 rows affected (0.01 sec)
    Rows matched: 2  Changed: 2  Warnings: 0
    
    Query OK, 0 rows affected (0.00 sec)
    i find and download on this forum libmysqlclient_r.so.10.0.0 and copy to dir of TS

    on phpmyadmin a can login with user "teamspeak" with pass "password" and i see
    Code:
     * Projít ts2_bans
        * Projít ts2_channels
        * Projít ts2_channel_privileges
        * Projít ts2_clients
        * Projít ts2_servers
        * Projít ts2_server_privileges
    on log still :

    Code:
    15-01-08 11:12:22,ALL,Info,server,      Server init initialized
    15-01-08 11:12:22,ALL,Info,server,      Server version: 2.0.23.19 Linux
    15-01-08 11:12:22,ERROR,All,SQL,        Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
    15-01-08 11:12:22,ERROR,All,SERVER,     Start_Server: unable to open database
    ----------------------------------------------------------
    Where is problem pls?
    I am having an identical problem on the exact same OS

  7. #37
    Join Date
    February 2008
    Location
    France
    Posts
    3
    Same error here and i try with lib mysql:

    • libmysqlclient.so.10
    • libmysqlclient.so.12
    • libmysqlclient.so.14
    • libmysqlclient.so.15



    Resume :

    OS : uname -r
    Linux *************** 2.6.18-xenU #3 SMP Thu Jan 10 15:56:11 CET 2008 i686 GNU/Linux
    MYSQL version : mysql --version
    mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2
    Conf server : server.ini
    [DBEXPRESS]
    sqldir=mysql_sql
    Drivername=mysql
    Database=teamspeak
    Hostname=localhost
    User_name=teamspeak
    Password=toto

    GetDriverFunc=getSQLDriverMYSQL
    VendorLib=/usr/lib/libmysqlclient.so.10.0.0
    LibraryName=./libsqlmy.so
    Active=1
    Connection mysql : sudo -u teamspeak mysql -u teamspeak -h localhost teamspeak -p
    Enter password: toto
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 266
    Server version: 5.0.32-Debian_7etch4-log Debian etch distribution

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

    mysql>
    Launching teamspeak : sudo -u teamspeak /home/teamspeak/tss2_rc2/teamspeak2-server_startscript start
    starting the teamspeak2 server
    Error starting daemon. Aborted

    ***in server.log ***
    ---------------------------------------------------------------
    -------------- log started at 20-02-08 14:27 -------------
    ---------------------------------------------------------------
    20-02-08 14:27:27,ALL,Info,server, Server init initialized
    20-02-08 14:27:27,ALL,Info,server, Server version: 2.0.23.19 Linux
    20-02-08 14:27:27,ERROR,All,SQL, Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
    20-02-08 14:27:27,ERROR,All,SERVER, Start_Server: unable to open database
    ----------------------------------------------------------
    ---------------------------------------------------------------
    --------------- log ended at 20-02-08 14:27 --------------
    ---------------------------------------------------------------

  8. #38
    Join Date
    February 2008
    Location
    France
    Posts
    3
    Ok i resolved issue by changing password hash

    Code:
    SET PASSWORD FOR '<mysqluser>'@'<host>' = OLD_PASSWORD('<password>');
    thanks to IceMatrix

  9. #39
    Join Date
    June 2007
    Location
    germany
    Posts
    4
    i've got it working so far too,

    but changes in the config for virtual servers get lost. No matter if i set them in the webinterface or directly in the database. as soon as i restart the server or start the virtual-server (id2) it is set to the settings of id1 and of corse won't start.

    any solutions?

  10. #40
    Join Date
    March 2008
    Location
    Ukraine, Kiev
    Posts
    6

    Question sql files missing

    Hello,

    My problem is:

    ---------------------------------------------------------------
    -------------- log started at 24-03-08 22:33 -------------
    ---------------------------------------------------------------
    24-03-08 22:33:20,ALL,Info,server, Server init initialized
    24-03-08 22:33:20,ALL,Info,server, Server version: 2.0.24.1 Linux
    24-03-08 22:33:20,ERROR,All,SQL, SQL file not found mysql_sql/read_servers.sql
    24-03-08 22:33:20,ERROR,All,SQL, SQL file not found mysql_sql/new_server.sql
    24-03-08 22:33:20,ERROR,All,SQL, SQL file not found mysql_sql/read_server_privilege.sql
    24-03-08 22:33:20,ERROR,All,SQL, SQL file not found mysql_sql/new_server_privilege.sql
    [...]
    (log cutted, there are more files missing)

    Why are these files missing? I've downloaded latest archive from this site and I don't see them in mysql_sql dir, that's very odd

    Here are contents of mysql_sql:

    -rw-r--r-- 1 teamspeak root 396 2007-08-02 14:25 create_bans.sql
    -rw-r--r-- 1 teamspeak root 520 2007-08-02 14:25 create_channel_privileges.sql
    -rw-r--r-- 1 teamspeak root 835 2007-08-02 14:25 create_channels.sql
    -rw-r--r-- 1 teamspeak root 588 2007-08-02 14:25 create_clients.sql
    -rw-r--r-- 1 teamspeak root 3706 2007-08-02 14:25 create_server_privileges.sql
    -rw-r--r-- 1 teamspeak root 1504 2007-08-02 14:25 create_servers.sql
    EDIT
    Found possible solution here: http://forum.teamspeak.com/showthread.php?t=40814
    and here: http://forum.goteamspeak.com/showthread.php?t=33504


    Some notes to everybody:
    1. Don't try to use mysql client libraries newer then mysql distribution version 3.x. Native dbExpress library (libsqlmy.so) supports ONLY 3.x (libmysqlclient.so.10)
    2. You can use newer versions (even up to 5.x - libmysqlclient.so.15) with dbExpress linux driver 4.20 (http://www.crlab.com/dbx/download.html). Use it instead of libsqlmy.so.

    Now I have a lot of strange problems with queries :|
    OMG:
    http://forum.teamspeak.com/showthread.php?t=24654
    This is so freaking stupid

    So far I can say, there is NO possible FREE solution to use latest mysql client/server with ts2...
    Last edited by messiah; March 25th, 2008 at 04:21 AM.

  11. #41
    Join Date
    August 2003
    Location
    NJ
    Posts
    32
    Yup, i've tried everything as well. Is there not a free alternative to the dbexpress? I dont feel like paying $100 to use TSS

  12. #42
    Join Date
    July 2007
    Location
    France
    Posts
    30
    I use mysql 5.0.32 with TSS + lib libmysqlclient_r.so.10.0.0 and it work just fine, put the lib in the TS home directory / fill the config file and it's done, you just have to watch out for the password because TSS need old_password encryption. For infos there is plenty of tutorial explaining this method in the forum look @ "TeamSpeak 2.x with MySQL 5.x (Tutorial)" in sticky

  13. #43
    Join Date
    April 2007
    Location
    Ger
    Posts
    4
    wrong topic

  14. #44
    Join Date
    June 2008
    Location
    italy
    Posts
    4

    same problem..

    -------------- log started at 27-06-08 23:12 -------------
    ---------------------------------------------------------------
    27-06-08 23:12:28,ALL,Info,server, Server init initialized
    27-06-08 23:12:28,ALL,Info,server, Server version: 2.0.24.1 Linux
    27-06-08 23:12:28,WARNING,Info,SQL, created table ts2_servers
    27-06-08 23:12:28,WARNING,Info,SQL, created table ts2_server_privileges
    27-06-08 23:12:28,WARNING,Info,SQL, created table ts2_channels
    27-06-08 23:12:28,WARNING,Info,SQL, created table ts2_channel_privileges
    27-06-08 23:12:28,WARNING,Info,SQL, created table ts2_clients
    27-06-08 23:12:28,WARNING,Info,SQL, created table ts2_bans
    27-06-08 23:12:28,ERROR,Info,server, EDatabaseError: dbExpress Error: Operation Not Supported
    ----------------------------------------------------------
    Running on debian.. with mysql 4.1.10.

    Please help me.
    Last edited by smartino84; June 27th, 2008 at 08:14 PM.

  15. #45
    Join Date
    September 2008
    Location
    Germany
    Posts
    4
    Hey guys,
    got the same problems what most of u have.

    ERROR,Info,server, EDatabaseError: dbExpress Error: Operation Not Supported
    Still get this error nvm if i changed read_servers.sql too
    It sux. Got Suse

    EDIT:
    OMG. Crazy. After 10 times tries its working. I dont know why. I have often changed read_servers.sql.. and now.. no errors.

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
  •