JIRA password reset after Import

B_ Normann P_ Nielsen

I am importing a customers JIRA on a 4.4 (Exported from a 4.4)

But I cant login no matter what afterwards. I am running:

Disable CROWD:

{code}

update cwd_directory set active=0 where id=2;

{code}

Reset password as in: https://confluence.atlassian.com/display/JIRA044/Retrieving+the+JIRA+Administrator:

{code}

update cwd_user set credential='uQieO/1CGMUIXXftw3ynrsaYLShI+GTcPS4LdUGWbIusFvHPfUzD7CZvms6yMMvA8I7FViHVEqr6Mj4pCLKAFQ==' where user_name='admin';

{code}

Reset Capcha

{code}

update cwd_user_attributes set attribute_value=0,lower_attribute_value=0 where user_id=10000 and (attribute_name='login.currentFailedCount' or attribute_name='login.totalFailedCount');

{code}

Eller

{code}

update cwd_user_attributes set attribute_value=0,lower_attribute_value=0 where user_id=10000;

{code}

I have used diffent versions of the last SQL.

Login just fails, there are nothing in the catalina.out and after 3 tries, Captcha is required...

I can see the cwd_user_attributes table being updated and JIRA is restartet after SQL's

Thomas Peter Berntsen

Hi Normann,

No DB hacking of the target JIRA instance should be necessary in order to achieve this, as long as you ensure that you replace the admin user's hashed password in the exported entities.xml file (inside the export zip file) before importing into the target JIRA instance.

Note: this solution only applies to scenarios involving an XML export.

Cheers,
Thomas