sysadmin user not created in site export

Summary

When migrating from Confluence Cloud to Confluence Server, users must export a Confluence Cloud site export. When doing so, the export should create an administrator user (sysadmin) that can be used to login to the new Server environment, per Migrate from Confluence Cloud to Server.

This user is no longer being created.

Environment

• Confluence Cloud instance
• Most recent version of Confluence Server

Steps to Reproduce

1. In the Confluence Cloud instance, create a site backup
2. Install the most recent version of Confluence Server with an external database
3. Import the site backup from step 1 into the server instance.
4. Try logging in with the sysadmin user.

Expected Results

You should be able to login as an administrator with sysadmin and/or another admin user.

Actual Results

The sysadmin user does not exist in the site export and the admin users that already exist in the instance cannot login.

Workaround

Administrators will need to manually create an administrator user via the database:

1. Shut down the Confluence Server instance after you've imported the Cloud backup
2. Create a new admin user by running:

    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', '2009-11-26 17:42:08', 'A. D.', 'a. d.', 'Ministrator', 'ministrator', 'A. D. Ministrator', 'a. d. ministrator', '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');
    

3. Add new groups by running:

    insert into cwd_group(id, group_name, lower_group_name, active, local, created_date, updated_date, description, group_type, directory_id)
    values ( '888888','confluence-administrators','confluence-administrators','T','F','2011-03-21 12:20:29','2011-03-21 12:20:29',NULL,'GROUP',(select id from cwd_directory where directory_name='Confluence Internal Directory'));
    insert into cwd_group(id, group_name, lower_group_name, active, local, created_date, updated_date, description, group_type, directory_id)
    values ( '999999','confluence-users','confluence-users','T','F','2011-03-21 12:20:29','2011-03-21 12:20:29',NULL,'GROUP',(select id from cwd_directory where directory_name='Confluence Internal Directory'));
    

4. Add group memberships into cwd_membership:

    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);
    

5. Set the password for the admin user to admin by running the following command:

    update cwd_user set credential =
    'x61Ey612Kl2gpFL56FT9weDnpSo4AV8j8+qx2AuTHdRyY036xxzTTrw10Wq3+4qQyB+XURPWx1ONxp3Y3pB37A=='
    where id=1212121;
    

6. Start Confluence
7. Login with the following credentials:
   Username: admin
   Password: admin