Home

v4.5.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

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
Upgrade 4.5.x

  • All that is required is a 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 inUpgrade 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 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 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

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.

In this section: