Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,464,822
Community Members
 
Community Events
176
Community Groups

Restting user's password

We have most of our users on tied to our existing LDAP and some users from other division where we have just created users that are not tied to our LDAP.

I am running in to a problem when one of the user that is not tied to the LDAP is trying to reset his password.

He is getting the following message:

You (or someone else) has requested to reset your password.

---------------------------------------------------------------------

This user account is managed in an external User Directory and JIRA is not able to update your password.

Please contact your System Administrator if you have any further queries.

Here are the details of your account:

---------------------------------------------------------------------

Username: mboccia

Email: mboccia@toronto.ca

Full Name: Michael Boccia

_____________________________________________________________________________________________________________________________

Is there a way I can reset this user's password for him.

1 answer

1 accepted

0 votes
Answer accepted
PauloP Rising Star Oct 03, 2012

Hi David

To restore the user password, just run the following SQL commands against your database:

- Find the user and its directory

select A.id, A.user_name, B.directory_name from cwd_user as A JOIN cwd_directory as B on B.id = A.directory_id where user_name like '%<username>%'

If you have the same user account present in multiple directories, you probably have a Delegated LDAP Directory and the user was previously create in this directory. So, if you might to use just the Internal Directory to authenticate this user, go to JIRA UI and remove the existing user (before, just double check the user directory).

- To change the user password to sphere

update cwd_user set credential='uQieO/1CGMUIXXftw3ynrsaYLShI+GTcPS4LdUGWbIusFvHPfUzD7CZvms6yMMvA8I7FViHVEqr6Mj4pCLKAFQ==' where id = <ID from previous SQL command>;

For further detail, perhaps the following link could be useful:

https://confluence.atlassian.com/display/JIRA051/Retrieving+the+JIRA+Administrator

Anyway, you may raise a support ticket at http://support.atlassian.com for further assistance.

Cheers,

Paulo Renato

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events