Rebuild default permissions

[leepfrog]

Hello all,

back when TS3 was still beta I started to host a few virtual servers, this was before i_group_auto_update_type was introduced.
When the update was delivered which required i_group_auto_update_type to be set I did not read the changelog/install instructions and this lead to my permission system not adapting/autofilling any new permissions added.
In the past I used serverquery to grant new rights I explicitly needed, but the issue continues throughout the database and so most groups do not have values assigned for new permissions.

What I want to do now is to clear this mess up. So I am looking for a tool/a to reapply these i_group_auto_update_type changes retrospectively OR recreates all default permissions.

I have tried permreset but this didnt do it.

Any suggestions?

Thanks!

[SilentStorm]

This will be pretty hard to do, especially because your Database is likely way out of date with current Defaults.

Choices I see (from easiest / less time consuming to hardest / most time consuming):

1. 
   
   • Create snapshots of each of your Virtual Servers and save them. (see serversnapshotcreate - there is a shellscript for linux in some sticky around the forums which might help)
   • Stop the entire Instance.
   • Rename the Database File (ts3server.sqlitedb). (Or in case of mysql Db: Export the Database (using phpMyAdmin or mysqldump) and then clear the database so its doesn't contain any Tables).
   • Update the Server to the latest release
   • Start the Server which will create a new Database with all the current defaults.
   • Deploy the Snapshots created before. ( see serversnapshotdeploy - IIrc same shellscript might come in handy for this task as well.)
   • Use permreset on every Virtual Server and pray it works.
   • Fix any missing Group Assignments / Channels.
2. 
   
   • Stop the entire Server Instance.
   • Delete the Database File (or in case of mySQL clear the database of all tables)
   • Update the Server
   • Start the Server and recreate everything from scratch.
3. 
   
   • Create a new TS3 Server Instance (on your local PC for example) which will create a new Database with all the current Default Permissions.
   • Compare the two Databases and manually fix the differences between the two of them.

[leepfrog]

Hi SilentStorm,

thanks for your reply - I went with your first suggestion and it worked like a charm!