Forum


Notice to all users

We are migrating towards a new forum system located at community.teamspeak.com, as such this forum will become read-only on January 29, 2020

Page 2 of 6 FirstFirst 1234 ... LastLast
Results 16 to 30 of 82
  1. #16
    Join Date
    June 2007
    Location
    in a house.
    Posts
    98
    nop
    .
    i download the DB.
    open sqlman.
    opened the ts3 SQL db
    paste the 18 lines.
    clicked the proper button.
    no errors (18 times)
    closes sqlman ,than it asked my to SAVE, pointing to the SQL database.

    when looking at the DB its 2K in size instead 220 it was.
    so, something is going wrong..
    Last edited by spatieman; December 26th, 2009 at 03:09 PM.

  2. #17
    Join Date
    June 2007
    Location
    in a house.
    Posts
    98
    and yes, when aplying the 18 lines, the stuff is saved, but i cant see changes in size.
    But what ever i do, it ALWAYS ask me to save, when i do yes, the size is 2KB.
    unless i say no..

  3. #18
    Join Date
    June 2007
    Location
    in a house.
    Posts
    98
    ok, i ingnored all stuff.
    just closed, not saving, uploaded the DB, server still is working..

  4. #19
    Join Date
    December 2009
    Location
    Hungary
    Posts
    162
    Quote Originally Posted by spatieman View Post
    nop
    closes sqlman ,than it asked my to SAVE, pointing to the SQL database.
    From the tutorial:

    "When quitting sqliteman, it might ask if you want to save your file. That's not about the database file, as it gets updated and saved as soon as you execute SQL statements. The save question is about saving the changed top right query window's content."

  5. #20
    Join Date
    May 2006
    Location
    canada\quebec
    Posts
    23
    there is an error in the section : "I missed 6 additional lines from version 5!"

    here is the corrections if you are using MYSQL with Teamspeak 3:

    insert into server_properties (server_id, id, ident, value) values ('1', '1', 'virtualserver_log_client', '0');
    insert into server_properties (server_id, id, ident, value) values ('1', '1', 'virtualserver_log_query', '0');
    insert into server_properties (server_id, id, ident, value) values ('1', '1', 'virtualserver_log_channel', '0');
    insert into server_properties (server_id, id, ident, value) values ('1', '1', 'virtualserver_log_permissions', '1');
    insert into server_properties (server_id, id, ident, value) values ('1', '1', 'virtualserver_log_server', '0');
    insert into server_properties (server_id, id, ident, value) values ('1', '1', 'virtualserver_log_filetransfer', '0');

    Edit : 26 december 2009
    Last edited by corotte; December 26th, 2009 at 09:31 PM.

  6. #21
    Join Date
    December 2009
    Location
    Hungary
    Posts
    162
    Quote Originally Posted by corotte View Post
    there is an error in the section : "I missed 6 additional lines from version 5!
    "

    here is the corrections
    You mean removing the " from the table names? I think that since sqliteman doesn't return an error, it doesnt matter if you have " " characters around the table names.

  7. #22
    Join Date
    December 2009
    Location
    Hungary
    Posts
    162
    I just realised that if you execute the sqliteman query multiple times when updating the database the tables will be modified each time without any error messages returned, meaning that you will have multiple rows inserted with the same content! Having multiple rows with the same values might cause unexpected errors!

  8. #23
    Join Date
    May 2006
    Location
    canada\quebec
    Posts
    23
    Quote Originally Posted by MoXNoX View Post
    You mean removing the " from the table names? I think that since sqliteman doesn't return an error, it doesnt matter if you have " " characters around the table names.
    I was correcting this script for those who use MYSQL cause MYSQL give error when you put " at the table names.

  9. #24
    Join Date
    December 2009
    Location
    Hungary
    Posts
    162
    Yeah, I mention in the guide that the "s should removed for MySQL queries, but you're right, it's easier to remove them in the first place.

  10. #25
    Join Date
    May 2006
    Location
    canada\quebec
    Posts
    23
    Quote Originally Posted by MoXNoX View Post
    I just realised that if you execute the sqliteman query multiple times when updating the database the tables will be modified each time without any error messages returned, meaning that you will have multiple rows inserted with the same content! Having multiple rows with the same values might cause unexpected errors!
    I can confirm that this does'nt occur with MYSQL (tested) so it's probably (not sure) caused by sqliteman

    EDIT: try HEIDISQL for updating your MYSQL database. It's free and work really well.

    Oh, i forgot, thanks for giving us the query to update our server. IT REALLY help having the last fixes.

  11. #26
    Join Date
    December 2009
    Location
    Czech
    Posts
    7

    problem

    I made update SQL instructions yet when editing the server can not set virtualserver_log_client (etc) to 1

    Do you know where is the problem?

  12. #27
    Join Date
    August 2005
    Location
    Clifton Park, NY
    Posts
    5
    I was looking in to this as well. Thank your for posting your queries. It got me pointed in the right direction, but I think that the queries listed are incomplete. I modified your approach a little by pulling a complete Diff of the SQL folders in beta1 and beta9. I found that the defaults.sql was the only relevant difference (there is also a change to a sql query that is used by TS3 internally, but that isn't relevant here). I have put together an update script that should be all inclusive of the beta1 to beta9 changes. I wrote it so that it will only update or delete default permissions that were configured by TS3's initialization. If you have altered a permission since installation, that permission will not be altered.

    My procedure:
    1) Extract the SQL folder from the old and new version ZIP files.
    2) Use a tool like Total Commander or some other utlitity that can compare files by content to identify the files that are different between the two folders. Alternatly, you can skip this step and step 3 and simply check defaults.sql as it is the only file I have seen change yet. This may not catch all changes in the future though.
    3) Check if files contain :id1: kinds of fields, these files can be ignored as these appear to be queries used by TS3 internally.
    4) Use a diff utility like P4Merge to analyse the differences between each set of files. If a line is new, keep the insert, if a line is removed, modify it to a delete, if the line is changed, check for the differences and change it to an UPDATE to the values in the new line WHERE the values match the old.
    5)Apply this update script to your DB and enjoy.

    Queries (beta1 to beta9):
    Code:
    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, 2, 0, "b_virtualserver_modify_log_settings", 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_priority_speaker_dimm_modificator", 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_command", 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_log_settings", 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_priority_speaker_dimm_modificator", 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_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_virtualserver_modify_autostart", 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_ft_quotas", 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_ft_settings", 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_hostbutton", 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_log_settings", 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_maxclients", 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_port", 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_priority_speaker_dimm_modificator", 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_client_issue_client_query_command", 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_modify_log_settings", 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_modify_priority_speaker_dimm_modificator", 75, 0, 0);
    delete from perm_server_group where server_id=0 and id1=4 and id2=0 and perm_id='b_client_ban_list' and perm_value = 1 and perm_negated = 0 and perm_skip = 0;
    delete from perm_server_group where server_id=0 and id1=4 and id2=0 and perm_id='b_client_complain_list' and perm_value = 1 and perm_negated = 0 and perm_skip = 0;
    delete from perm_server_group where server_id=0 and id1=5 and id2=0 and perm_id='b_client_ban_list' and perm_value = 1 and perm_negated = 0 and perm_skip = 0;
    delete from perm_server_group where server_id=0 and id1=5 and id2=0 and perm_id='b_client_complain_list' and perm_value = 1 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_modify_autostart' 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_modify_ft_quotas' 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_modify_ft_settings' 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_modify_hostbanner' 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_modify_hostbutton' 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_modify_hostmessage' 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_modify_maxclients' 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_modify_port' and perm_value=100 and perm_negated=0 and perm_skip=0

  13. #28
    Join Date
    December 2009
    Location
    Hungary
    Posts
    162
    Wow, pretty useful information there, good job AJH16!

    So you're saying that using your query will only update or delete default permissions, i.e. even when upgrading from version 3 to 10, the whole script can be executed, as the database changes introduced by version 2 won't be modified again.

    My other question is, where are the server_properties changes, like virtualserver_log_permissions?

    And the Teamspeak crew is still dead silent on how to upgrade the database... Most annoying.

  14. #29
    Join Date
    December 2009
    Location
    Paris - France
    Posts
    2

    Importing saved database content into fresh installed DB ?

    Hi, thank you for the tuto 1st !
    It explained me why I was missing so many fields.

    Quick question: why is it not possible to save, let's say a beta 3 DB version, install a brand new (and fresh with ALL latest fields and permissions) beta15 and import data from the saved database ?

    Is it just a question of writing the proper SQL script ?
    Or is there another issue like encryption keys ?

    PS: Sorry if stupid question, but that's more than 20 years I have not really worked with SQL

  15. #30
    Join Date
    August 2005
    Location
    Clifton Park, NY
    Posts
    5
    Probus. The problem is two fold. First, there could theoretically be changes in the structure of the DB that would make loading from another DB impossible. The second, bigger and more likely issue, is that in the version 15 DB, there are many default values. When you try to load the version 3 DB, there is no way to tell what are old default values, what are new default values, and what are actually changes you have made. Say for example that in version 3 there were 3 default values 1, 2 and 3. You then added a custom value 4. Well now in version 15 there may be defaults 1, 2, 3 and 4. There is no way for the system to know that your 4 is different from the previous 4 when trying to merge. Instead, it is neccessary to analysed the differences between the start of 3 and the start of 15 and alter only the necessary rows and structures to ensure compatibility. I hope that explanation helps.

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
  •