The current confluence version used is v5.6.3
Latest Confluence version is 7.7.2

Initial read up shows we can directly upgrade from existing version to v7.0
https://confluence.atlassian.com/doc/upgrading-confluence-manually-255363437.html

[~aloraine] Could you please upload the latest copy of the confluence backups for me to start planning the playbooks.

Please see drive folder for confluence backups.

After running into several errors best possible solution to upgrade confluence seems to be the following.
1. Backup the spaces that are needed following the steps on link below.
https://confluence.atlassian.com/display/CONF43/Exporting+Confluence+Pages+and+Spaces+to+XML?_ga=2.64998630.81440753.1598312975-1876299205.1595446590

2. Setup New Confluence Instance using Ansible(I have already started working on developing the playbooks).

3. Load the zip file using the steps mentioned in the
https://confluence.atlassian.com/display/CONF43/Restoring+a+Space

Additional Notes
There are differences in the mysql compatibilities and java versions used in the latest version and the existing in-use version of the confluence.

Exported the "IGB User's Guide" space to a zipped XML file and saved to shared drive.
Chester Dias - please check to make sure it contains everything needed, esp. image files.
file name is: Confluence-space-export-135549-135472.xml.zip

Exported the "Developers Guide" space to a zipped XML file and saved to the above shared drive.
file name is: Confluence-space-export-140140-135475.xml.zip

Notes about Java version
Incorrect Java version can throw compatibility issues with commands in the execution scripts that are not recognized. some commands are deprecated and removed to the point being no longer supported or recognized. The Java execution commands are located in the bin folder inside setenv.sh, catalina.sh, start-confluence.sh.

Notes about MySQL
The new mysql5.7 has a slightly different connection string as compared to the earlier version. storage_engine is no longer recognized

Notes about instance size
Although this should not be an issue during testing, but Confluence demands the requirement of having a large type server for its memory requirements while the disk space initially can be less.

Notes about License Key
The license key for Confluence unlike in the case of Jira is located in the Confluence Home folder in the file confluence.cfg.xml. This also has details like DB connections, Server ID, etc.

Notes about the Mysql Java Driver
The mysql Java driver name is being flagged as changed to com.mysql.cj.jdbc.Driver from earlier com.mysql.jdbc.Driver . Possible reason being use of a recent mysql connector jar.
The confluence setup does not come with a connector jar. This Jar has to be downloaded manually from a maven repository.

[~aloraine] The SQL file in the Drive does not seem to contain any data. Could you please check that?.

Please also provide me the Repository for adding playbooks.

Also, Would you like me to look into Cloudformation here? This seems like the smallest use case since we don't have multiple services involved as such(Just EC2 instance no involvement of much security group changes).

Directly uploading the backup zip file of a space on the latest version works as expected.
I have checked a few child pages, a few images, and links to be in working condition.

[~aloraine] This is a temporary link for testing only.
http://100.25.10.47:8090/display/igbman/About+the+User%27s+Guide

request:

• remove the "test" and "demo" spaces (do these show up by default?)
• modify the side panel (on left) to look like the production version (no "blogs" link or "pages" link)

http://52.45.117.194:8090/display/igbman/Home

Those seem to be showing up by default, They are configurable to be removed. I have removed them from the link

The MySQL database does not seem to get populated with the user details.
[~aloraine] Could you please verify that the existing Mysql DB used by the confluence is getting backed up correctly?
[~aloraine] Please also provide me a repository for the confluence playbooks.

I am working on the MySQL problem mentioned.
attn: Chester Dias

Please see the google drive

• a new SQL file is uploaded
• a new "zip" file is uploaded with "IGB Release Documentation" space

Repository:

https://bitbucket.org/lorainelab/confluence-playbooks

http://ec2-23-20-156-126.compute-1.amazonaws.com:8090/display/igbman

Please let me know if all looks fine

[~aloraine] Can you provide me all the httpd settings files from the existing server?

https://bitbucket.org/chesterdias/chester-local-confluence-playbooks/branch/IGBF-2513#diff

Will do.
Please note:
The existing server consists of multiple Docker containers, including one for Apache. Keep it in mind when looking at the settings.

Sorry for the delay. Configuration files sent via email.

All changes completed. Reverse proxy setup is working as expected.
Please review: https://bitbucket.org/chesterdias/chester-local-confluence-playbooks/branch/IGBF-2513#diff

Chester Dias - please submit PR.

https://bitbucket.org/chesterdias/chester-local-confluence-playbooks/pull-requests/1/igbf-2513/diff

Attn Chester Dias:

The target of the pull request needs to be master branch on the upstream repository. Submit a new PR.

Done: https://bitbucket.org/lorainelab/confluence-playbooks/pull-requests/1/igbf-2513/diff

Merged.

Closing for now. Will migrate next month.