Migrating Confluence cloud to server: can't access

Hi.

I was migrated and restored confluence cloud backup to my new server.

I can't access to confluence after restoring backup. However, before restoring i had full access to confluence.

 

i'm unsuccessfully trying log in with my cloud credential.

I want setup integration with jira.

How can i log in to ?

1 comment

Mikael Sandberg Community Champion Oct 04, 2017

See if this works, it describe how to reset admin password, and how to add a local admin or how to add one if you do not have a local admin: https://confluence.atlassian.com/conf57/restoring-passwords-to-recover-admin-user-rights-701435450.html

i tried this method. i get error on the step of inserting values:

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

error:

[Code: 23505, SQL State: 23505]  Unique index or primary key violation: "CWD_GROUP_NAME_DIR_ID_INDEX_C ON PUBLIC.CWD_GROUP(LOWER_GROUP_NAME, DIRECTORY_ID) VALUES ( /* key:888888 */ null, null, 'confluence-administrators', null, null, null, null, null, null, 1)"; SQL statement:
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')) [23505-195]

Comment

Log in or Sign up to comment
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Sunday in Agility

You asked for it, so we delivered: images on issues have arrived

A picture tells a thousand words. And agility boards have just released their latest feature: cover images on issues – so now your board can tell a story at first glance. Upload attachmen...

135 views 1 10
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you