Insight Server Files

When you unzip the tomcat bundle, you will see a new <frevvo-home>\solr directory that contains the Insight Server software.

A solr core is created for each tenant.
A directory is created for each core under frevvo/data/solr. The documents in each core are stored under the 'data' directory under the core directory.

Report data kept in the subdirectories of <frevvo-home>\data\solr
When you delete a tenant, the core gets deleted.

Insight Server Location Configuration parameter

The default server and port are localhost:8983. The Insight Server URL configuration parameter is located in the <frevvo-home>\tomcat\conf\Catalina\localhost\context.xml.default file. Configuring the location of the Insight Server in this file makes it available to the insight and frevvo web application warfiles. Modify the insight.server.url parameter in the <frevvo-home>\tomcat\conf\frevvo-config.properties file if the Insight Server is running on a different machine than frevvo.

# Insight settings 
insight.enabled=true
insight.server-url=http://localhost:8983/solr

Starting the Insight Server from the command line

frevvo requires Insight software for the Reporting and Submissions View feature. The Insight software is included in the tomcat bundle. The Insight server MUST be started BEFORE starting frevvo. Instructions for Windows and Linux operating systems are listed here:

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

Stopping the Insight Server from the command line

Use the bin\solr.cmd -all command to stop all instances of the Insight Server.

Follow these steps:

Navigate to <frevvo-home>\solr
Type bin\solr.cmd stop -all

To stop a particular instance of the Insight Server, use the -p option to specify the port number that the Insight Server process is running on. Ex: bin\solr.cmd stop -p 8983

Running frevvo and the Insight Server as Windows Services

The Insight Server must be started BEFORE frevvo from a command prompt, or you will see a Configuration Checklist warning and you will not be able to proceed. If you close the Insight Server startup window, on a Windows system, the server will stop running. You can leave the window open or set up frevvo and the Insight Server to run as Windows services.

If you are using the frevvo tomcat bundle, follow the steps below to run the Insight Server (Solr) as a Windows service. Otherwise, general instructions can be found on this website.

Install the Insight Server as a Windows service
Install frevvo as a Windows service
Add a Dependency to the frevvo service

Install the Insight Server as a Windows Service

We will use a service helper such as NSSM (Non-sucking Service Manager). NSSM requires Java 7 or higher. You can download it from here.

Extract the NSSM zipfile to a Program Files\nssm directory
Open a command prompt. Run as an administrator
Navigate to the directory under c:\Program Files\nssm\ that contains the nssm.exe file for Windows64 or Windows32
For example, the path in Windows 7 would be C:\Program Files\nssm\nssm-2.24\win64
Type: nssm install <service name> - Replace <service name> with the name you want to use for the Insight Server service.
Ex: nssm install insightserver
Browse to the location of the solr.cmd script by clicking on the three dots to the right of the Application Path field. This should be in <frevvo-home>\solr\bin.
Click on the solr.cmd file, then click Open. The Application Path field will populate.
Notice the Startup directory field also populates. REMOVE bin from the Startup directory field. The Startup directory should be: c:\<frevvo-home>\solr\
Enter these Arguments:

start -f -p 8983
- the -f option starts the Insight Server in the foreground so NSSM can kill it when it needs to be stopped or started
- the -p option specifies the port that the Insight Server is running on. The default is 8983. Change 8983 to the port number for your installation if necessary.
Optionally, click the Details tab to specify a Display Name and Description - Ex: Insight Server, Script to Stop/Start Solr5. Notice the Startup type is set to Automatic.
Click the Install service button. A success message displays:
Start the Insight Server service from the Computer Management Services pane.
Browse http://<your server: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 dashboard with the current status:

Install frevvo as a Windows service

There are batch files in the <frevvo-home> directory to Install/Configure frevvo as a Windows service. Refer to Installing frevvo as a Windows Service for more details and troubleshooting tips.

Navigate to <frevvo-home>. Run the Install-Service batch file as an administrator to install frevvo as a service.
Configure the frevvo service if you are using Windows 64 bit by clicking on the Configure Service batch file. You must run the Configure-Service batch file as an administrator.
1. Change the Startup type to Automatic. Save the changes.
frevvo will appear under Windows services with the name frevvoforms with a Startup type of Manual. Change Startup Type to Automatic (Delayed Start), then start the service.