Planvisage SCM Application (8.0)

---

SCM Applicaiton can be deployed as four container images. It utilizes SQL Server/Oracle as its database

• Web Application
• Task Manager
• R Forecast
• Python Forecast

---

• Image Name : planvisage.azurecr.io/pvwebapp:latest
• Container Registry: planvisage.azurecr.io

Planvisage Web application can be configured using the following environment variables:

Environment variables

1. ACR_USERNAME                 Azure container registry user name
2. ACR_PASSWORD                 Azure container registry password
3. APP_VERSION                  Application Version (Image Tag) 
4. TIME_ZONE=Asia/Kolkata       Application Time Zone
5. LOG_TARGET=FILE              Log file target Type FILE/BLOB/MEMORY  (Optional)
6. BLOB_CONNECTSTR              For Azure Blob Storage, provide the connection string (Optional)
7. DB_CONNECTSTR                Database Connection String ( SQL Server)
8. LICENSE_KEY=abcd-efgh-1234-4568  License Key
9. LICENSE_NAME=companyname         Company Name
10.LICENSE_EMAIL=email@comapnyname.com  Email id to register license  
11.PV_SESSIONTIMEOUT            Application Timeout        
12.BLOB_CONTAINER_NAME          Name of the BLOB container
13.SECURE_COOKIE=True/False     If application is accessed by https://  set as "True", other wise "False"
14.SAML_ENABLED=True/False      SSO SAML enabled or not
15.SAML_APP_ID                  Application ID  to be used in SSO type SAML
16.SAML_PRVD                    SAML provider URL
17.SAML_CERT                    SAML certificate
18.SMPT_HOST                    SMTP Host name to send email
19.SMPT_PORT                    SMPT Port to send Email
20.SMPT_ISSSL                   SSL is True/False for SMTP
21.SMPT_USER                    SMTP User Name to send Email
22.SMPT_PWD                     Password for the specified UserName

Docker Compose .yml File

version: '3.9'
name: 'planvisage-scm'
services:
  PvNginxServer:
    image: planvisage.azurecr.io/nginxwebserver:latest
    hostname: PV-NginxWebServer
    ports:
      - "81:80"
    environment:
      - AZURE_REGISTRY_USERNAME=${ACR_USERNAME} # Azure container registry user name
      - AZURE_REGISTRY_PASSWORD=${ACR_PASSWORD} # Azure Registry Password
      - TZ=${TIME_ZONE}  #Change time zone value to change the container time zone
    networks:
      - pv-network

  PvWebApplication:
    image: planvisage.azurecr.io/planvisagedev:latest
    pull_policy: always
    hostname: PV-WebApplication
    ports:
      - "8080:8080"
    volumes:
      - ./PvWebApp/log/:/app/wwwroot/log/
      - ./PvWebApp/xml/:/app/wwwroot/xml/
      - ./PvWebApp/design/:/app/wwwroot/design
    environment:
      - AZURE_REGISTRY_USERNAME=${ACR_USERNAME} # Azure container registry user name
      - AZURE_REGISTRY_PASSWORD=${ACR_PASSWORD} # Azure Registry Password
      - TZ=${TIME_ZONE} #Change time zone value to change the container time zone
      - LOG_TARGET=${LOG_TARGET} 
      - BLOB_CONNECTSTR=${BLOB_CONNECTSTR}   #Blob connection string
      - DB_CONNECTSTR=${DB_CONNECTSTR}       # Database connection string
      - LICENSE_KEY=${LICENSE_KEY}            # License Key
      - LICENSE_NAME=${LICENSE_NAME}          # Company Name for License key
      - LICENSE_EMAIL=${LICENSE_EMAIL}          # Email Id used to register license
      - PV_SESSIONTIMEOUT=${PV_SESSIONTIMEOUT}   #Session time out in mins
      - BLOB_CONTAINER_NAME=${BLOB_CONTAINER_NAME}  #BLOB container name
      - SAML_ENABLED=${SAML_ENABLED}                #SSO SAML enabled or not
      - SAML_APP_ID=${SAML_APP_ID}                  #Application ID  to be used in SSO type SAML
      - SAML_PRVD=${SAML_PRVD}                      #SAML provider URL
      - SAML_CERT=${SAML_CERT}                      #SAML certificate
      - SMPT_HOST=${SMPT_HOST}                      #SMTP Host name to send email
      - SMPT_PORT=${SMPT_PORT}                      #SMPT Port to send Email
      - SMPT_ISSSL=${SMPT_ISSSL}                    #SSL is True/False for SMTP
      - SMPT_USER =${SMPT_USER}                     #SMTP User Name to send Email
      - SMPT_PWD=${SMPT_PWD}                        #Password for the specified UserName
    networks:
      - pv-network
    command: mkdir /wwwroot/data/import/ 


  PvTaskManager:
    image: planvisage.azurecr.io/pvtaskmanagerscheduler:latest
    pull_policy: always
    hostname: PV-TaskManager
    ports:
      - "8081:8080"
    volumes:
      - ./PvWebAppTaskMngr/log/:/app/wwwroot/log/
      - ./PvWebAppTaskMngr/xml/:/app/wwwroot/xml/
    environment:
      - AZURE_REGISTRY_USERNAME=${ACR_USERNAME} 
      - AZURE_REGISTRY_PASSWORD=${ACR_PASSWORD} # Azure Registry Password
      - TZ=${TIME_ZONE}  #Change time zone value to change the container time zone
      - LOG_TARGET=${LOG_TARGET} # FILE/BLOB/MEMORY
      - DB_CONNECTSTR=${DB_CONNECTSTR} 
    networks:
      - pv-network


  PvRForecast:
    image: planvisage.azurecr.io/rforecast:latest
    hostname: PV-RForecast
    ports:
      - "8083:8000"
    environment:
      - AZURE_REGISTRY_USERNAME=${ACR_USERNAME} # Azure container registry user name
      - AZURE_REGISTRY_PASSWORD=${ACR_PASSWORD} # Azure Registry Password
      - TZ=${TIME_ZONE}  #Change time zone value to change the container time zone
    networks:
      - pv-network

  PvPyForecast:
    image: planvisage.azurecr.io/pyforecast:latest
    hostname: PV-PyForecast
    ports:
      - "8084:8000"
    environment:
      - AZURE_REGISTRY_USERNAME=${ACR_USERNAME} # Azure container registry user name
      - AZURE_REGISTRY_PASSWORD=${ACR_PASSWORD} # Azure Registry Password
      - TZ=${TIME_ZONE}  #Change time zone value to change the container time zone
    networks:
      - pv-network

networks:
  pv-network:

Blob Connection String Format

DefaultEndpointsProtocol=https;AccountName=##accountName##;AccountKey=##accountKey##;EndpointSuffix=core.windows.net