Skip to main content

Home

v4.5.1.x - Upgrade instructions

Note

We recommend using MySQL because Unravel generates reports which only work with MySQL.

Verify the database you are using before proceeding with the upgrade. If you are upgrading from,

  • 4.2.x or 4.3.x you should already be using MySQL either as an internal or external database

  • 4.4.x you might be using with PostgreSQL which was bundled

Important

These upgrade paths are valid for upgrading to v4.5.5.1

The following upgrade options are not supported:
  • Upgrade from 4.3.x

    • embedded MySQL to 4.5 using embedded PostgreSQL

    • external MySQL to 4.5 using embedded PostgreSQL

  • Upgrade from 4.4.x

    • embedded PostgreSQL to 4.5 using external MySQL

    • external MySQL to 4.5 using embedded PostgreSQL

Supported Installations/Upgrades
Fresh installation
  • Using MySQL (recommended)

    • Follow these preinstall instructions to install and configure MySQL before you install Unravel

  • Download and Install RPM

  • Post-Install steps if using MySQL

    • Follow the post-install instructions to Configure Unravel for MySQL

Upgrade 4.5.x
  • All that is required is an RPM upgrade.

Upgrade from 4.4.x
  • If your database is MySQL,

    • If the MySQL data has not been migrated to the new partitioned tables, then follow all the steps in Upgrade from 4.3.1.X section

    • If MySQL data is already migrated to partitions, then follow all the steps in Upgrade from 4.3.x section but skip the "MySQL Partitioning and Data Migration" step.

      • To check if the tables are already partitioned, execute the following command:

        echo "show table status like '%blackboards%'" | /usr/local/unravel/install_bin/db_access.sh 
  • If your database is PostgreSQL

Warning

If MySQL server is running as unravel_db in the same machine as Unravel Server after the upgrade, you must execute the following command so that unravel_all.sh starts/stops and shows status for unravel_db:

sed -i 's/unravel_pg/unravel_db/g' /etc/init.d/unravel_all.sh
Upgrade from 4.3.x
  • Embedded/external MySQL to 4.5 using external MySQL

Unravel 4.5 uses partitioned MySQL tables to manage the disk space and you must prepare for the upgrade.

Prepare for upgrade

  • Check the amount of disk space used by MySQL (Space_Used) via the CLI with the command

    • Embedded MySQL

      du -sh /srv/unravel/db_data
    • External MySQL

      grep "^datadir=" /etc/my.cnf | awk -F"[=]" '{print $2}' | xargs du -sh
  • Check the amount of disk space available in the database partition (Space_Available) via the CLI with the command

    • Embedded MySQL

      df -h /srv/unravel/db_data
    • External MySQL

      grep "^datadir=" /etc/my.cnf | awk -F"[=]" '{print $2}' | xargs df -h
  • If Space_Used > Space_Available then follow instructions to move MySQL data before continuing.

  • Copy the MySQL JDBC JAR to /usr/local/unravel/share/java/

    mkdir -p /usr/local/unravel/share/java
    sudo cp /usr/local/unravel/dlib/mybatis/mysql-connector*.jar /usr/local/unravel/share/java
  • Change the ownership of the directory and its contents. RUN_AS_USER and USER_GROUP are same as USER and GROUP from switch_to_user.

    chown -RL RUN_AS_USER:USER_GROUP /usr/local/unravel/share/java 

Upgrade

  • Download RPM

  • Install RPM

  • Complete the instructions at MySQL partitioning and data migration

  • RBAC properties have been changed. For properties, you must replace or add in order for RBAC to work, see here.

Warning

If MySQL server is running as unravel_db in the same machine as Unravel Server after the upgrade, you must execute the following command so that unravel_all.sh starts/stops and shows status for unravel_db:

sed -i 's/unravel_pg/unravel_db/g' /etc/init.d/unravel_all.sh
Upgrade from 4.2.x
  • 4.2.x (embedded MySQL) -> 4.5 (external MySQL)

  • 4.2.x (external MySQL) -> 4.5 (external MySQL)

Upgrade to 4.3.1.7 then follow the instructions above.

For support issues, contact Unravel Support.