...

Installation / Upgrade

Prerequisites

Java 7

Oracle 11g or 12c

SQL Server 2008R2 or later

MySQL 5.6 or MariaDB 

Installation

Upgrade

Backup your Database

Ensure that you have a recent full backup of your database. If, for any reason, you need to rollback (see "Rollback Upgrade" below), your PhixFlow configuration and data will revert to this point.

Shutdown

Shut down tomcat. PhixFlow will not be available to users until the upgrade is complete.

Environment

If necessary, upgrade to supported versions of Java, Tomcat and Oracle, SQL Server or MySQL / MariaDB.

See above for details.

Remove the Oracle / SQL Server and MySQL jdbc driver files from $tomcat/lib (the actual names can vary, but be

    similar to ojdbc16.jar (oracle), sqljdbc4.jar (sql server) and mysql-conector-java-5.1.23-bin.jar (mysql).
    The correct versions of these files are now included in the PhixFlow webapp.

2. Move the live phixflow installation, i.e. the directory $TOMCAT/webapps/phixflow, to an archive location.
E.g. on unix/linux: mv $TOMCAT/webapps/phixflow $CV_ARCHIVE/phixflow-<current date>

3. Copy the webapps/phixflow directory in the release to $TOMCAT/webapps.
E.g. on unix/linux: cp $CV_RELEASE/phixflow_<new release>/webapps/phixflow $TOMCAT/webapps/phixflow

4. Copy the following files from the WEB-INF/classes directory in the archive of the live installation,
e.g. $CV_ARCHIVE/phixflow-<current date>/WEB-INF/classes, to $TOMCAT/webapps/phixflow/WEB-INF/classes:
    - phixflow-datasource.xml
    - phixflow-instance.xml
    - phixflow-email.xml
    - phixflow-domains.xml
    - log4j.properties
    
6. Ensure all migration scripts are run in sequence from prior version to this version e.g.:
 
   for Oracle users:
      @@$CV_RELEASE/phixflow_<new release>/schema/oracle/migration/X.Y/migrate_schema_from_x_y_z_to_X_Y_Z.sql

   for SQL Server users:
      from directory $CV_RELEASE\phixflow_<new release>\schema\sql_server\migration\X.Y run:
      sqlcmd -S cvServer\cvInstanceName -U cview -P cview -i migrate_schema_from_x_y_z_to_X_Y_Z.sql -v dbName="cview" 
      
7. Re-start tomcat.
   
8. Upgrade is complete

Features / Improvements

Applications

...

Inbound accounts are used to fetch emails. There can be more than one active inbound account.

Upgrade

...