We need to create a ditto copy of our Confluence production server which has a huge amount of data. We want to do it for our test purposes. To achieve this, we followed below process.
1) Copied the existing app folder to new server at the same path.
2) Copied database (Oracle 12C) to a new server and gave it a new name.
3) Installed Confluence (same version, 7.1.2) on new server.
4) Set application-data in new installation
5) modified the confluence.cfg.xml file to reflect new database name.
After this we started Confluence on new instance. It starts and we are able to open it. But we are not able to login into it.
In the logs it gives lots database related errors. Like below:
Caused by: Error : 955, Position : 13, Sql = CREATE TABLE "AO_7CDE43_SERVER_CONFIG" (
"ID" NUMBER(11) NOT NULL,
), OriginalSql = CREATE TABLE "AO_7CDE43_SERVER_CONFIG" (
"ID" NUMBER(11) NOT NULL,
), Error Msg = ORA-00955: name is already used by an existing object
It seems it is trying to re-create all the tables. Can someone please guide as what wrong are we doing here. We just want to create a mirror image of Confluence server. Instead of using Confluence's own backup-restore function. We are trying to use direct copy from server to server and db to new db.
before upgrading/installing Confluence 7 on the new server, I would try to get it running with the old version. As we don't use Oracle I can only describe my steps when setting up a test/staging server:
1. Make a consistent backup of the Confluence database & restore the backup on the test database server using the SAME db name / schema etc...
2. Stop Confluence & create a copy of the install & data directories. Restart Confluence.
3. Restore the install & data directory on the test/staging application server using the exact same directory structure & access rights.
4. Edit the server.xml (Tomcat configuration) in the conf subdir
We use datasources controlled by Tomcat & not Confluence specific datasources. Therefore I only have to configure the resource settings for the JDBC datasource to point to the test/staging db server & check user & password.
I also configure disable mails send from the test server by setting:
-Datlassian.mail.senddisabled to true
in the system properties.
5. Depending on your server OS, you might want to register Confuence as a service.
6. Start the test server using the same user name used on your production server.
The test server should startup without any errors, apart from the disabled mailing.
Any upgrades to Confluence 7 should be done AFTER a successful migration to the test server.
- Create your own custom emoji 🔥 - "Shake for Feedback" on mobile 📱 - An endless supply of GIFs via GIPHY 🤩 Is there anything quite as nice as a pleasant surprise? Comment below with what...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events