...
| Section | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
|
Migrating from HSQLDB
frevvo does does not support the use of HSQLDB for use beyond demo/trials of the Live Forms software. If by mistake you continued to use the demo/trial HSQLDB database for production use, you will need to first migrate your frevvo data your data to one of frevvo's supported production databases BEFORE you can use the automated migration scripts to upgrade to the latest version of Live Forms.
...
| Warning |
|---|
You will need to upgrade to version 4.1.7 before migrating to version 5. Refer to Upgrading Your In House Server to v4.1.7 for the details. Return . When the upgrade to v4.1.7 is complete, return to this page and continue with the Upgrading from v4.1.7 section below: |
...
Consult your DBA or your database specific documentation on how to run these scripts.
7, . Configure the new installation
...
If you are using the database connector, you must reinstall and configure it again for the v5.1.1 installation. Version 5.1.1 includes the latest database connector, version 2.3 beta.
Upgrading from v5.x
...
| Warning |
|---|
5. |
...
x versions of will not need /frevvo/data migration as all user data was already moved from the filesystem to the database. |
...
|
Please read the following upgrade steps prior to starting the migration.
- Please read and understand the Migration Considerations which may require your action before beginning.
- Backup the v4 server's forms and users databases
- Backup the v4 server's installation directory so that you have a copy of all custom configuration parameters and the v4 server's data folder.
- Stop the v4 server using stop-frevvo.[bat,sh] or through the Computer Management Services console if is running as a window's service. It is very important that the v4 server is stopped, otherwise the v5 server may not correctly migrate all existing tenant users.
- Install a fresh v5.1 frevvo server:
- Download the latest v5 software. Note that you will need to provide your login credentials to download the software.
- Request a v5 license key.
- The download is a zip file. Extract the contents to any folder of your choice. This folder will be refered to as <frevvo-home> (note that the zip already contains a top level frevvo folder).
- Migrate existing 4.1.7 forms & users databases using the upgrade scripts provided in <frevvo-home>/data/sql.You must execute these SQL scripts to perform a few required database schema updates.
- Navigate to <frevvo-home>/data/sql.
- The scripts are named by database and by release number of the Live Forms version that you are upgrading from. For example, if your databases use mySQL5, and since you can only upgrade form versions 4.1.7 or later - use the scripts that have "mysql5" and 417 in its name:
- forms-mysql5-upgrade-417.sql
- users-mysql5-upgrade-417.sql
Consult your DBA or your database specific documentation on how to run these scripts.
...
- Configure the new installation
- If you made changes to the following files in your v4.1.7 installation, you will need to make the same changes in the v5.1.1 configuration files.
- <frevvo-home>/tomcat/conf/server.xml
- <frevvo-home>/tomcat/conf/Catalina/localhost/frevvo.xml
- We recommend that any changes that were made to the web.xml file be moved to frevvo.xml instead.
- The three files mentioned above include:
Refer to Installation Tasks for more information.
87. Start v5.1 server. Enter the new v5.1 license key obtained in Step 5b .
9. Login as admin superuser
| Warning |
|---|
Do NOT login as any user in any tenant other than default before the import: it will create a .user file in the db and will make the import skip that user. |
10. Click Import 4.1.7+ /data folder.
11, Enter the path to the v4.1.7 <frevvo-home>/data folder that you want to import into this installation.
12. Click Import.
...
.
Things to Check:
- login as a tenant admin
- Click on the Configuration Checklist link to verify that all configurations are complete
- login as a tenant designer user
- view and edit a form/flow
- view submissions that existed before
- test forms/flows
...