Unable to login after migrating Jira Clioud to Local Server

[Dennis Worsham]

I am trying to migrate our JIRA Cloud app to a local server install (version 6.4).  After creating a backup on cloud, and using that backup .zip as a restore for the local server I can no longer log in. I have seen several seemingly related posts like:

https://jira.atlassian.com/browse/JRA-37574 (which seems specific for 6.2 & 6.2.1)  And have tried Retrieving the JIRA Admin as described here:
https://confluence.atlassian.com/display/JIRA/Retrieving+the+JIRA+Administrator#RetrievingtheJIRAAdministrator-2.Setthepassworddirectlyinthedatabase

Also the import steps on email settings so I can't request an email to reset password.

Seems like it should be something I should be able to do easily in SQL, but not seeing how.  Any help would be greatly appreciated.

[Jaime S · Accepted solution]

Hi, Dennis.

Even after resting the password for an administrator in the database, you're unable to log in? Were there any users to set?

My first thought would be that the import failed and the users were not imported, that's why you wouldn't have access. In this case, the documentation for retrieving the JIRA Administrator should work, even if you have to create the user.

If that is not working, please raise a support request at https://support.atlassian.com

I hope it was helpful.

Kind regards,
Jaime Kirch da Silveira
Atlassian Cloud Support

[Dennis Worsham]

Hi Jamie, Thanks for your quick response. Users were imported, I can see them in table, but when i try to login as user or sysadmin I get: 'sysadmin' tried to login but they do not have USE permission or weren't found. (in atlassian-jira-security.log) Tried changing several different logins of different access levels (including sysadmin) with: update cwd_user set credential='uQieO/1CGMUIXXftw3ynrsaYLShI+GTcPS4LdUGWbIusFvHPfUzD7CZvms6yMMvA8I7FViHVEqr6Mj4pCLKAFQ==' where user_name='XXXX'; from https://confluence.atlassian.com/display/JIRA/Retrieving+the+JIRA+Administrator but no luck. I will open a support ticket. Thank you.

[Jaime S]

Are you using LDAP? This sounds like this problem: https://confluence.atlassian.com/display/JIRAKB/LDAP+users+unable+to+login+due+to+incorrect+User+Name+Attribute If you are, you could mention it in the ticket.

[Dennis Worsham]

No LDAP. Although I did try installing a different cloud hosted jira instance locally and that worked. There are quite a few differences between the 2 but one that stands out to me is that in the broken one, there are 2 listings for pretty much every user in cwd_user. In the working one each user has only one entry. Tried various combinations on deleting one of the 2 entries and changing directories, etc... but still can't get it working.

[Dennis Worsham]

Turns out this was the case. Or at least that data in the tables related to perms/groups were very different between the two. Thanks Jamie for sharing that link. Definitely pointed me in the right direction!

[Jaime S]

That's great to hear, Dennis!