Forum

Page 4 of 8 FirstFirst ... 23456 ... LastLast
Results 46 to 60 of 108
  1. #46
    Join Date
    May 2012
    Location
    The 3rd dimension
    Posts
    956
    Quote Originally Posted by ScP View Post
    So we're discussing for two pages now because you didn't write an accurate description of your problem?!?

    Just kidding...

    I usually use client permissions and when I found that I couldn't I made a reply here. Then I realised I could not even assign a server group?! I now that really annoyed me because I use one of those two techniques to allow websites to see more than users can.

  2. #47
    Join Date
    March 2014
    Location
    Western Australia
    Posts
    4
    Will any of the voice codec's be getting updated? noticed there has been a few updates to the codec's (on there websites), will these be getting put in the new teamspeak server update? (to summerize my question, will the codec's be getting updated to the latest stable version's that are on there websites)

  3. #48
    Join Date
    August 2014
    Posts
    3
    How to install TeamSpeak 3 Server with MariaDB?

  4. #49
    Join Date
    June 2008
    Posts
    18,409
    I hope this covers most cases and helps to explain how to use Maria DB with latest server.
    Edit --> Always read the documentation in case you don't know what you have to do.

    In case you use a new server database
    1. Install the latest MYSQL or Maria DB Server and then create a Database and User for this Database
    2. Install the TeamSpeak server 3.0.12.4 (or newer)
    3. Go into the redist folder and then move the libmariadb.dll / libmariadb.so.2 into servers root folder.
    4. Create the files ts3server.ini and a ts3db_mariadb.ini
    5. Open the ts3server.ini and fill it with these parameters
    Code:
    dbplugin=ts3db_mariadb
    dbpluginparameter=ts3db_mariadb.ini
    dbsqlcreatepath=create_mariadb/
    5. Open the ts3db_mariadb.ini and fill it with this informations. Please insert your IP, Username, passwort etc.
    Code:
    [config]
     host='IP_From_MARIA_DB_SERVER'
     port='Port_Number_Of_MARIA_DB_SERVER'
     username='Database_Username"
     password='Password_For_The_User'
     database='Name_Of_your_Database'
     socket=
    6. Start the server with parameter inifile=ts3server.ini
    7. Check your server logs for success or errors

    In case you did use SQLite with server 3.0.10.3 and want to change to Maria DB
    Convert Your database to target database and then follow step 1 -7.

    In case you did use SQLite with server 3.0.10.3 and want to stay on SQLite
    Just update the server. There is nothing else you have to do.

    In case you did use MYSQL with server 3.0.10.3 just like to update the TeamSpeak server
    1. Make a backup of your existing database
    2. Install the server 3.0.12.4 (or newer)
    3. Read update_mysql_to_mariadb.txt from your Doc folder
    4. Run convert_mysql_to_mariadb.sql and mariadb_fix_latin_utf8.sql from folder (sql\updates_and_fixes)
    5. Replace all MYSQL paramters for Maria DB (shown in step 4 and 5)
    6. Start the server with parameter inifile=ts3server.ini
    7. Check your server logs for success or errors
    Last edited by dante696; June 6th, 2016 at 09:57 AM. Reason: server verison updated
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

  5. #50
    Join Date
    August 2014
    Posts
    3
    2014-08-12 11:59:12.116681|ERROR |DatabaseQuery | | db_exec() CREATE TABLE channel_properties( server_id int unsigned, id int error: Specified key was too long; max key length is 767 bytes
    2014-08-12 11:59:12.116681|CRITICAL|SQL | | db_CreateTables() unable to create tables

  6. #51
    Join Date
    June 2008
    Posts
    18,409
    Quote Originally Posted by amahassle View Post
    2014-08-12 11:59:12.116681|ERROR |DatabaseQuery | | db_exec() CREATE TABLE channel_properties( server_id int unsigned, id int error: Specified key was too long; max key length is 767 bytes
    2014-08-12 11:59:12.116681|CRITICAL|SQL | | db_CreateTables() unable to create tables
    More details please?
    What databse?
    Was it an update? Or a new database?(Have you converted your old database SQLite / MysqL to the new format?)
    Is there any restriction in your MYSQL Maria DB server?
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

  7. #52
    Join Date
    August 2014
    Posts
    3
    This new database MariaDB. The problem occurs only on Windows. On Linux, all in order to install a new database MariaDB

  8. #53
    Join Date
    June 2011
    Location
    Germany
    Posts
    4,371
    Quote Originally Posted by ScP View Post
    2. Allow execution of the clientlist command on SINGLE virtual servers

    Code:
    ServerQuery Guest  |  not set
    Server Guest       |  Value: 1, Skip: 0, Negated: 0
    Wait! How does that make sense with
    - Guest ServerQuery user now always has default server query group, even while using a virtual
    server.
    in the changelog?

    If this has been discussed in the quote wars, I'm sorry. TL;DR

  9. #54
    Join Date
    October 2003
    Location
    Germany
    Posts
    2,528
    Quote Originally Posted by numma_cway View Post
    Wait! How does that make sense with
    in the changelog?
    The ServerQuery guest client will be a member of both the query default group and the server default group. This has always been the case... it's just working correctly now.

    Last edited by ScP; August 12th, 2014 at 08:00 PM.

  10. #55
    Join Date
    June 2011
    Location
    Germany
    Posts
    4,371
    Okay. I think this could be reworded to make that clearer.

  11. #56
    Join Date
    October 2011
    Location
    Jacksonville, Arkansas
    Posts
    31
    So.. Say you been running a normal TS3 Server. When you go to update to this version, you just do steps 1-7 and all should be well? and what if I just have SSH access? How do I do step 5??

  12. #57
    Join Date
    June 2008
    Posts
    18,409
    Quote Originally Posted by amahassle View Post
    This new database MariaDB. The problem occurs only on Windows. On Linux, all in order to install a new database MariaDB
    Please check your database then, Windows and Linux do use the same files to create/update a new database.
    It must be a setting in your database in my opinion, that prevents the server from creating this table.
    it should look like this.
    Attachment 11145

    Quote Originally Posted by DevilHunter View Post
    So.. Say you been running a normal TS3 Server. When you go to update to this version, you just do steps 1-7 and all should be well? and what if I just have SSH access? How do I do step 5??
    What is a normal server?
    SSH acces sem enough for me to do steps 3 -5 (Could be done with WinSCP as an example)



    I just have added a case, where server was running SQLite and stays on SQLite.
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

  13. #58
    Join Date
    December 2009
    Location
    florida
    Posts
    263
    been running a server on my old win xp machine at home.
    worked fine on 3.0.10
    updated now get "ts3server_win32.exe has encountered a problem and needs to close"
    could my issue be?....
    win xp itself
    or
    my old hardware?

    amd athlonxp 3200
    500M ram

    stayed on sql
    Last edited by HHD_HELLBOUND; August 13th, 2014 at 09:23 PM. Reason: sql

  14. #59
    Join Date
    October 2011
    Location
    Jacksonville, Arkansas
    Posts
    31
    Well, what I'm saying is.. its almost just like a FileServer but, it has a Game Server and Teamspeak 3 on it. What I'm trying to find out, is that.. Do I just download the update and do the normal extract?? I re-read the main post, and it says I need to run those two files to Convert my sqlite base.

    I just don't want to start over because of a messed up DB. I already had to start over 3 times or more because of Permissions, and one time because the DB got messed up.

  15. #60
    Join Date
    September 2012
    Posts
    6,080
    Quote Originally Posted by DevilHunter View Post
    I re-read the main post, and it says I need to run those two files to Convert my sqlite base.
    It doesn't say that anywhere, it says that if you're using a MySQL database you have to do that, otherwise (ie. when using SQLite) you don't.
    When sending PMs please make sure to include a reference link to the thread in question in the body of your message.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [PreRelease] TeamSpeak 3 Server 3.0.11.4 Beta
    By Matthias B in forum Archive
    Replies: 3
    Last Post: August 21st, 2015, 08:54 AM
  2. Replies: 3
    Last Post: May 10th, 2015, 05:56 PM
  3. [PreRelease] TeamSpeak 3 Server 3.0.10
    By Chris in forum Archive
    Replies: 18
    Last Post: September 28th, 2013, 08:57 PM
  4. [PreRelease] TeamSpeak 3 Server 3.0.9
    By dante696 in forum Archive
    Replies: 16
    Last Post: September 12th, 2013, 09:50 AM
  5. [PreRelease] TeamSpeak 3 Server 3.0.8
    By Chris in forum Archive
    Replies: 53
    Last Post: August 11th, 2013, 11:21 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
  •