I did an export of my production confluence which has its internal user directory turned off, and is looking at Jira for its users. This instance has a server running the application and a separate server running the DB (as suggested for production instances).
I am trying to stand up a dev environment, but have selected a trial instance (Cant remember if that is what its called, but the non-production option, where there is no dedicated DB server). I looked through some of the logs, and it looks like the import may have hung at one point, but the instance is still running it seems.
My question is:
1. How can I set my internal user directory (while there is no dedicated DB server) without being able to access the GUI
2. How can I set my sysadmin password without being able to log into Confluence (without dedicated db server). I have found this article, but it didnt seem to work https://confluence.atlassian.com/doc/restore-passwords-to-recover-admin-user-rights-158390.html
The Trial option installs an H2 evaluation database. This article describes how to connect to it using either DB Visualizer or the H2 console to run SQL against it: Embedded H2 Database
Please try the SQL queries on this page: Restore Passwords To Recover Admin User Rights. I started to link you straight to the sections that cover the internal directory and the admin password, but it is actually a good idea to review the whole article to avoid trouble. (For example, sometimes people skip to the admin password without making sure the admin account is active or set the internal directory active but don't move it to the top of the hierarchy.)
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.Read more
Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...
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!
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