Can't Log In To JIRA - No Global Permission In Database
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
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
Check the GlobalPermissions
select * from globalpermissionentry;
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
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');
Please backup JIRA before proceed to run the SQL queries here.
- Restart JIRA