Versions Compared

Old Version 3

changes.mady.by.user Mark Anderson

Saved on

compared with

New Version 4

changes.mady.by.user Mark Anderson

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

ArangoDB Upgrade

The following outlines the steps to upgrade from ArangoDB version to another and then to upgrade CAD Publisher itself. We would always strongly recommend backing up your VM/Server prior to following these steps. These steps should take approximately 20-50 minutes to complete.

  1. Open Command Prompt
    On your Windows server that contains ArangoDB, in a command prompt, type

arangosh

Enter the root password.

...

Or from the browser GUI, the login page identifies this.

...

2. Or from the browser GUI, the login page identifies this.Shut down the Centro Web App to prevent any addtional changes to the database by shutting down Centro. First start wth the web app.

  1. Notify your user base on downtime.

  2. Make sure there are no files being processed in the Centro Pipeline Manager.

  3. Bring up IIS Manager on your web server.

  4. Click Stop on the right side.

...

3. Stop the Pipeline Host service

Stop and disable the Pipeline Host service to prevent it from restarting on its own.

  1. Bring up Services.

  2. Double click on Centro | Pipeline Host.

  3. Click Stop.

  4. Set the Startup type to Disabled.

  5. Click OK.

...

4. Stop the Pipeline Manager service

Stop and disable the Centro Pipeline Manager service to prevent it from restarting on its own.

  1. Again bring up Services.

  2. Double click on Centro | Pipeline Manager.

  3. Click Stop.

  4. Set the Startup type to Disabled.

  5. Click OK.

5. Back up the database

  1. Open a command prompt.

  2. Navigate to an approprate folder.

  3. On the command line, use the arangodump command.
    Usage:
    arangodump --server.database [database name] --output.directory “[dir name]”

    Notes:
    * The default Centro database name is ActifyDB.
    * The directory the files are exported to does not have to exist beforehand.

    Add --overwrite true if you rerun the command and want to overwrite the existing files.

Example

Code Block
arangodump --server.database ActifyDB --output-directory "dump" --overwrite true

At the time of this writing there are 75 collections dumped.

...

6. Store a copy

In case of a catastrophic failure, save a copy of the back up folder/files on a separate system or drive.

Make sure the separate system is secure and conforms to your organizations security protocols.

7. Stop arangodb3

Stop the ArangoDB service.

  1. Again bring up Services.

  2. Double click on ArangoDB.

  3. Click Stop.

  4. Click OK.

...

8. Save the Arangod.conf file

  1. Go to the c:\Progam Files\ArangoDB 3.8.x\etc folder.

  2. Find and save the arangod.conf file.

9.a Method A (ArangDB Upgrade)

Install the consecutive versions of ArangoDB until you are the latest Actify Supported version for your version of CAD Publisher. If your version of CAD Publisher supports up to ArangoDB 3.8 you can follow the example given below:

  • Examples:

    • Upgrading from ArangoDB 3.6 to ArangoDB 3.7.

    • Then Upgrading from ArangoDB 3.7 to ArangoDB 3.8.

    • Upgrading from 3.6 to 3.8 directly is not officially supported. The officially supported upgrade path in this case is 3.6 to 3.7, and then 3.7 to 3.8.

...

  1. Confirm compatability of your current ArangoDB to the CAD Publisher you’re wanting to upgrade on the link below, we would always recommend keeping your ArangoDB updated to avoid potential issues later on.
    ArangoDB Compatibility Chart (actify.com)

  2. Proceed to Upgrade the ArangoDB

  3. Proceed to Upgrade your CAD Publisher

If you questions or issues please reach out to Actify’s Technical Support Team at https://support.actify.com.Once the upgrades have been completed. Skip 9B to 14, Proceed to Step 15. Test for Completion.

9.b Method B (ArangDB Upgrade)

Uninstall Arangodb

  1. Open Programs and Features.

  2. Select ArangoDB3e 3.x.x in the list.

  3. Click Uninstall/Change.

...

4. Follow the uninstall wizard.

5. When asked do not delete ArangoDB user elements.

...

10. Install Arangodb Community 3.9.x

  1. Download ArangoDB Community version 3.9.x for Windows from ArangoDB. Get the .exe installation for easy installation.
    (https://www.arangodb.com/download/ )

  2. Double-click on the ArangoDB installation and follow the wizard instructions.

...

3. Once complete, stop the ArangoDB service in Services if it has started.

4. Adjust configuration such as any endpoint adjustments for GUI. The arangod.conf file can be found and edited in the C:\Program Files\ArangoDB3 3.9.2\etc\arangodb3 folder (depending if you’ve used the default and depending on the exact version).
You can apply the arangod.conf file save from step #8.

  1. If you utilize an encrypted link (SSL) between the database and Centro make those adjustments.

  2. Restart the ArangoDB service in Services,

11. Restore the database

On Windows, the database should still be intact. However, if you find that the database and the data is not there then restore the database through the following steps.

  1. Open a Command Prompt.

  2. Navigate to the folder above the folder where you dumped the database.

  3. From the ArangoDB Web GUI (localhost:8529), login as the root user.

  4. Select _System.

  5. Create an empty database with your database name
    (Centro defaults to “ActfyDB”).

  6. On the command line, use the arangorsetore command.
    Usage:
    arangorestore --server.database [database name] --output.directory “[dir name]”

Example

Code Block
arangorestore --server.database ActifyDB --input-directory “dump”

12. Start the Centro Web App

  1. Bring up IIS Manager on your web server.

  2. Click Start on the right side.

13. Start the Pipeline Host service

To start up the Pipeline Host service.

  1. Bring up Services.

  2. Double click on Centro | Pipeline Host.

  3. Set the Startup type to Automatic.

  4. Click Apply.

  5. Click Start.

  6. Click OK.

14. Start the Pipeline Manager service

To start up the Pipeline Manager service.

  1. Bring up Services.

  2. Double click on Centro | Pipeline Manager.

  3. Set the Startup type to Automatic.

  4. Click Apply.

  5. Click Start.

  6. Click OK.

15. Test for completion

Verify your update and data restore worked by conducting the following simple tests.

  • Verify the database is a Community version and is 3.9.x.
    To do this login to the web GUI.

...

Login to CAD Publisher.
Logging into CAD Publisher validates the database is accessible.

...

Read from database.
Navgate to a Catalog part in CAD Publisher.

...

Write to the database.
Conduct a pipeline file conversion . A success here indicates CAD Publisher can write to the database and pipelines are functioning.

...

or CentroSupport@actify.com