Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Excerpt

Additional Information for In-House Customers

The initial release of

Frevvoproduct
version 9.0 will be deployed to the frevvo Cloud on August 10, 2019. Version 9.0 will be released for in-house customers on 10/16/2019. In-house customers should review the topics below, the instructions in the Upgrade Guide and Supported Platforms before migrating. It is recommended that you perform a full installation of 
Frevvoproduct
 v9.0.0 when upgrading.  Please remember that In-house customers must upgrade to JDK 11 before upgrading to 
Frevvoproduct
 v9.0.

v9.0 License

Warning
title v9 License Key Required

A v9 license key is required for this version of 

Frevvoproduct
. Request a v9 license by emailing support@frevvo.com BEFORE you begin the upgrade. v7 licenses will not work. 

v9.0 license required for this release. v7.0 licenses will not work (TIP-22386)

JDBC Driver Upgrade

  • MySQL Connector/J 8.0 is highly recommended for use with MySQL Server 8.0, 5.7, 5.6, and 5.5. Note the difference in the driver classname:

Connector/J 5.1: driverClassName="com.mysql.jdbc.Driver"
Connector/J 8.0: driverClassName="com.mysql.cj.jdbc.Driver"

  • The SQL Server JDBC Driver (mssql-jdbc-7.2.2.jre11.jar ) is included in the frevvo tomcat bundle in the <frevvo-home>\frevvo\tomcat\lib directory.

Tomcat and Insight Server version Upgrades

The version of tomcat has been upgraded to 9.0.19 in the Live Forms Cloud. and in the frevvo tomcat bundle for the v9.0 release.

The version of the Insight Server has been upgraded to Solr 7.5.0 in the Live Forms Cloud and in the frevvo tomcat bundle. Server functionality remains the same with the exception of the name of the directory in the tomcat bundle where Solr resides. In-house customers should review the Start the Insight server before Live Forms topic for the changes.

Hardware and Memory Requirements for your Live Forms Server

The minimum recommended hardware configuration for your Live Forms server is:

  • 2 gigahertz (GHz) 64-bit (x64) processor with 4 cores
  • 5 gigabyte (GB) of system memory
  • 100 GB hard drive

However you must size your hardware platform to your specific form usage characteristics. As the number of concurrent users and forms/flows increases so must the system memory. Refer to the memory configuration topic for the details.

Insight Server Memory Requirements

It may be necessary to increase heap size for the Insight server, when reporting on/indexing a large number of submissions. Refer to the memory configuration topic for the details.

Section
Column

Windows:

  1. Open a command prompt. Navigate to <frevvo-home>\solr-7.5.0. Type bin\solr.cmd start to run the Insight server in the background, listening on the default port 8983.

    Note

    Use the bin\solr.cmd -all command to stop all instances of the Insight Server. The -p option allows you to specify the port number for the instance you want to stop

    You will see this message: "Started Solr server on port 8983. Happy searching!"
     

  2. Browse http:<your server:your port>/solr to verify the Insight server is running. The <server:port> default values are localhost:8983. Change <your server>  to the server name and <your port> to the port the Insight server is running on if they are different than the defaults. Do not include the angle brackets <>. You will see the Insight server (Solr) dashboard with the current status:

Warning

If you close the Insight server (Solr) startup window, the server will stop running. Leave the window open or set up Live Forms and the Insight Server to run as Windows services.

You do not have to restart the Insight server every time you restart

Frevvoproduct
.

Column

Linux:

  1. Ensure that the scripts are executable: chmod 755 <frevvo-home>/tomcat/bin/*.sh
  2. Navigate to <frevvo-home>/solr-6.6.2/bin. Run this command to make the solr startup file executable: chmod +x solr
  3. Navigate back to the solr-6.6.2 directory.
  4. Start the Insight server by typing: bin/solr start - this starts the Insight server in the background, listening on the default port 8983.
  5. Browse http:<your server:your port>/solr to verify the Insight server is running. The <server:port> default values are localhost:8983. Change <your server>  to the server name and <your port> to the port the Insight server is running on if they are different than the defaults. Do not include the angle brackets <>. You will see the Insight server (Solr) dashboard with the current status:

You do not have to restart the Insight server every time you restart

Frevvoproduct
.

Batch User Uploads 

Uploading a CSV file to add or edit users normally runs quickly. However, if uploading a file in which the notifyIfNewUser property is TRUE for a large number of rows, this process may slow down on some email servers. Tenant Admins can configure Live Forms to run CSV-file user uploads in batches to improve upload time if needed. To adjust batch load size, configure the following property in <frevvo-home>\tomcat\conf\frevvo-config.properties. 

Code Block
frevvo.userloader.batchSize=25

frevvo.war file

As of the v9.0.11 patch upgrade, the frevvo.war file is now shipped unpacked in the <frevvo home>\tomcat\webapps\frevvo directory. If you are working with a pre-v9.0.11 version and need to perform customization in these files, you will need to unzip your frevvo.war file to make changes, and rezip/replace it to run frevvo with your customization. 

Expand
titleSteps to unzip/edit/rezip frevvo.war file...
  1. Stop Live Forms if it is running.
  2. Navigate to <frevvo-home>\tomcat\webapps directory.
  3. Copy the frevvo.war file to a temporary location of your choice: e.g. c:\tmp\frevvo-war. Change the file extension from .war to .zip if necessary. Unzip it.
  4. Edit the desired file. 
  5. Save the changes to the default file. 
  6. Rezip all the files in the c:\tmp\frevvo-war directory, even the ones you did not edit — if you change directories or zip them differently, Live Forms may not load correctly:

    This is the correct structure for the frevvo.war zipfile.

  7. Make sure you create the zipfile with the directory structure as shown in the image above (select all files, then send to compressed folder.) It is an easy mistake to include the containing directory in the zipfile. If you do this, Live Forms may not load correctly. Zip will often give your zipfile a .zip extension. Make sure you change this to a .war extension. 

  8. Copy the updated frevvo.war file to <frevvo-home>tomcat\webapps.
  9. Restart your Live Forms server.

sameSiteCookies attribute

Recent browser versions (especially Chrome v80+), by default, allow cookies to be sent only with top-level navigation and GET request initiated by third party websites. When you need to expose cookies to a third party site, such as using the SAML security manager or embedding in an iframe, you need to use https (Chrome only) and explicitly set the samesite attribute of the cookie to "none". frevvo v9.0.10+ includes a tomcat upgrade that allows configuring the cookie processor with this attribute.

For third party access, you must use https and update the provided tomcat/conf/context.xml CookieProcessor element to add the sameSiteCookies attribute.

Code Block
<CookieProcessor className="org.apache.tomcat.util.http.LegacyCookieProcessor" allowEqualsInValue="true" sameSiteCookies="none"/>

On premise customers who do not want to make these updates need to turn on the legacy behavior in the chrome browser. Please see this Chrome documentation for details.