How to recover global permissions after they were removed in Fisheye and Crucible

Still need help?

The Atlassian Community is here for you.

Ask the community


Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.

Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.

*Except Fisheye and Crucible

Summary


By default, the Global Permissions in Fisheye & Crucible include the default groups: fisheye-users and crucible-users.

If all groups and users—default or custom—Access type was changed to None, all users associated with the removal would lose their license to authenticate.

(info) Note that the example is using the default configuration. As such, only the crucible-users and fisheye-users are listed in the global permissions. There are no users defined on the Users tab.

Environment

4.8.6

Diagnosis

  • Unable to authenticate to Fisheye/Crucible.
  • Using the REST API, list global permissions or users or groups.

    Example: /rest-service-fecru/admin/global-permissions/groups

    # The results are for the image above
    {"start":0,"limit":100,"lastPage":true,"size":1,"values":[{"name":"crucible-users","permissions":["CRUCIBLE_USER","FISHEYE_USER"]}]}


    (info) Note that the image shows a single group with global permissions, and the API results show the same group with global permissions. In the context of this issue, all groups and users were removed; therefore, no groups or users would return.


Cause

  • An Administrator changed the Access type of all groups and users to None.

Solution

The only way to add to the global permissions once all have been stripped is to modify the database.

(warning) If you are concerned with modifying your database, please reach out to Atlassian Support for an engineer to assist with your issue.

In the instructions below, the queries provided will insert the default groups with the necessary global permissions. 

(error) As we are modifying the database, please ensure you take a backup of your instance as we note in the instructions below.

How to insert the default global permissions:

  1. Shutdown Fisheye/Crucible
  2. Perform backup of your instance
  3. Connect to the database and execute and commit the insert queries:

    INSERT INTO cru_global_group_permission (cru_group_name, cru_global_permission) VALUES ('fisheye-users', 'FISHEYE_USER');
    INSERT INTO cru_global_group_permission (cru_group_name, cru_global_permission) VALUES ('crucible-users', 'FISHEYE_USER');
    INSERT INTO cru_global_group_permission (cru_group_name, cru_global_permission) VALUES ('crucible-users', 'CRUCIBLE_USER'); 
  4. Start Fisheye/Crucible



Last modified on May 21, 2021

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.