nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Shared users problem after migrating Confluence and JIRA to new server.

David FALLAS

I have migrated JIRA (v6.3.15) and Confluence (5.7) to a new debian server. I downloaded the respective .tar.gz files (not EAR/WAR) from the download archive page and extracted these into their respective newly created install directories (/opt/atlassian/JIRA and /opt/atlassian/confluence). Both systems are small and are currently configured to use the embedded database.

Following the instructions at https://confluence.atlassian.com/doc/migrating-confluence-between-servers-184150.html I have successfully started JIRA on the new server, added my current starter license, and performed a restore of the xml backup from the old server.

On the old server, Confluence was configured to share JIRA users. But now, when I start Confluence on the new server, the login fails - "Sorry, an error occurred trying to log you in. Please try again." Of course, trying again also fails.

I have re-created the Application Link to Confluence, but when being redirected to Confluence to apply the reverse link, the call fails.

Is there a way to create an administrator user in Confluence, or force a login somehow, so that I can recreate the Confluence Application Link manually?

Or is there another way out of what appears to be a Catch-22 situation?

Accepted answers

Steven F Behnke

Users are NOT shared via the Application Link. In other words, the Application Links are not the cause of your issue.

Confluence has a section in the Administration dedicated to User Directories. In this screen you can associate it to a new directory of type JIRA.

If you do not know any local or remote account in this application, you should follow the KB article on regaining access to Confluence – https://confluence.atlassian.com/doc/restore-passwords-to-recover-admin-user-rights-158390.html

All comments

Steven F Behnke

Users are NOT shared via the Application Link. In other words, the Application Links are not the cause of your issue.

Confluence has a section in the Administration dedicated to User Directories. In this screen you can associate it to a new directory of type JIRA.

David FALLAS

Hi Steven,

Thanks for your quick response. I have tried to follow the KB article, but I have never connected to the embedded database before

I installed DbVisualizer, and configured a connection to /var/atlassian/application-data/confluence/database directory. Unfortunately, when attempting to perform the first query in the article an exception was thrown which stated that the table could not be found. When I checked under the TABLES node, indeed, there weren't any. Is this a permissions problem? or could the data be stored elsewhere?

Another possible approach would be to delete everything and re-install both applications, choosing to use a PostgreSQL database instead. However, I do not know if the xml export from the embedded database can be restored to a PostgreSQL database.

Any further advice gratefully received.

David FALLAS

Update: I have managed to re-install both JIRA and Confluence and have restored data from their respective backups into new PostgreSQL databases. I have also, using the isntructions suggested by Steven, restored the internal admin user in Confluence - which I had to do in order to log back in once the installation was completed.

One residual issue however is that there are now two admin users in Confluence - one in the internal directory and another in the JIRA directory. I'll try to figure out how to resolve this.

Steven F Behnke

When you restore a backup, you'll also restore any local accounts associated with that backup (while removing anything you setup in the target system prior to restoring on that target system). You can mitigate this next time by ensuring there is an accessible local account in the system that you backup in the first place. Then you can use the account you already know exists when you restore the account to the target machine.

The HSQLDB evaluation database I cannot possibly help you with. I do not touch this database-type other than during trials or evaluations for clients. It is best used for testing or trial only. Atlassian does NOT support in-memory databases!

An XML-backup is database agnostic, so yes it works just fine in PostgreSQL as you've found out.

Finally, Is there an issue removing the user account? If you can't figure out how to proceed I can help there but you should probably tell me more of what's happening.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

jira

jira-administration

jira-core

confluence-administration