Forum

Page 3 of 6 FirstFirst 12345 ... LastLast
Results 31 to 45 of 82
  1. #31
    Join Date
    August 2005
    Location
    Clifton Park, NY
    Posts
    5
    MoxNox. No, the script I posted can only be used to and from the version it is designed for. What it won't do however is alter any default values that YOU have changed. If there were additions between the version the script was designed for and the version you have, then you would end up with duplicate rows or perhaps invalid attempts to remove records and it would quite possibly corrupt your DB. You should instead produce a separate script using the procedure I described. It is important to make sure you keep the zip files for each release in it's initial form to ensure you can generate the needed scripts.

  2. #32
    Join Date
    August 2005
    Location
    Clifton Park, NY
    Posts
    5
    Server 11 to 15

    Note, this script is not as clean as my previous one, but I was unsure of what some of the records being moved around did, so I did not clean up records that may no longer be necessary. This should create all new records though. Also note that the server exe itself will apply a schema structure update for version 12 when you first launch it against a v12 or later server exe.

    Code:
    insert into instance_properties (server_id, id, ident, value) values (0, 0, "serverinstance_template_serverdefault_group", "5");
    insert into instance_properties (server_id, id, ident, value) values (0, 0, "serverinstance_template_channeladmin_group", "1");
    insert into instance_properties (server_id, id, ident, value) values (0, 0, "serverinstance_template_channeldefault_group", "4");
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_virtualserver_custom_search", 1, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_virtualserver_modify_min_client_version", 1, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_virtualserver_custom_search", 100, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_virtualserver_modify_min_client_version", 100, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_channel_info_view", 1, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_client_info_view", 1, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_channel_list", 1, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_channel_search", 1, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_client_list", 1, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_client_search", 1, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_custom_search", 1, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_info_view", 1, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_modify_min_client_version", 1, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_virtualserver_modify_min_client_version", 75, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "b_channel_info_view", 1, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "b_client_info_view", 1, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "b_virtualserver_channel_list", 1, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "b_virtualserver_client_list", 1, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 4, 0, "b_virtualserver_info_view", 1, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "b_channel_info_view", 1, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "b_client_info_view", 1, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "b_virtualserver_channel_list", 1, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "b_virtualserver_client_list", 1, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 5, 0, "b_virtualserver_info_view", 1, 0, 0);
    
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_virtualserver_custom_search", 75, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_virtualserver_info_view", 75, 0, 0);
    
    UPDATE perm_server_group SET perm_value = 75 where server_id=0 and id1 = 3 and id2 = 0 and perm_id = "i_needed_modify_power_channel_info_view" and perm_value = 100 and perm_negated = 0 and perm_skip = 0;
    UPDATE perm_server_group SET perm_value = 75 where server_id=0 and id1 = 3 and id2 = 0 and perm_id = "i_needed_modify_power_client_info_view" and perm_value = 100 and perm_negated = 0 and perm_skip = 0;
    UPDATE perm_server_group SET perm_value = 75 where server_id=0 and id1 = 3 and id2 = 0 and perm_id = "i_needed_modify_power_virtualserver_channel_list" and perm_value = 100 and perm_negated = 0 and perm_skip = 0;
    UPDATE perm_server_group SET perm_value = 75 where server_id=0 and id1 = 3 and id2 = 0 and perm_id = "i_needed_modify_power_virtualserver_client_list" and perm_value = 100 and perm_negated = 0 and perm_skip = 0;
    UPDATE perm_server_group SET perm_value = 75 where server_id=0 and id1 = 3 and id2 = 0 and perm_id = "i_needed_modify_power_virtualserver_client_search" and perm_value = 100 and perm_negated = 0 and perm_skip = 0;

  3. #33
    Join Date
    December 2009
    Location
    Hungary
    Posts
    162
    These were the release 2 changes, right?

    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_client_issue_client_query_command", 1, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_client_issue_client_query_command", 1, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_client_issue_client_query_c ommand", 100, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_client_issue_client_query_c ommand", 75, 0, 0);

    At least that was what I thought so far, but I saw this post the other day:


    You will also need to update the permissions for any existing virtual servers (if you want them to be able to use the new permissions). Basically, the below will grant the group with a group_id of 6 (which should be the group_id of the server admin group for the first virtual server) the permissions that would've been granted by default had you started with a fresh beta2 install.

    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 6, 0, "b_client_issue_client_query_command", 1, 0, 0);
    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 6, 0, "i_needed_modify_power_client_issue_client_query_c ommand", 75, 0, 0);

  4. #34
    Join Date
    December 2009
    Location
    Hungary
    Posts
    162
    Re your 11 to 15 script, this was written by ralf (TS dev) in the r15 announcement thread:

    the server updates automatically, this sql statements are only needed to get access to the new permissions:

    these are the command to update your database:

    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_virtualserver_modify_min_client_version", 1, 0, 0);

    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_virtualserver_modify_min_cl ient_version", 100, 0, 0);

    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_modify_min_client_version", 1, 0, 0);

    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_virtualserver_modify_min_cl ient_version", 75, 0, 0);

    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_virtualserver_custom_search", 1, 0, 0);

    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_virtualserver_custom_search ", 100, 0, 0);

    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_custom_search", 1, 0, 0);

    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_virtualserver_custom_search ", 75, 0, 0);

  5. #35
    Join Date
    December 2009
    Location
    Norway
    Posts
    16
    Updating from beta 12 to beta 16
    Would there be something I have to do other than overwriting the existing files?
    I am using mySQL.

  6. #36
    Join Date
    January 2010
    Location
    Helsinki. Finland
    Posts
    16
    I just overwrite the files from beta12 to beta16. now the server wont start. i get following error.

    teamspeak]$ -bash: ./ts3server_linux_x86: cannot execute binary file

    Running 32bit Linux


    Any help available?

  7. #37
    Join Date
    December 2009
    Location
    US
    Posts
    29
    Quote Originally Posted by MoXNoX View Post
    Re your 11 to 15 script, this was written by ralf (TS dev) in the r15 announcement thread:

    the server updates automatically, this sql statements are only needed to get access to the new permissions:

    these are the command to update your database:

    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_virtualserver_modify_min_client_version", 1, 0, 0);

    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_virtualserver_modify_min_cl ient_version", 100, 0, 0);

    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_modify_min_client_version", 1, 0, 0);

    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_virtualserver_modify_min_cl ient_version", 75, 0, 0);

    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "b_virtualserver_custom_search", 1, 0, 0);

    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value,perm_negated, perm_skip) values (0, 2, 0, "i_needed_modify_power_virtualserver_custom_search ", 100, 0, 0);

    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "b_virtualserver_custom_search", 1, 0, 0);

    insert into perm_server_group (server_id, id1, id2, perm_id, perm_value, perm_negated, perm_skip) values (0, 3, 0, "i_needed_modify_power_virtualserver_custom_search ", 75, 0, 0);
    So this is all that's needed when going from 11,12-16? Not all the code posted by AJH16 above?

  8. #38
    Join Date
    December 2009
    Location
    Hungary
    Posts
    162
    Quote Originally Posted by HotRod View Post
    Updating from beta 12 to beta 16
    Would there be something I have to do other than overwriting the existing files?
    I am using mySQL.
    Yes. You need to read the post right above yours Or the tutorial linked in the very first post.

  9. #39
    Join Date
    December 2009
    Location
    Hungary
    Posts
    162
    Quote Originally Posted by Pennybags View Post
    So this is all that's needed when going from 11,12-16? Not all the code posted by AJH16 above?
    I think so, but no knows for sure

  10. #40
    Join Date
    January 2010
    Location
    Alaska
    Posts
    4
    Is there any way someone can post an SQL update for upgrading from Beta 6 to Beta 16? Need to upgrade my server, and I have NO idea what changes were made from 6 to 16.

    Thanks,
    Jared

  11. #41
    Join Date
    December 2009
    Location
    Hungary
    Posts
    162
    Quote Originally Posted by JaredC01 View Post
    Is there any way someone can post an SQL update for upgrading from Beta 6 to Beta 16? Need to upgrade my server, and I have NO idea what changes were made from 6 to 16.

    See post #34.

  12. #42
    Join Date
    December 2009
    Location
    France
    Posts
    11
    Beta 17 is out, can you help us

    EDIT : my bad, tuto has been updated : http://docs.google.com/Doc?docid=0Ae...TI5ZmNnZzN3YzI

  13. #43
    Join Date
    February 2010
    Location
    CT, USA
    Posts
    7
    What I am wondering is why the hell this has to be such a complicated process?

    Why is there not just a built in auto update feature?

    I'm just some dude hosting a server for some friends to chat on. I can't afford to bust my ass trying to figure this crap out...


    I guess they figured the less user friendly they make it the more people will just go buy paid hosted servers...

  14. #44
    Join Date
    December 2009
    Location
    Hungary
    Posts
    162
    Quote Originally Posted by Rbeuque74 View Post
    Beta 17 is out, can you help us

    EDIT : my bad, tuto has been updated : http://docs.google.com/Doc?docid=0Ae...TI5ZmNnZzN3YzI
    I've updated it again, as it turns out two of the SQL query lines were not needed. I used strikethrough to label them.

  15. #45
    Join Date
    December 2009
    Location
    Hungary
    Posts
    162
    Quote Originally Posted by SolidSnake3035 View Post
    What I am wondering is why the hell this has to be such a complicated process?
    Why is there not just a built in auto update feature?
    I'm just some dude hosting a server for some friends to chat on. I can't afford to bust my ass trying to figure this crap out...
    I guess they figured the less user friendly they make it the more people will just go buy paid hosted servers...
    Yeah, it's really irritating. I could live with it though for the early stage of the publice beta, if the TS devs would at least provide the exact database upgrade instructions. But they just don't. The info in the tutorial is from community members, who have the SQL knowledge to figure out the necessary commands themselves. Which at some times of course led to contradictory SQL commands

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [Not Supported] [Mini-Tutorial] How to copy permissions from group x to group y
    By Soljia in forum Server Support
    Replies: 6
    Last Post: July 4th, 2016, 09:16 AM
  2. [TUTORIAL] Easy Teamspeak3 Linux Server Upgrade Guide
    By IrocZspoT in forum Linux / FreeBSD
    Replies: 1
    Last Post: January 5th, 2014, 08:54 AM
  3. [Mini-tutorial] Cloning Permission Groups!
    By willy_sunny in forum Permission System
    Replies: 5
    Last Post: July 12th, 2010, 03:15 PM
  4. [Mini-Tutorial] Fix ServerAdmin Lost Password (MYSQL)
    By Appleboy in forum Server Support
    Replies: 2
    Last Post: December 24th, 2009, 02: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
  •