I attempted to upgrade Confluence from 5.4 to 6.0 and then 6.0 to 6.7 but the latter upgrade had failed. Unfortunately, I can't go back to reinstall from the start because SQL server had to be upgraded to comply with the supported platforms for Jira upgrade at the same time.
Below is the error message I receive:
I have tried going through the logs and following troubleshooting guides but it's gotten a bit overwhelming for me as I've been handling both Confluence and Jira. Any workaround or guidance would be appreciated.
My recommendation is to restore the database and home directory to the last working version (6.0?) and then follow Upgrading Confluence. Please note from the doc I linked:
XML backups should not be used to upgrade Confluence.
If I understand correctly, it is your Confluence admin permissions and not your database permissions you are asking about. If so, we are in luck. If you completed the upgrade to Confluence 6.7, you may use recovery mode to gain access as described in Restore Passwords To Recover Admin User Rights
If you are on 6.0 you may regain access by running the SQL queries on this page - same title, different content: Restore Passwords To Recover Admin User Rights
Please check your <confluence_home>/logs/atlassian-confluence.log for entries related to whether the upgrade ran into errors. It's a good practice after upgrading.
I look forward to your next update.
The application is installed as a service.
I followed the steps to enable the recovery admin login and restarted the service. Upon attempting to login I am bounced back with this error:
"Log In - Confluence
Hi my Community friends! For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...
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