How to Install Exalate for GitHub on Docker

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


  githubnode:
    restart: unless-stopped
    ports:
      - 9002:9002


    #
    # Change the image tag to the required version
    # Check Release History on docs.exalate.com for an overview
    #
    image: idalko/githubnode:5.23.0
    depends_on:
      - database #wait for postgres to be started, not for ready
    volumes:
      - ./persist/home:/opt/githubnode/data
    environment:
      # Add your environment settings here
      - GITHUBNODE_PG_HOST=database
      - GITHUBNODE_PG_DB=githubnode?gssEncMode=disable
      - GITHUBNODE_PG_USER=exalate
      - GITHUBNODE_PG_PWD=exalate
      - GITHUBNODE_PORT=9002


     #As part of the security improvements, Exalate 5.6.0 and above 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 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. once this is      done you need to set an environment variable NODE_SELF_URL=https://foo.com 
     #for your Exalate docker container.
     
      - NODE_SELF_URL=https://foo.com
     
     # You can use following variables to link the node with nginx proxy
     # Replace exa-git.exalate.biz with the appropriate FQDN
     # - LETSENCRYPT_HOST=exa-git.exalate.biz
     # - VIRTUAL_HOST=exa-git.exalate.biz
     # - VIRTUAL_PORT=9002
     # To hanlde SSL termination we suggest following this article https://docs.exalate.com/docs/scripts-how-to-bring-up-a-reverse-proxy-using-the-jwildernginx-proxy
      
     # CACHE_EXPIRY_DURATION_HOURS variable defines how long the cache will remain in the app.
     # The default value of 8 hours can be changed by specifying the number of hours.
     # - CACHE_EXPIRY_DURATION_HOURS=20


    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-gitnode
docker exec -it exalate-gitnode_database_1 bash
su postgres
psql -A $DB_NAME

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

cd ~/exalate-gitnode
docker exec -it exalate-gitnode_githubnode_1 bash

cd ~/exalate-gitnode
docker-compose rm