Summary

When site administrators create a site export of Confluence Cloud to import into a server instance, they find that the column credential in the {{cwd_user}}  table is NULL.

This poses major issues for users trying to migrate from Confluence Cloud to server, because Admins and normal users are unable to login to the new server instance. This issue is a spinoff of CONFCLOUD-52260, however, the issue is more widespread than the sysadmin user being unable to login - all users are unable to login because they have no password set.

Environment

• Confluence Cloud version: 1000.1903.0
• Confluence Server Version: 6.2.1 and above

Steps to Reproduce

1. Create a Confluence Cloud site backup following Create a site backup
2. Spin up a Confluence 6.2.1 or above Confluence Server instance with an external database of your choice
3. Restore the backup created in Step 1 into the Confluence Server instance.

Expected Results

Users, (including the sysadmin) should be able to login. Their Usernames and Passwords should be migrated over to the new database with the XML export.

Actual Results

No users are able to login. When looking at the output of select * from cwd_user;, you can see that there are no entries under the credential column for any user.

Workaround

Currently the only workaround is to regain admin rights to the instance, set up the Confluence email service for the stand alone instance, and then have users follow the password reset link on the login page to reset their passwords. Please see below for exact workaround instructions:

1. Follow Restore Passwords to Recover Admin User Rights
2. Once you are logged into Confluence standalone, you'll want to Configure a Server for Outgoing mail.
3. Once you have configured the mail server, please have users reset their passwords using the Forgot Password? link on the login page.