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.
Before getting started please read Pre-installation Issues to identify and resolve any system conflicts ahead of time.
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.
3. Give 'Logon As a Service' rights to the local Windows account using the 'Local Security Policy'
4. Confirm that each of the following folders exist and are writable by EASA-user (these are required for EASA to interact with Excel):
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: email@example.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
9. EASA requires 2.5GB of free disk space.
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:
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.
Once Excel is configured, start the service by ticking 'Start EASA Server' above and click: Finish or follow the more general steps below:
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.
1. The desktop heap memory must be increased for a machine running Excel.
The size of each desktop heap allocation is controlled by the following registry value:
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).
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.
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.
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).