Espresso is provided in a number of alternatives:
- Cloud-based service - runs on AWS or Azure. No install.
- Appliance - VMware image, or Docker. Install the VM, and run. Described here.
- Installable web app (war) - for deployment into Web / App Servers, so it can run with and utilize your existing systems, with a familiar deployment model.
This page contains instructions for installing Espresso as a WAR file on Apache Tomcat. They are targeted to your own environment.
To deploy the war to the cloud
Java 7.x or higher
Verify you have Java 7 or higher, by using a Command Line, and typing:
On Windows, you may also need to set your environment variable. Use Control Panel > System > Advanced, and specify the location of your Java installation (see screenshot).
Note - this setting will be in effect only once you open a new Command Window.
If you don't have it already, install MySQL (link here
If you don't have it already, install MySQL Workbench
. This will be useful in the configuration steps below, but is not strictly speaking required.
Create Admin DB Schema
Create a new MySQL schema (e.g., espresso_adm_db): in MySQL Workbench, right-click on the existing schemas, and create a new schema:
Create a new MySQL user
- In MySQL Workbench, in the left NavBar, click Management > Users and Privileges, and create a user as shown below
- You can choose any name, but the following work with the configuration scripts:
The schema privileges for this new user should be as follows:
Espresso runs in a container. Here we set up the container as Apache Tomcat.
- Download Tomcat (link here). It should be about 10MB, a file named something like
- Unzip this file.
- The path where you unzip this file should not contain spaces
- This will create a directory named something like
apache-tomcat-7.0.61 (or whatever the version is).
We will refer to this as the Tomcat directory. An example is shown here:
Configure the MySQL JDBC driver
- Download the MySQL JDBC connector.
- Select the Platform Independent option, zip format
- That will download a file like
- Unzip this file to obtain the jar file
- Copy the file
mysql-connector-java-5.1.35-bin.jar to the
lib directory in the Tomcat directory (note: the exact version number may vary)
In your Tomcat directory, edit
- insert the
Resource tag (the xml code below) within the
- See the screen shot, below.
password to the MySQL user created, above.
<!-- ESPRESSO -->
Please note that the
url parameter must include the
characterSet=utf8 parameter (technically, that's not required if your MySQL uses UTF-8 by default, but this is just to be safe).
Edit the indicated file and
- insert the xml code below within the
<ResourceLink global="jdbc/AdminDB" name="jdbc/AdminDB" type="javax.sql.DataSource"/>
Here is a screen shot illustrating the steps above.
Install Espresso Logic
- Download the Espresso WAR file here.
- Move that file to the
webapps directory in the Tomcat directory and rename it to
Start your tomcat service:
Mac / Unix:
- cd to Tomcat's bin directory
- Start Command Window
- cd toTomcat's bin directory
Note: if you encounter a permission error on Mac or Unix:
Check the Logs
Use a text editor to open logs/catalina.out, shown at right.
Note: on Windows, that file may have a date in its name.
Don't forget - if you make an error and the server does not start properly, you probably need to stop / restart it.
A note of caution - check the Tomcat command window to verify you are running the configured Tomcat.
We have seen instances where a previous version of a Tomcat install on Windows set an environmental variable that results in executing the wrong version of Tomcat. A good indicator is "no files in the logs folder".
When the Designer starts, it will display a login dialog. Specify:
- server location as
WAIT about 1 minute while the repository is being configured the first time.
Verifying the Installation
Please verify the installation, and begin your exploration of the samples, with the procedure below.
Create Northwind (and run Tour)
Once you are in the Espresso Logic Designer, use the left navbar
REST API >>
Create.. (a new API / Project), using the default version of Northwind. Verify that the basic operations operate - Get requests, new resources, rules, Live Browser.
Import Sample Databases
The documentation is created around the Logic Demo and Logic Sample databases. Create them as described here.
Use the same commands as for starting Tomcat, but
shutdown instead of Startup.
To upgrade to a newer version of the war:
- If it is running, shutdown the server
- In the Tomcat
webapps directory, delete...
- Copy the new war to
ROOT.war (retain the original to recall the version number)
ROOT.war into the Tomcat webapps directory
- Startup the server