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

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

プラットフォームについて: Server と Data Center のみ - この記事は、サーバーおよびデータセンター プラットフォームのアトラシアン製品にのみ適用されます。

問題

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

原因

Global permissions table is empty. 

ソリューション

  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');
    tip/resting Created with Sketch.

    Please backup JIRA before proceed to run the SQL queries here.

  4. Jira を再起動します。





最終更新日 2018 年 11 月 14 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.