Migrating the Access Server and Gateway databases

On the original server, where Tomcat/Gateway/PostgreSQL are running now:

Backup the Access Server's database

1. Stop the Acronis Access Tomcat service
2. Open the Acronis Access PostgreSQL Administrator application and connect to the database server. You may be prompted to enter the password for your postgres user.
3. Expand Databases and right-click on the acronisaccess_production database.
4. Choose Maintenance -> Vacuum and press OK.
5. Expand the database, expand Schemas and expand Public. Take note of the number of the Tables section. This will help you verify that the database transfer is successful.
6. Close the PostgreSQL Administrator and open an elevated command prompt.
7. In the command prompt, navigate to the PostgreSQL bin directory.

   e.g. cd "C:\Program Files\Acronis\Access\Common\PostgreSQL\9.3\bin"

8. Enter the following command: pg_dumpall --host localhost --port 5432 --username postgres --inserts --file alldbs_inserts.sql
   • alldbs_inserts.sql will be the filename of the backup. It will be saved in the PostgreSQL bin directory. You can use a path in the above command if you wish to save it somewhere else - e.g. change the last part of the command above like so: --file D:\Backups\alldbs_inserts.sql
   • If you are using a non-default port, change 5432 to the correct port number.
   • If you are not using the default PSQL administrative account postgres, please change postgres to the name of your administrative account in the command above.
9. Copy the backup file to the new machine that will host the Access Server.
10. Copy the certificates you use for the Access Server to the new machine.
11. If you plan to migrate the File Store, copy over those files. For a large File Store this could take some time. For more information, read Moving the FileStore to a different location.

Backup the Gateway Server's database

1. Stop the Acronis Access Gateway service.
2. Go to the Gateway Server database folder, by default located at:

   C:\Program Files (x86)\Acronis\Access\Gateway Server\database

3. Copy the mobilEcho.sqlite3 file to the new machine that will host the Gateway Server.

Additional files to backup

If you've made changes to any of these files, it is recommended to make backups so you can transfer your settings when restoring or migrating your Acronis Access product.

• web.xml located by default at C:\Program Files (x86)\Acronis\Access\Access Server\Web Application\WEB-INF\. Contains Single Sign-On settings.
• server.xml located by default at C:\Program Files (x86)\Acronis\Access\Access Server. Contains Tomcat settings.
• krb5.conf located by default at C:\Program Files (x86)\Acronis\Access\Common\apache-tomcat-7.0.59\conf. Contains Single Sign-On settings.
• Your certificates and keys used for Acronis Access.
• Custom color schemes located by default at C:\Program Files (x86)\Acronis\Access\Access Server\Web Application\customizations\.
• pg_hba.conf located by default at C:\Program Files\PostgreSQL\9.2\data\.
• newrelic.yml file if you are using New Relic to monitor your Acronis Access server.

On the new server that will be hosting the Acronis Access Server, perform the following steps:

Install Acronis Access

1. Start the Acronis Access Advanced installer and press Next. Read and accept the license agreement.
2. Choose Install and follow the installer screens.

   Note: If the Access Server, PostgreSQL, Gateway are going on separate machines, choose Custom and select the desired component(s).

3. On the PostgreSQL Configuration screen enter the same password for the PostgreSQL Super-User that was used on the original server. Press Next.
4. Review the components being installed and press Install.
5. Once the installer is done, press Exit and dialog will come up telling you the Configuration Utility will run next.
6. When the Configuration Utility comes up, leave it open without pressing OK or Apply.

Restore the Access Server database

Note: We strongly recommend that you run a test backup/restoration outside of your production environment.

1. Open the Services control panel and stop the Acronis Access Tomcat service.
2. Open the Acronis Access PostgreSQL Administrator application, connect to the local database server, select Databases, and confirm there is a database called acronisaccess_production.
3. Right-click on the database and select Refresh.
4. Expand it and expand Schemas, expand Public and verify that there are zero (0) Tables.
   • If there are any tables in the database, right click on the database and rename it to oldacronisaccess_production. Finally, go to Databases, right-click and create a new database called acronisaccess_production.
5. Close the PostgreSQL Administrator and open an elevated command prompt.
6. In the command prompt, navigate to the PostgreSQL bin directory.

   e.g. cd "C:\Program Files\Acronis\Access\Common\PostgreSQL\9.3\bin"

7. Copy the database backup file alldbs_inserts.sql (or whatever you have named it) into the bin directory.
8. In the command prompt, enter the following command: psql -U postgres -f alldbs_inserts.sql
9. Enter your postgres password when prompted for it.

   Note: Depending on the size of your database, the restore can take some time.

10. After the restore is complete, close the command prompt window.

Restore the Gateway Server database

1. Copy the mobliEcho.sqlite3 Gateway Server database that came from the old server into the new Gateway Server's database folder (by default C:\Program Files (x86)\Acronis\Access\Gateway Server\database) replacing the existing file.

Configure your new server

Note: It is highly recommended that you do not change the DNS names used by Acronis Access, only the IP addresses they are pointing to.The following instructions assume you are re-using the DNS names of the previous instance of Acronis Access.

1. Go back to the Acronis Access Configuration Utility that you left open and set the settings for the Gateway Server, Access Server and File Repository.
2. Click Apply, and then OK. At the next dialog click OK and a browser will launch with the Acronis Access web interface.
3. Log into the Access server.
4. Click on Administration. Navigate to the Mobile Access -> Gateway Servers page.
5. In the list of Gateway Servers you should see your Gateway server listed.
6. If the address for your gateway server is a DNS entry you should not need to make any changes to the server as long as the DNS entry is now pointing to your new server machine.If the address for your gateway is an IP address, then you will need to edit the gateway server.

Verify Acronis Access administrative settings

Once you have successfully finished your database's restoration, we highly recommend that you login to the web interface and verify that your settings have carried over and that they are still relevant before proceeding with anything else. Here are some examples of important items to check:

• Audit Logging - Make sure that the new Acronis Access logs folder has all the necessary permissions so that logs can be written.
• New Relic - If you are using New Relic, copy the newrelic.yml file from the old machine to this one and make sure that the path in the Acronis Access web interface points to the file.
• Administration settings - Make sure all your LDAP, SMTP and general administrative settings are correct.
• Gateway Servers and Data Sources - Make sure all your Gateway Servers are still reachable on the correct addresses and check if all your Data Sources have valid paths.