User Tools

Site Tools


Setup EASA 6.1 on Windows with a local database

The EASA installation described here, assigns individual EASA computational roles to a single physical machine and adjusts many other custom configuration options within the license conditions.

For Linux installation instructions, see Install EASA on Linux, Ubuntu or RHEL.

Before getting started please read Pre-installation Issues to identify and resolve any system conflicts ahead of time.


A. Prerequisites

1. In order to run Excel and EASA a Windows create a user account with administrator privileges (the default 'SYSTEM' account will not work).

For simplicity here, we refer to this user to as EASA-user.

2. Configure Excel to suppress popup notifications for EASA-user.

  • Insure Office with a 32-bit version of Excel is installed
  • Log in to Windows as: EASA-user
  • Click on the Start Menu and open Excel, insure Excel is activated for EASA-user
  • Usually the first time Excel is run by a new user a popup dialog is shown…Tick 'Don't ask me again' and close the popup
  • Suppress sources of interactive popups in Excel (Complete these steps and return to this page)

3. Give 'Logon As a Service' rights to the local Windows account using the 'Local Security Policy'

  • Open as Administrator: Start Menu > Local Security Policy
  • Open: Security Settings > User Rights Assignment
  • Right-click: Log on as a service
  • Select: Properties

  • Click: Add User or Group
  • Add: EASA-user
  • Click: OK

4. Confirm that each of the following folders exist and are writable by EASA-user (these are required for EASA to interact with Excel):

  • C:\Windows\SysWOW64\config\systemprofile\Desktop
  • C:\Windows\System32\config\systemprofile\Desktop

5. Confirm a working internet connection in order to download the EASA and MySQL installers.

6. Contact us for link to download the EASA installer for Windows: support@easasoftware.com, then download it.

7. Optionally, to save time during the installation, download and save the MySQL installer to the same folder as the EASA installer…otherwise the download will happen during EASA installation: https://help.myeasa.com/download/mysql-5.7.17-win32.zip

8. The following default ports must be open

  • EASA Server and EASAP Server(s)
    HTTP 80 or 8080
    HTTPS 443 or 8443
  • Database (for systems with more than one physical machine)
    MySQL - 3306 inbound
    SQL Server - 1433 inbound

9. EASA requires 2.5GB of free disk space.


B. Installation

1. Right-click the installer, select 'Run as administrator.

2. If prompted grant, 'public network access' to EASA.

3. Accept the license agreement.

4. If EASA has been installed already, specify whether to use an existing folder or a new installation folder (referred to as <EASAROOT>).

5. Select or unselect the various EASA components (implemented as Tomcat webapps) to install on the current machine:

  • An EASA Server is the central role for an EASA system,
    It hosts the User, Author, Administrator login page
    It delegates a selected EASAP to an EASAP Server
    It provides database configuration, logging and a (by default) a local, internal MySQL instance
  • An EASAP Server serves an instance of a running EASAP to a web browser
  • An EASAP Web service provides a RESTful or SOAP API for non-interactive use by a Web Service Client
  • MS Excel Server Support allows an EASAP to literally run a spreadsheet, update cells, export charts, etc….
  • Compute Server allows an EASAP to interact with third-party software like Matlab, a C program, a batch script, etc….

  • The defaults above are fine to install an EASA system on a single machine
  • For an EASA Server which will have remote EASAP Servers (with or without Excel Server support) uncheck,
    EASAP Server
    MS Excel Server Support
  • For installing EASA on a remote EASAP/Excel Server uncheck,
    EASA Server
  • For installing EASA on a remote EASAP Server (without Excel support) uncheck,
    EASA Server
    MS Excel Server Support
  • Check Compute Server if the machine will run 3rd party software other than Excel, and (un)select other relevant components

6. Choose a local, internal MySQL database and drivers.

7. Accept the MySQL license.

8. Choose a data folder, the EASA Help Pages refer to this folder as <SERVERDATA>, click Next.

