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
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 :(
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 :(
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.