Just migrated from cloud to server and there is no admin user (no external db)

I can not log in because my admin doesnt work. and I can not resend pw because there is no email configured. Isn´t it strange that I have done a migration with 1 user (admin) and now it is not loggable?

2 answers

0 vote

The docs say a system admin account called sysadmin with a password of sysadmin will be created in the export, and you'll need to use that to grant users the rights they need

Unfortunately that doesn´t work, and that page of the documentation seems deleted

We are talking about Confluence server, not Jira, right?

Ah, sorry, I went for the standard bookmarks.

IT's https://confluence.atlassian.com/confcloud/migrate-from-confluence-cloud-to-server-724765578.html

Which uses the same user and password, so it's the same problem.

Your options if you've forgotton what you changed the password to are:

  • Re-import the Cloud backup, as it'll have sysadmin/sysadmin in it
  • Hack the password in the database.  This might be hard if you're using the internal demo database though

I have reinstalled everything, no errors, PostgreSQL ok, license ok, cloud backup ok, and same error: sysadmin user/pw does not work. 


Ann Worley Atlassian Team Aug 22, 2017

Let's go the "hack the password in the database" route mentioned by Nic: 

Restore Passwords To Recover Admin User Rights

Since you are using PostgreSQL and not the embedded database, it is pretty straightforward.

I am following that guide, useful, but I am still trying to achieve the first step (DBV installed and connected to the DB)

Sin título.png

That code goes...?

I don't understand the question.  You say you are stuck on the first step and then paste in a query that is the next step.  In neither case do you explain the problem you are having.

Where are you actually stuck?

This code: where shoud I paste it in DBVisualiser. It is connected to de DB, I have been looking for that some kind of box to type but I just find menus and buttons... 

Ah, ok.  I don't know, I don't use DBVisualiser.  I go with command line mostly.  There should be an option for "run plain sql" somewhere in it.

Ty for your patience, Nic. I am learning a ton today.

I found it but it only shows in paid version...

The other command line is not the command prompt, is it?

Or Query tool into PostgreSQL Admin?

You are right, it's not quite the same thing as a command line.

When I said command line, I'm thinking of the database command line.  For postgres, you usually install the server along with "psql" as a client.  It's not pretty, you just run your sql or service commands by typing things and get plain text output, but it does the basics in a minimal way.

Ok ty very much. I think it is enough for now, I feel there is something not very well done by me in the db install process. 

By the way is this normal, to have two DBs instead of one?

Sin título.png

Yes, postgres stores a load of data about the databases it holds in a database.  You can, and should, ignore the postgres database.

It may be a problem with the user Confluence uses.

In this guide, step 3, is it mandatory to set a password for that user? the guide doesn´t say so...

Yes, you need a password, as you'll need Confluence to log into the database to use it!

Ok understood, now this are the rest of the settings, are them ok for the user?


Looks right.

Thinking out of the box... if I install a blanc or demo space instead a backup from cloud, and then I configure and create a user a usual, and then I go to restore from backup and I try to restore a my cloud backup in the server once installed, Will it work? os is it necesary to configure as confluence backup since the beggining?

Yes, importing into a working confluence will be fine.

Suggest an answer

Log in or Sign up to answer
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 Thursday in Confluence

Color tables for a shiny Confluence page

...; ## Developed by: Alana Fernando ## Shared with love ## @param style:title=style type|type=enum|required=true|desc=Choose a style.|enumValues=Style1,Style2,Style3,Style4,Style5 ## @param alignment:title...

348 views 16 18
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