How to Install Exalate for Zendesk on Docker

version: '2'

services:
  database:
    restart: unless-stopped
    image: postgres:9.4
    volumes:
      - ./persist/db:/var/lib/postgresql/data
      - ./createdb.sh:/docker-entrypoint-initdb.d/init-user-db.sh
    environment:
      - POSTGRES_PASSWORD=changeme
      - DB_NAME=zendesknode
      - DB_USER=idalko
      - DB_PASS=idalko
    networks:
      - dbnet

  zendesknode:
    restart: unless-stopped
    ports:
      - 9302:9002

    #
    # Change the image tag to the required version
    # Check Release History on docs.exalate.com for an overview
    #
    image: idalko/zendesknode:5.6.0
    depends_on:
      - database #wait for postgres to be started, not for ready
    volumes:
      - ./persist/home:/opt/zendesknode/data
    environment:
      # Add your environment settings here
      - ZENDESKNODE_PG_HOST=database
      - ZENDESKNODE_PG_DB=exalate?gssEncMode=disable
      - ZENDESKNODE_PG_USER=idalko
      - ZENDESKNODE_PG_PWD=idalko
      - ZENDESKNODE_PORT=9302

     #As part of the security improvements, Exalate 5.5.0 validates the origin header
     #that the browser is sending upon every request to Exalate.
     #In order to validate the origin header, Exalate needs to know what is the URL 
     #leading to it.
     #When deploying Exalate to Docker one needs to put an environment variable NODE_SELF_URL.
     #Example:
     # When you deploy Exalate onto a server, you configure a DNS rule such that 
     #whenever people navigate to foo.com, they reach your server's Exalate. 
     #You set up SSL so that https://foo.com leads to your Exalate on your server.
     #Now you need to set environment variable 

     - NODE_SELF_URL=https://foo.com 

     #for your Exalate docker container.

    networks:
      - dbnet
      - default

networks:
  dbnet:
    driver: bridge
  default:
    driver: bridge

#!/bin/bash
  
TEST=`psql -U postgres <<-EOSQL
   SELECT 1 FROM pg_database WHERE datname='$DB_NAME';
EOSQL`
  
echo "******CREATING DOCKER DATABASE******"
if [[ $TEST == "1" ]]; then
    # database exists
    # $? is 0
    exit 0
else
psql -U postgres <<-EOSQL
   CREATE ROLE $DB_USER WITH LOGIN ENCRYPTED PASSWORD '${DB_PASS}' SUPERUSER;
EOSQL
  
psql -U postgres <<-EOSQL
   CREATE DATABASE $DB_NAME WITH OWNER $DB_USER ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0;
EOSQL
  
psql -U postgres <<-EOSQL
   GRANT ALL PRIVILEGES ON DATABASE $DB_NAME TO $DB_USER;
EOSQL
fi
  
echo ""
echo "******DOCKER DATABASE CREATED******"

cd ~/exalate-zendesknode
docker exec -it exalate-zendesknode_database_1 bash
su postgres
psql -A $DB_NAME

\q
# \q exits the psql 
exit
# exits the postgres user session
exit
# exits the exalate-zendesknode_database_1 bash session

cd ~/exalate-zendesknode
docker exec -it exalate-zendesknode_zendesknode_1 bash

cd ~/exalate-zendesknode
docker-compose rm