How to Install Exalate for GitHub on Docker

version: '2'

services:
  database:
    restart: unless-stopped
    image: postgres:12.19
    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=idalko
      - DB_PASS=idalko
    networks:
      - dbnet

  githubnode:
    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/githubnode:5.12.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=exalate?gssEncMode=disable
      - GITHUBNODE_PG_USER=idalko
      - GITHUBNODE_PG_PWD=idalko
      - GITHUBNODE_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-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