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; } } }

Confluence test environment replica from production

vivuu

We are in process to replicate confluence prod which is running behind a reverse proxy to another test server with same configuration should be reflect here.

version 5.10.0, windows 2012, MSSQL DB.

steps followed.

1) installed confluence same version in new windows server (didnt complete the setup as it is asking new db creation but we want to map to existing db)

2) Db backup taken from PROD DB and restored in Test DB server

3) replaced the newly installed confluence home directory with copied production home directory.

4) made the db information changes in confluence.config file

5) started the confluence service, but getting below error.

"Spring Application context has not been set"

tried all troubleshooting steps given in sites as permission part and everything but still same issue

Accepted answers

Brant Schroeder

I would redo the installation as it sounds like a permission issue. This time when you do the installation attach it to a DB and let it complete. I would ensure that confluence starts. Then stop the service restore your DB to the newly created DB and copy over the confluence home directory and update your config file. If everything was working and stops after you copy everything over I would look at the confluence home directory permissions that might be migrating with the windows files. I would ensure that the the proper permissions have been applied to the home directory files for confluence to run.

Davin Studer

These are the steps I take when I refresh our non-prod environment and they haven't failed me yet.

1. Make sure World Wide Web Publishing Service is stopped.
2. Uninstall Confluence from the non-prod server.
3. Remove Atlassian folder. C:\Program Files\Atlassian
4. Delete the Confluence database on non-prod
5. Create a new database called Confluence and make the confluence database user a db_owner.
6. Run these two SQL statements against it
a. ALTER DATABASE Confluence COLLATE SQL_Latin1_General_CP1_CS_AS
b. ALTER DATABASE Confluence SET READ_COMMITTED_SNAPSHOT ON WITH ROLLBACK IMMEDIATE
7. Install the same version of Confluence as is currently in prod to the non-prod server.
8. Launch the site in a browser.
9. Install a Production installation
10. Visit my.atlassian.com to get a developers license for Confluence.
11. Put the license into the web page
12. Select Microsoft SQL Server as the External Database
13. Enter your databse credentials
14. Set user management to Manage users and groups within Confluence
15. Install using a blank or demo site. It doesn't matter.
16. Finish the Confluence setup.
17. Stop the Atlassian Confluence service on the non production server.
18. Take a backup of the production Confluence database.
19. Delete the Confluence database on the non production server.
20. Restore the backup of prod to the non production server.
21. Make sure after the restore that the DB owner is sa.
22. Zip the Confluence home directory on the production server. (C:\Program Files\Atlassian\Application Data\Confluence)
23. Copy the zip file from the production server to the non production server.
24. Unzip the file and move all of the contents except the index folder, temp folder, logs folder, the confluence.cfg.xml, and the file called "lock" to the C:\Program Files\Atlassian\Application Data\Confluence folder on the non production server.
25. Delete the index folder on the non production server and then create a new folder called index.
26. Move the edge and plugin folders from the production index folder to the non production index folder that you just created.
27. Run these two sql statements against the non-production database
a. delete from Confluence.dbo.BANDANA where BANDANAKEY = 'atlassian.confluence.smtp.mail.accounts'
b. delete from Confluence.dbo.BANDANA where BANDANAKEY = 'atlassian.confluence.space.mailaccounts'
28. Apply any changes made to prod files. Examples below ...
a. Database connections in C:\Program Files\Atlassian\Confluence\conf\server.xml
b. Service startup parameters
c. SSL reverse proxy setup in C:\Program Files\Atlassian\Confluence\conf\server.xml
d. Importing Domain Controller cert chain into C:\Program Files\Atlassian\Confluence\jre\lib\security\cacerts for LDAPS
e. Custom changes made to C:\Program Files\Atlassian\Application Data\Confluence\confluence.cfg.xml
29. Restart the Atlassian Confluence service.
30. Set the Server Base Url in Confluence Admin -> General Configuration.
31. Go to Confluence Admin -> Administration -> Content Indexing and rebuild the index.

All comments

Brant Schroeder

vivuu

HI Brant,

Thanks for your quick reply.

But here we have some issues here.

The infra team here restored the DB to new server as per our suggestion, as we thought we can directly restore and point the new confluence to the restored DB. So are you telling like there is no posibility to do that ? (create one db and drop that then restore Db will be a hectic work for them if we ask and it is handling by another team). I hope there will be other posibilities to do without creating a fresh DB and restoring it. Eg: If DB server got crashed, we have to go for a restore from the backup and there what can we do.

Please suggest us your valuable comment.

vivuu

content Deleted

Davin Studer

These are the steps I take when I refresh our non-prod environment and they haven't failed me yet.

Davin Studer

You should not post your config file above. It contains you license key and username and password. If you cannot delete it let me know and I'll delete it for you.

vivuu

Hi Davin,

Thanks the steps are well clear. But here we are stuck with the restored DB.

We havent created a fresh Db and completed the installation in non-prod. we just installed confluence and tried to map to the restored DB my making change in the confluence config.xml file.

Here we are stuck because we dont have Db access to again create and restore the Db as its handling by some other team.

Do we have any solution the way which we followed. ?

Davin Studer

No, you need to install with a fresh database and complete the install.

One thing to note on Microsoft SQL server is that just because you may have SQL logins on prod and non prod with the same user name it will not automatically map up to the restored database because the SID (backend SQL Server user identifier) will be different between the two servers. So, the DBA will need to remove the Confluence database user from the restored database and then add the user from the non prod system to the restored database as a db_owner. Also, make sure that the database connection is correct in the confluence.cfg.xml for these keys ...

hibernate.connection.password
hibernate.connection.url
hibernate.connection.username

vivuu

We have migrated all our applications, Crowd, Jira, Bitbucket, Confluence to Test environment from Prod Servers.(By application data and DB data store to Test environment)

But , The application integration to Test Crowd and between Test applications how can make to Test Configuration for these applications, without affecting PROD

1)Test Crowd Should authenticate all test environemnt applications (Currently test crowd containing map with Prod application IP Addresses)

2)How The integration Between These applications in test environment can be replaced to Test application integration by removing PROD links

Since Production Data are copied and DB are restored, Now the test applications will be having old trace with the production instances. How to revert it with test instances and what are the files need to be edited for enabling the integration

vivuu

We have migrated all our applications, Crowd, Jira, Bitbucket, Confluence to Test environment from Prod Servers.(By application data and DB data store to Test environment)

But , The application integration to Test Crowd and between Test applications how can make to Test Configuration for these applications, without affecting PROD

1)Test Crowd Should authenticate all test environemnt applications (Currently test crowd containing map with Prod application IP Addresses)

2)How The integration Between These applications in test environment can be replaced to Test application integration by removing PROD links

Since Production Data are copied and DB are restored, Now te test applications will be having old trace with the production instances. How to revert it with test instances and what are the files need to be editedd for enabling the integration

vivuu

We have migrated our PROD setup of Confluence to Test environment and its working fine as expected. Here the data of Application directory and SQL DB were taken and restored are 30 days before.

Now we have to make the Test Confluence data to be updated till the date of today in PROD. How we can achieve this?

Please share us the all the possible ways.

Nic Brough -Adaptavist-

See https://community.atlassian.com/t5/Confluence-questions/Update-Test-Confluence-with-Delta-change-till-today/qaq-p/675433