Forum

Page 1 of 6 123 ... LastLast
Results 1 to 15 of 82
  1. #1
    Join Date
    December 2009
    Location
    Hungary
    Posts
    162

    [Mini tutorial] How to upgrade your server

    Edit by mod
    This tuto is for an old version. Don't use the sql part.


    I just made a multiplatform server upgrade tutorial for people who are still scratching their heads about upgrading the server. If you spot any problems or have any feedback, feel free to post.
    Last edited by florian_fr40; October 25th, 2011 at 09:46 AM.

  2. #2
    Join Date
    December 2009
    Location
    US
    Posts
    29
    Thank you for this but I have a couple questions...

    The file I have is named ts3server.sqlitedb not what you wrote... Same thing I am assuming?

    Second; When I go to close the program it asks me if I want to save the file. Should I or do I not need to?

  3. #3
    Join Date
    December 2009
    Location
    Hungary
    Posts
    162
    Yeah, that was just a mistype on my part. Thanks for pointing it out, I fixed it.

    Saving the file at the end is not necessary, it's just a backup action. Then again, just to be sure, check the file modification date to see if it got changed or not.
    Last edited by MoXNoX; December 24th, 2009 at 03:05 AM.

  4. #4
    Join Date
    December 2009
    Location
    Vancouver, BC
    Posts
    89
    What about those of us using MySQL databases and not the SQLite db?

  5. #5
    Join Date
    December 2009
    Location
    Hungary
    Posts
    162
    As I wrote in the tutorial, use your favorite MySQL tool, like the query window of phpmyadmin.

  6. #6
    Join Date
    December 2009
    Location
    North Carolina
    Posts
    1
    Maybe I missed something but is this tutorial addressing going from the release 2.x version of the server (and database schema) to the beta 3.x version of the server (with the database changes you mentione (i.e. multiple inserts)).

  7. #7
    Join Date
    December 2007
    Location
    Austria,Linz
    Posts
    214
    Ahh thanks!

  8. #8
    Join Date
    December 2009
    Location
    Hungary
    Posts
    162
    Quote Originally Posted by Mayhem_Longbow View Post
    Maybe I missed something but is this tutorial addressing going from the release 2.x version of the server (and database schema) to the beta 3.x version of the server (with the database changes you mentione (i.e. multiple inserts)).
    Yes, you missed something. It's a general guide for upgrading the server, even though it specifically mentions the database changes in version 2 and 5.

  9. #9
    Join Date
    December 2009
    Location
    Hungary
    Posts
    162
    Updated with 4 additional SQL commands that I missed before.

  10. #10
    Join Date
    June 2007
    Location
    in a house.
    Posts
    98
    readed your tutorial.
    ok, perhaps i am stupid, but if we copy ALL files over the old one, should not all files be upgraded to .
    or am i missing a point..
    patching the own sqlite DB,goes with sqliteman ,ok, but can i download the sqlite_db and patch it with windows, and upload it again ?

    server is linux, so, therefor the question..

  11. #11
    Join Date
    December 2009
    Location
    Hungary
    Posts
    162
    Quote Originally Posted by spatieman View Post
    ok, perhaps i am stupid, but if we copy ALL files over the old one, should not all files be upgraded to .
    or am i missing a point..
    Sorry, I don't understand what you'd like to say here


    On your database question, yes, you can upgrade the database on Windows a client and then transfer back the database to your Linux server.

  12. #12
    Join Date
    June 2007
    Location
    in a house.
    Posts
    98
    ok, well, i never did any DB upgrades.
    but just for this, what if i do the DB clean command when i start the server?
    wil the new flags not be added automaticly ?

    but incase not.

    i have now beta9 on my box.

    copy/pasting all things to insert, like on your tut page.

    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, "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, "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, "i_needed_modify_power_client_issue_client_query_c ommand", 75, 0, 0);
    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');
    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_modi ficator", 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_priori ty_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_virtualserver_modify_priority_speaker_dimm_modi ficator", 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_priori ty_speaker_dimm_modificator", 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_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, "i_needed_modify_power_virtualserver_modify_log_se ttings", 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_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, "i_needed_modify_power_virtualserver_modify_log_se ttings", 75, 0, 0);

    these i have to insert?

  13. #13
    Join Date
    June 2007
    Location
    in a house.
    Posts
    98
    well..
    i only got a script started and script finish in script output, but no other message.
    and after saving the SQL went fro m230K to 2K ,so, oeps, yes i made a mistake..
    when i browse theclean DB, i dont see any entry at all...

  14. #14
    Join Date
    June 2007
    Location
    in a house.
    Posts
    98
    ok, did a better reading, did clicked the 1st line.
    saw all messaging coming, NO ERRORS.
    after saving, DB still is 2K

    what ever i do, the DB after save is 2 KB...
    dont think that should happen..

    and when opening that DB ,it show me pure crap..
    Last edited by spatieman; December 26th, 2009 at 12:53 PM.

  15. #15
    Join Date
    April 2005
    Location
    Germany
    Posts
    25
    Quote Originally Posted by spatieman View Post
    ok, did a better reading, did clicked the 1st line.
    saw all messaging coming, NO ERRORS.
    after saving, DB still is 2K

    what ever i do, the DB after save is 2 KB...
    dont think that should happen..

    and when opening that DB ,it show me pure crap..
    Doing sql arguments on a database will change the db instant, with no way to undo your commands.

    I think you tried to save the sql commands or something ike that. So after doing the sql commands with sqliteman you dont have to save anything. Just close the tool, and start your server, or upload the db to your machine, what case ever you are in.

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, 08:16 AM
  2. [TUTORIAL] Easy Teamspeak3 Linux Server Upgrade Guide
    By IrocZspoT in forum Linux / FreeBSD
    Replies: 1
    Last Post: January 5th, 2014, 07:54 AM
  3. [Mini-tutorial] Cloning Permission Groups!
    By willy_sunny in forum Permission System
    Replies: 5
    Last Post: July 12th, 2010, 02:15 PM
  4. [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
  •