Planvisage SCM Application (8.0)

• 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/AWS_CLOUDWATCH  (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
23.SYSADMIN_PWD                 System Admin Password
24.SYSADMIN_EMAIL               System Admin Email Id
25.SANITIZATION                 To enable Sanitization True/False for Primary Ke columns Values
26.DATA_SANITIZATION            To Enable sanitization True/False for all the column values
27.TASK_MNGR_URL                To give Task Manager/Task Scheduler URL
28.SECURE_COOKIE                Ensures the cookie is only sent over secure connections
29.AWS_LOG_GROUP                Specifies the CloudWatch log group name to which application logs will be sent
30.AWS_REGION                   Defines the AWS region where your resources (like logs or storage) are located
31.AWS_ACCESS_KEY               AWS access key used to authenticate and authorize access to AWS services
32.AWS_SECRET_KEY               AWS secret key paired with the access key for secure AWS authentication

Sample 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_REGISTRY_PASSWORD=${ACR_PASSWORD}
      - TZ=${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_REGISTRY_PASSWORD=${ACR_PASSWORD}
      - TZ=${TIME_ZONE}
      - LOG_TARGET=${LOG_TARGET}
      - BLOB_CONNECTSTR=${BLOB_CONNECTSTR}
      - DB_CONNECTSTR=${DB_CONNECTSTR}
      - LICENSE_KEY=${LICENSE_KEY}
      - LICENSE_NAME=${LICENSE_NAME}
      - LICENSE_EMAIL=${LICENSE_EMAIL}
      - PV_SESSIONTIMEOUT=${PV_SESSIONTIMEOUT}
      - BLOB_CONTAINER_NAME=${BLOB_CONTAINER_NAME}
      - SAML_ENABLED=${SAML_ENABLED}
      - SAML_APP_ID=${SAML_APP_ID}
      - SAML_PRVD=${SAML_PRVD}
      - SAML_CERT=${SAML_CERT}
      - SMPT_HOST=${SMPT_HOST}
      - SMPT_PORT=${SMPT_PORT}
      - SMPT_ISSSL=${SMPT_ISSSL}
      - SMPT_USER=${SMPT_USER}
      - SMPT_PWD=${SMPT_PWD}
      - TASK_MNGR_URL=${TASK_MNGR_URL}
      - SECURE_COOKIE=${SECURE_COOKIE}
      - AWS_LOG_GROUP=${AWS_LOG_GROUP}
      - AWS_REGION=${AWS_REGION}
      - AWS_ACCESS_KEY=${AWS_ACCESS_KEY}
      - AWS_SECRET_KEY=${AWS_SECRET_KEY}
    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}
      - TZ=${TIME_ZONE}
      - LOG_TARGET=${LOG_TARGET}
      - DB_CONNECTSTR=${DB_CONNECTSTR}
      - PYTHONFORECASTURL=${PYTHONFORECASTURL}
      - RFORECASTURL=${RFORECASTURL}
    networks:
      - pv-network

  PvRForecast:
    image: planvisage.azurecr.io/rforecast:latest
    hostname: PV-RForecast
    ports:
      - "8083:8000"
    environment:
      - AZURE_REGISTRY_USERNAME=${ACR_USERNAME}
      - AZURE_REGISTRY_PASSWORD=${ACR_PASSWORD}
      - TZ=${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_REGISTRY_PASSWORD=${ACR_PASSWORD}
      - TZ=${TIME_ZONE}
    networks:
      - pv-network

networks:
  pv-network:

Blob Connection String Format

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