Can't Log In To JIRA - No Global Permission In Database

Still need help?

The Atlassian Community is here for you.

Ask the community

This Knowledge Base article was written specifically for the Atlassian Server platform. Due to the Functional differences in Atlassian Cloud, the contents of this article cannot be applied to Atlassian Cloud applications.

Problem

None of the users including Administrators can log in:

The following appears in the atlassian-jira.log:

2015-08-14 08:58:12,536 http-bio-6410-exec-24 anonymous 538x1508x1 1vkjf6z 10.60.2.104 /login.jsp The user 'user' is NOT AUTHORIZED to perform to login for this request
2015-08-14 08:58:12,536 http-bio-6410-exec-24 anonymous 538x1508x1 1vkjf6z 10.60.2.104 /login.jsp login : 'user' tried to login but they do not have USE permission or weren't found. Deleting remember me cookie.
2015-08-14 08:58:12,568 http-bio-6410-exec-24 anonymous 538x1508x1 1vkjf6z 10.60.2.104 /login.jsp The user 'user' is NOT AUTHORIZED to perform this request
2015-08-14 08:58:20,585 http-bio-6410-exec-24 anonymous 538x1509x1 1vkjf6z 10.60.2.104 /login.jsp The user 'user2' is NOT AUTHORIZED to perform to login for this request
2015-08-14 08:58:20,585 http-bio-6410-exec-24 anonymous 538x1509x1 1vkjf6z 10.60.2.104 /login.jsp login : 'user2' tried to login but they do not have USE permission or weren't found. Deleting remember me cookie.
2015-08-14 08:58:20,618 http-bio-6410-exec-24 anonymous 538x1509x1 1vkjf6z 10.60.2.104 /login.jsp The user 'user2' is NOT AUTHORIZED to perform this request

Cause

Global permissions table is empty. 

Resolution

  1. Check the GlobalPermissions

    select * from globalpermissionentry;
  2. If any of the below is missing, we need to update the table

      id   |  permission  |      group_id
    -------+--------------+---------------------
     10000 | ADMINISTER   | jira-administrators
     10001 | USE          | jira-users
     10006 | SYSTEM_ADMIN | jira-administrators
  3. To update run the below queries:

     insert into globalpermissionentry values (10000,'ADMINISTER','jira-administrators');
     insert into globalpermissionentry values (10001,'USE','jira-users');
     insert into globalpermissionentry values (10006,'SYSTEM_ADMIN','jira-administrators');

    (warning) Please BACKUP JIRA before proceed to run the SQL queries here.

  4. Restart JIRA

 

 

 


Last modified on Mar 30, 2016

Was this helpful?

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