9. Set listen and shutdown ports and a name for the EASA Tomcat8 service, click Next
A NEWNAME requires executable name change as well, in <EASAROOT>\tomcat\bin\ 'Tomcat8w.exe' goes to 'NEWNAMEw.exe'

10. Review the configuration then click Next, installation will proceed.

11. Before clicking the Finish button, please make a note of the URL to access EASA on the local machine (eg. http://localhost:80/easa )

We may allow remote access to EASA, either via an IP address or configure an alternate hostname with a machine name or DNS.

Non-Excel users may tick 'Start EASA Server' and click Finish, if Excel support was installed we need to complete the next step before startup.

12. If Excel support was installed follow Configure the EASA service to run as EASA-user specifically Part B.

Once Excel is configured, start the service by ticking 'Start EASA Server' above and click: Finish or follow the more general steps below:

  • Open: Task Manager > Services tab
  • Right-click 'Tomcat8' and select: Start

13. In 'Task Manager > Processes > Background Processes' confirm mysqld.exe is running, note its process ID, or PID.

In 'Task Manager > Services' confirm Tomcat8 service is running, note its process ID, or PID.

If 'MS Excel Support' was included, confirm there are EXCEL.exe or 'Microsoft Excel' background processes

14. Confirm a mysqld.exe background process and 'EASA Tomcat8' service are listening on the expected ports.

  • In a cmd.exe window type: netstat -aon
  • Check to see both mysqld.exe and Tomcat8 PID's are LISTENING on the desired ports, 3306 and 80, respectively by default


C. Configuration

1. The desktop heap memory must be increased for a machine running Excel.

  • Open: Start menu > Registry Editor (or run regedit.exe)

The size of each desktop heap allocation is controlled by the following registry value:

  • HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\SubSystems\Windows

The default data for this registry value will look something like the following (all on one line),

%SystemRoot%\system32\csrss.exe ObjectDirectory=\Windows
SharedSection=1024,20480,768 Windows=On SubSystemType=Windows
ServerDll=basesrv,1 ServerDll=winsrv:UserServerDllInitialization,3
ServerDll=winsrv:ConServerDllInitialization,2 ProfileControl=Off
MaxRequestThreads=16

The numeric values following SharedSection= control how desktop heap is allocated (in KB).

  • SharedSection - 1024 is the shared heap size common to all desktops.
    This not a desktop heap allocation→the value should not be modified to address desktop heap problems.
  • SharedSection - 20480 is the size of the desktop heap for each desktop for an interactive window station
    (with the exception of the “Disconnect” and “Winlogon” desktops)
  • SharedSection - 768 is the size of the desktop heap for each desktop “non-interactive” window station.

Set the non-interactive desktop heap (the third value, '768' above) to '4096' to support up to 40 Excel processes, below.

2. Optionally change from the default Java 2200 MB heap size.

  • Run cmd.exe
  • cd <EASAROOT>\tomcat\bin\
  • Run tomcat8w.exe
  • Under 'EASA Tomcat8 Properties > Java' set:
    Initial memory pool
    Maximum memory pool

An EASAP with a large spreadsheet may require 300 MB or more per simultaneous instance. 3. Modify network configuration to use https see Enable TLS using a Certificate Authority and Keystore Explorer

4. Configure Excel processes.

  • Login to EASA as administrator
  • Go to: EASA > Configure > Compute Servers

Confirm Excel processes are running.

Adjust the number of Excel processes via the Compute Server Configuration Tool (link to launch highlighted in red).

Before the Compute Server Configuration Tool can launch, Install the EASA Client, then click the link above.

Download and open the tool.

On the Configuration Tree LOCAL EXCEL SERVER > Number of Processes: sets the number of Excel simultaneous processes.

By default there are five processes, modify this number and save to change the default.

After any change, either restart the EASA service or click: EASA > Configure > Compute Servers > Update (tick Local Excel Server).