MongoDB Atlas Manual Setup

NOTE Before you begin, ensure all the prerequisites in MongoDB Atlas section are complete.

Once Infoworks has been installed, you can set up MongoDB Atlas using the following steps:

Migrating Infoworks Metadata from Infoworks-managed MongoDB to the Atlas Cluster

You must take a dump of the Infoworks-managed MongoDB and restore that dump into the Atlas cluster.

Step 1: Go to Infoworks Edge Node as the Infoworks user and verify Infoworks-managed mongo is up and running.

cd /opt/infoworks/bin

source env.sh

./status.sh

Step 2: Take a dump from the Infoworks-managed MongoDB in the temp directory.

cd /opt/infoworks/temp

mkdir atlassetup

cd atlassetup

mongodump -u infoworks -p IN11**rk -d infoworks-new

mongodump -u infoworks -p IN11**rk -d quartzio

Step 3: Restore the dump into Atlas.

NOTE Change the cluster URL, username, and password in the connection string. Also Change the database names below with database names from the configuration list only if different. The database name in the new Atlas cluster is defined by the -d parameters in the command below.

mongorestore --uri "mongodb+srv://<username>:<password>@my-mongodbcluster.xyz.mongodb.net" -d infoworks-new dump/infoworks-new/

mongorestore --uri "mongodb+srv://<username>:<password>@my-mongodbcluster.xyz.mongodb.net" -d quartzio dump/quartzio/

Configuring Infoworks to use Atlas cluster

Step 1: Encrypt the mongo user password, we will only store the encrypted password in conf.properties:

/opt/infoworks/apricot-meteor/infoworks_python/infoworks/bin/infoworks_security.sh --encrypt -p <password>

Step 2: Note the encrypted value for use in the further steps.

Step 3: Stop all Infoworks services which include mongo.

cd /opt/infoworks/bin

./stop.sh all mongo

Step 4: Take a backup of conf.properties.

cd /opt/infoworks/conf

cp conf.properties conf.properties.backupatlas

Step 5: Open conf.properties in an editor, such as vi and locate the following configuration key:

metadbip=<local host FQDN>

Step 6: To set the Atlas cluster details, update the following configurations.

NOTE Ensure that there are no duplicate keys, locate and edit the existing keys. In case the keys are new, add them.

metadb_managed=false

metadb_use_srv=true

metadbhostname=<atlas cluster url>

metadbip=<atlas cluster url>

primary=<atlas cluster url>

metadbName=infoworks-new

quartzMetadbName=quartzio

metadbUserName=infoworks

metadbPassword=<encrypted mongo user password>

metadb_connection_options=maxIdleTimeMS=60000

Step 7: After validating the config changes, restart all services:

NOTE After Atlas migration, there is no need to start Mongo service since it is now not an Infoworks managed service.

cd /opt/infoworks/bin

./start.sh all

Removing MongoDB Binaries and Data from Infoworks Edge Node

After verifying that Mongo Atlas is successful, take a backup of the old mongo directory and remove the old mongo binaries and data directory from the Infoworks installation:

cd /opt/infoworks/resources

tar czf mongo_bin_backup.tgz mongodb/

rm -r mongodb/