Restoring JIRA from CLOUD to Server all issues are missing

[Belinda Tinsley]

We are migrating our users on JIRA cloud onto our on JIRA server instance. We followed the KB article and we are faced with 2 issues:

1. All projects are visible on our (temp) local JIRA instance BUT no issues appear under any projects, where are they?

2. We cannot login. We tried sysadmin and admin

Version 7.10.2

[Belinda Tinsley]

Thanks, we already tried resetting the login counts too.

We are re-installing and restoring again and this time, enabling the outgoing mail during the setup to see if that will help.

[Alexey Matveev]

Hello,

Are you sure that there were no errors during the backup?

You can login to the database with a database manager and change the password for the admin user with this SQL:

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

the password will be -   sphere. 

[Belinda Tinsley]

We re-did our backup and restore and now problem 1 is resolved but we still cannot login. We did try what you suggested but we get:

userid is required for captcha 

In about 1.5 hours we will try to disable captcha from the db manager and hope that resolves our issue.

[Belinda Tinsley]

https://confluence.atlassian.com/jirakb/disable-captcha-from-the-jira-application-database-333807702.html 

How do we disable captcha if this returns 0 records:

SELECT s.* 
FROM   propertyentry e 
       JOIN propertystring s 
         ON e.id = s.id 
WHERE  property_key = 'jira.maximum.authentication.attempts.allowed'; 

[Alexey Matveev]

Try this KB

https://confluence.atlassian.com/jirakb/how-to-reset-failed-login-count-from-jira-application-database-329352344.html