Skip to main content

Deploying ToolJet on Amazon AMI

You can effortlessly deploy Amazon Elastic Compute Cloud Service (EC2) by utilizing a CloudFormation template. This template will deploy all the services required to run ToolJet on AWS AMI instances.

warning

To use ToolJet AI features in your deployment, make sure to whitelist https://api-gateway.tooljet.ai and https://python-server.tooljet.ai in your network settings.

info

You should setup a PostgreSQL database manually to be used by ToolJet. We recommend using an RDS PostgreSQL database. You can find the system requirements here.

Deploy using CloudFormation​

To deploy all the services at once, simply employ the following template:

curl -LO https://tooljet-deployments.s3.us-west-1.amazonaws.com/cloudformation/EC2-cloudfomration.yml

Deploy using Terraform​

Use this terraform script to quickly spin up a vm.

Follow the steps below to deploy ToolJet on AWS AMI instances.

  1. Setup a PostgreSQL database and make sure that the database is accessible from the EC2 instance.

  2. Login to your AWS management console and go to the EC2 management page.

  3. Under the Images section, click on the AMIs button.

  4. Find the ToolJet version you want to deploy. Now, from the AMI search page, select the search type as "Public Images" and input the version you'd want AMI Name : tooljet_vX.X.X.ubuntu_bionic in the search bar.

  5. Select ToolJet's AMI and bootup an EC2 instance.
    Creating a new security group is recommended. For example, if the installation should receive traffic from the internet, the inbound rules of the security group should look like this:

    protocolportallowed_cidr
    tcp22your IP
    tcp800.0.0.0/0
    tcp4430.0.0.0/0

  6. Once the instance boots up, SSH into the instance by running ssh -i <path_to_pem_file> ubuntu@<public_ip_of_the_instance>.

  7. Switch to the app directory by running cd ~/app.
    Modify the contents of the .env file. ( Eg: vim .env )

    The default .env file looks like this:

    LOCKBOX_MASTER_KEY=
    SECRET_KEY_BASE=
    PG_DB=
    PG_USER=
    PG_HOST=
    PG_PASS=
    TOOLJET_DB=
    TOOLJET_DB_HOST=
    TOOLJET_DB_USER=
    TOOLJET_DB_PASS=

    Read environment variables reference.

    SSL Configuration for AWS RDS PostgreSQL​

    warning

    Important: When connecting to PostgreSQL 16.9 on AWS RDS with SSL enabled, you need to configure SSL certificates. The NODE_EXTRA_CA_CERTS environment variable is critical for resolving SSL certificate chain issues and for connecting to self-signed HTTPS endpoints.

    For AWS RDS PostgreSQL connections, first download the certificate bundle:

    # Create directory and download certificate
    sudo mkdir -p /home/ubuntu/certs/
    cd /home/ubuntu/certs/
    sudo wget https://truststore.pki.rds.amazonaws.com/global/global-bundle.pem
    sudo chmod 644 /home/ubuntu/certs/global-bundle.pem

    Then add these variables to your .env file:

    PG_HOST=your-rds-endpoint.region.rds.amazonaws.com
    PGSSLMODE=require
    NODE_EXTRA_CA_CERTS=/home/ubuntu/certs/global-bundle.pem

    After updating the .env file, restart the application with ./setup_app.

  8. TOOLJET_HOST environment variable determines where you can access the ToolJet client. It can either be the public ipv4 address of your instance or a custom domain that you want to use.

    Examples: TOOLJET_HOST=http://12.34.56.78 or TOOLJET_HOST=https://yourdomain.com or TOOLJET_HOST=https://tooljet.yourdomain.com

    info

    We use a lets encrypt plugin on top of nginx to create TLS certificates on the fly.

    info

    Please make sure that TOOLJET_HOST starts with either http:// or https://

  9. Once you've configured the .env file, run ./setup_app. This script will install all the dependencies of ToolJet and then will start the required services.

  10. If you've set a custom domain for TOOLJET_HOST, add a A record entry in your DNS settings to point to the IP address of the EC2 instance.

  11. You're all done, ToolJet client would now be served at the value you've set in TOOLJET_HOST.

Deploying ToolJet Database​

ToolJet AMI comes inbuilt with PostgREST. If you intend to use this feature, you'd only have to setup the environment variables in ~/app/.env file and run ./setup_app script.

You can learn more about this feature here.

References​

Workflows​

ToolJet Workflows allows users to design and execute complex, data-centric automations using a visual, node-based interface. This feature enhances ToolJet's functionality beyond building secure internal tools, enabling developers to automate complex business processes.

Enabling Workflow Scheduling​

To activate workflows scheduling, set the following environment variables:

WORKFLOW_WORKER=true
ENABLE_WORKFLOW_SCHEDULING=true
TOOLJET_WORKFLOWS_TEMPORAL_NAMESPACE=default
TEMPORAL_SERVER_ADDRESS=<Temporal_Server_Address>

Note: Workflows scheduling requires a Temporal server to be deployed. Restarting the server using ./setup_app.

Deploying Temporal with Docker Compose​

Below is a docker-compose template to set up Temporal.

curl -LO https://tooljet-deployments.s3.us-west-1.amazonaws.com/ec2-temporal/docker-compose.yml

This setup can be deployed on a different EC2 instance. To enable seamless communication, ensure that both the application server and the Temporal server are in the same VPC.

Note: Ensure that port 7233 is configured for gRPC in the security group.

Upgrading to the Latest LTS Version​

note

Users on versions earlier than v2.23.0-ee2.10.2 must first upgrade to this version before proceeding to the LTS version.

New LTS versions are released every 3-5 months with an end-of-life of atleast 18 months. To check the latest LTS version, visit the ToolJet Docker Hub page. The LTS tags follow a naming convention with the prefix LTS- followed by the version number, for example tooljet/tooljet:ee-lts-latest.

Since ToolJet is deployed using an AMI (Amazon Machine Image), upgrading to a new LTS version requires launching a new EC2 instance with the updated AMI instead of upgrading in place.

Steps to Upgrade​

  1. Backup Your Data
    Perform a comprehensive backup of your PostgreSQL database to prevent data loss.
  2. Copy the .env File from the old Instance
    Before stopping the old instance, copy the .env file and store it safely.
  3. Stop the old EC2 Instance
    • To prevent conflicts, stop the old EC2 instance before proceeding with the new deployment.
    • Ensure that the old instance remains stopped while setting up the new one.
  4. Launch a New EC2 Instance with the Latest AMI
    • Go to the AWS AMI dashboard and find the latest ToolJet AMI.
    • Launch a new EC2 instance using this AMI.
    • Configure security group rules as needed.
  5. Transfer the .env File to the New Instance
    Upload the saved .env file to the appropriate directory on the new instance.
  6. Start the Application
    SSH into the new instance, navigate to the app directory, and run the setup script: 
    cd ~/app
    ./setup_app
  7. Terminate the Old EC2 Instance
    After verifying that ToolJet is running correctly on the new instance, terminate the old EC2 instance to avoid unnecessary costs.

If you have any questions feel free to join our Slack Community or send us an email at [email protected].