Cannot log into Confluence after moving servers

I just moved our Confluence setup from one server to another the big item to note is the new server is in a new private network. The set up was using Jira to serve the usernames/passwords for logins, so Confluence was configured to point to the Jira server on the same network.
When I moved Confluence, I dumped everything to a backup on the old server, and then just restored from that file on the new server.
Nobody can login though because the old server was pointed at a Jira instance that the new server can't get to.

How can I change the Jira server that Confluence points to for its usernames and passwords if I can't get logged into Confluence in the first place? I'm assuming this has to be database driven somewhere so which table/value should I change?

2 answers

1 accepted

3 votes
Accepted answer

Ok! That was actually not the solution because what I originally asked about was not the strictly the problem.

For the record if you have access to the database you can change the URL used by Confluence to find any of its "directory"s for me I only had one so that was simply:

UPDATE `confluence`.`cwd_directory_attribute`
SET attribute_value='new jira URL' 
WHERE `attribute_name`='crowd.server.url';

That actually fixed the Confluence side. I just didn't know it yet because....

The missing piece was that apparently when you change servers, generally the server's IP address changes. Who knew right? Well it turns out that Jira restricts the IP addresses that are allowed to connect to its user server. Adding in the new IP address into JIRA along with making the change above, got me all set up and working.

2 votes
Daryl Chuah Atlassian Team May 06, 2013

Hi Michael

You may refer on this documentation on Restoring Passwords to Recover Admin User Rights

Hopefully it helps!

Cheers :)

Daryl Chuah Atlassian Team May 06, 2013

Yes exactly. This is because currently, confluence does not recognize the path to JIRA since you already migrated to a new server. Therefore, you will need to retrieve the Admin password and reconfigure confluence to point to the correct path to JIRA and set the correct directory order in confluence.

So you're saying I have to change the password for the local account 'admin' in the database, login as that then use the administration pages to make the necessary changes to point my 'new' Confluence at the 'new' Jira instance?

Thank you. This helped even if it wasn't exactly the answer I was looking for because my question wasn't the right one to be asking.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Feb 06, 2019 in Confluence

Try out the new editing experience

Hi team, I’m Avinoam, a product manager on Confluence Cloud, and today I’m really excited to let the Community know that all customers can now try out the new editing experience and see some of the ...

783 views 33 5
Join discussion

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