31.1 Prerequisites for Upgrading the Appliance

Before you upgrade, complete the following prerequisites:

  1. You must have Sentinel 8.3.1 or later installed.

  2. You must have SLES 12 SP3 or SLES 12 SP4 installed.

    1. (Conditional) If you are on SLES 11 SP4 with Sentinel 8.3.1, it is recommended to get all the channel updates on SLES 11. Then upgrade the OS to SLES 12 SP3. For more information about upgrading the SLES operating system, see Download and execute the post upgrade utility from the Micro Focus Patch Finder website.

    2. (Conditional) If you are on SLES 12 SP3 with Sentinel 8.3.1 and executed the post upgrade utility sentinel_sles_iso_os_post_upgrade-release-73.tar.gz, then you have to download and execute post upgrade utility sentinel_sles_iso_os_post_upgrade-release-85.tar.gz from Micro Focus Patch Finder website.

    3. (Conditional) If you are on SLES 12 SP3 with Sentinel 8.3.1 and executed the post upgrade utility sentinel_sles_iso_os_post_upgrade-release-85.tar.gz from Micro Focus Patch Finder website, then follow the steps from Upgrading the Appliance.

  3. IMPORTANT:If you are on upgraded version of Sentinel 8.3.1 or fresh installation of 8.3.1 follow the steps from Upgrading the Appliance.

    (Conditional) Migrate Security Intelligence data, alerts data, and so on from MongoDB to PostgreSQL. You can perform this only after completing the previous prerequisites. For more information about migrating data, Migrating Data from MongoDB to PostgreSQL.

    You must run the migration script even when you do not have data to migrate because the migration script generates a cleanup script. You can use the cleanup script to remove MongoDB data, which will be redundant after you upgrade Sentinel.

31.1.1 Migrating Data from MongoDB to PostgreSQL

You must migrate Security Intelligence data, alerts data, and so on from MongoDB to PostgreSQL by running the migration script.

The migration script does the following:

  • Migrates Security Intelligence data and alerts data to PostgreSQL.

  • Generates a cleanup script that you can use to remove data and MongoDB related RPMs from MongoDB.

WARNING:After you migrate data, you must upgrade Sentinel before you start or restart Sentinel. This is to ensure that there is no loss of data coming to Sentinel.

To migrate data:

  1. Download Mongo_To_PostgreSQL_Migration_Utility_8.3.1-5575.tar.gz from the Download Website website.

  2. Untar the files.

  3. Log in to the appliance console as a novell user.

    IMPORTANT:Run the migration script from terminal of the machine. Do not use an emulation terminal software like PuTty or MobaXterm.

  4. Run the following script: mongo_to_pgsql_migration.sh.

  5. Select the migration option as per your requirements.

    WARNING:Ensure that you select the appropriate option because you cannot repeat this procedure after the migration is successful.

    If your data is migrated successfully, a confirmation message will be displayed on the screen. You can now upgrade the appliance.

  6. (Conditional) If the data migration is not successful:

    1. Clean up the migrated data. For more information, see Cleaning Up Data From PostgreSQL When Migration Fails.

    2. Repeat this procedure to migrate data.

  7. (Conditional) If you see the following error when running the migration script, complete the tasks mentioned in Unable to Run the Migration Script:

     
     8101server:/opt # su novell
    novell@8101server:/opt>
    novell@8101server:/opt> ./mongo_to_pgsql_migration.sh
    ./mongo_to_pgsql_migration.sh: line 25: /bin/setenv.sh: No such file or directory
    Cannot execute ./mongo_to_pgsql_migration.sh as novell
    novell@8101server:/opt>
    novell@8101server:/opt> exit
    exit
    8101server:/opt #
    8101server:/opt # ./mongo_to_pgsql_migration.sh
    ./mongo_to_pgsql_migration.sh: line 25: /bin/setenv.sh: No such file or directory
    Cannot execute ./mongo_to_pgsql_migration.sh as root