Cloud to Server export users can't log in

Summary

Backup taken from Cloud doesn't allow users to login after import in Server.

Credentials sysadmin username/password as mentioned on Migrate from Confluence Cloud to Server - Atlassian Documentation don't work.

Environment

• Confluence Cloud

Steps to Reproduce

1. Create a Confluence Cloud export
2. Install latest Confluence Server
3. On the set up page, use the Cloud XML export to import a full site
4. Log in as sysadmin/sysadmin

Expected Results

sysadmin user is able to login using password sysadmin

Actual Results

sysadmin user is not able to login.

Notes

The export doesn't contain the passwords for any of the users.

The sysadmin account is not fully created. There is no entry for sysadmin in cwd_user table and no cwd_membership table entries, but there is a sysadmin entry in the user_mapping table.

Workaround

See

• Restoring Passwords To Recover Admin User Rights

To add an admin user to the database with password admin

1. Shutdown Confluence
2. Run this SQL insert to create the admin user with password admin

   insert into cwd_user(id, user_name, lower_user_name, active, created_date, updated_date, first_name, lower_first_name, last_name, lower_last_name, display_name, lower_display_name, email_address, lower_email_address, directory_id, credential) values (1212121, 'admin', 'admin', 'T', '2009-11-26 17:42:08', '2017-11-26 17:42:08', 'System', 'system', 'Administrator', 'administrator', 'System Administrator', 'system administrator', 'admin@example.com', 'admin@example.com', (select id from cwd_directory where directory_name='Confluence Internal Directory'), 'x61Ey612Kl2gpFL56FT9weDnpSo4AV8j8+qx2AuTHdRyY036xxzTTrw10Wq3+4qQyB+XURPWx1ONxp3Y3pB37A==');
   insert into user_mapping values ('2c9681954172cf560000000000000001', 'admin', 'admin');
   

1. Add the admin user to the confluence-users and confluence-administrators groups

   insert into cwd_membership (id, parent_id, child_user_id) values (888888, (select id from cwd_group where group_name='confluence-users' and directory_id=(select id from cwd_directory where directory_name='Confluence Internal Directory')), 1212121);
   insert into cwd_membership (id, parent_id, child_user_id) values (999999, (select id from cwd_group where group_name='confluence-administrators' and directory_id=(select id from cwd_directory where directory_name='Confluence Internal Directory')), 1212121);
   

1. Restart Confluence
2. Log in as user admin with password admin