recover jira admin account

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

 

 

 

3 answers

1 accepted

2 votes
Chris Fuller Atlassian Team Feb 01, 2015

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.

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 :(

Chris Fuller Atlassian Team Feb 01, 2015

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?

1 votes

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.

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 :(

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,863 views 12 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot