nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

recover jira admin account

vikesh1

my previous JIRA admin left the job his email id is deactivated

now i have to get access of JIRA admin i know only JIRA admin account name

i want to change password from db by the help of JIRA Help Guide

image2015-2-2 3:15:37.png

i gave password against the credential like

update cwd_user set

credential='mypassword' where user_name='admin';

after this i try to login with these credentials but couldn't access the account again

kindly help someone

image2015-2-2 3:15:37.png

Accepted answers

crf

Don't use 'mypassword' for the credential; use exactly what it shows in the example.

The password is hashed, and using one in plaintext will not work. The value in the example is a hashed version of 'sphere'. Then you can login in as 'admin' with the password 'sphere' and change it to something else.

All comments

Nic Brough -Adaptavist-

You cannot poke in a password - JIRA has the more secure model of storing a password hash, so the password is not retrievable. You must poke in the password hash.

If you use the hash given in the documentation you have found, you will also find that the password you can use is listed on that page ( sphere ). Once you can login with that standard password, you can immediately change it to your own chosen password.

crf

Don't use 'mypassword' for the credential; use exactly what it shows in the example.

vikesh1

i did same as

update cwd_user set

credential='uQieO/1CGMUIXXftw3ynrsaYLShI+GTcPS4LdUGWbIusFvHPfUzD7CZvms6yMMvA8I

7FViHVEqr6Mj4pCLKAFQ==' where user_name='adminjira';

restart JIra

and gave username = adminjira

and password = sphere

but still getting error like below

image2015-2-2 3:59:9.png

i am giving CAPTCHA and password again and again but it showing same

still couldn't access

image2015-2-2 3:59:9.png

vikesh1

Hi chris i did same as update cwd_user set credential='uQieO/1CGMUIXXftw3ynrsaYLShI+GTcPS4LdUGWbIusFvHPfUzD7CZvms6yMMvA8I 7FViHVEqr6Mj4pCLKAFQ==' where user_name='adminjira'; restart JIra and gave username = adminjira and password = sphere but still getting error like below Sorry, your userid is required to answer a CAPTCHA question correctly. i am giving CAPTCHA and password again and again but it showing same still couldn't access

crf

Then perhaps the account has been disabled (the 'active' column in cwd_user) or does not have the correct groups assigned to it (the cwd_membership table covers this). It is easy enough to clear the captcha requirement (controlled by the cwd_user_attributes rows for that user ID), but it won't do any good if the account isn't actually allowed to log in. Maybe it would be easiest to update the e-mail address that is stored on the user account so you can reset it normally?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-administration