...
| Table of Contents | ||
|---|---|---|
|
Installation / Upgrade
Prerequisites
| Anchor | ||||
|---|---|---|---|---|
|
Java 7
Apache Tomcat 7
One of:
Oracle 11g or 12c (preferred)
SQL Server 2008R2 or later
MySQL 5.6 or MariaDB
...
MariaDB (MySQL) 10.0.14 or later
Upgrade
Backup your Database
...
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
...
Unzip the PhixFlow Release
Unzip the PhixFlow release package into a temporary directory.
We will refer to the new PhixFlow release as $RELEASE.
Install the new Webapp
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
...
$ARCHIVE/phixflow-<current
...
date>
...
Copy $RELEASE/webapp/phixflow to $TOMCAT/webapps.
...
E.g.
...
on
...
unix/linux:
...
cp
...
$RELEASE/webapp/phixflow
...
$TOMCAT/webapps/phixflow
...
Copy
...
the
...
following
...
files
...
from
...
the
...
WEB-INF/classes
...
directory
...
in
...
the
...
archive
...
of
...
the
...
live
...
installation into the corresponding directry in the new phixflow webapp:
- phixflow-datasource.xml
- phixflow-instance.xml
- phixflow-domains.xml
- log4j.properties
E.g.
...
copy $CV_ARCHIVE/phixflow-<current
...
date>/WEB-INF/classes,
...
to
...
$TOMCAT/webapps/phixflow/WEB-INF/classes
...
Upgrade the Database
Ensure all migration scripts are run in sequence from prior version to this version e.g.:
E.g. for Oracle users:
| Code Block |
|---|
cd $RELEASE/schema/oracle/migration/X.Y |
...
sqlplus myUsername/myPassword @migrate_schema_from_x_y_z_to_X_Y_Z.sql |
...
E.g. for SQL Server users:
| Code Block |
|---|
cd $RELEASE/schema/sqlserver/migration/X.Y sqlcmd -S |
...
myServer\ |
...
myInstance -U |
...
myUsername -P |
...
myPassword -d myDatabase -i migrate_schema_from_x_y_z_to_X_Y_Z.sql |
...
Re-start Tomcat
The upgrade is now complete.
Features / Improvements
Applications
...