Master To Do Before Release 1

Inside the DevTest VM

• Upgrade to Postgres 11
• Download NSSM and pgweb
• Run pgweb as a service
• Obtain SSL certificate for learndbdev.eastus.cloudapp.azure.com
• Obtain SSL certificate for classdb.eastus.cloudapp.azure.com
• Configure Postgres to use SSL: postgresql.conf
• Configure Postgres to accept (only) SSL connections: pg_hba.conf
• Configure IIS to accept https requests
• Set up an IIS proxy to offload https requests to pgweb
• Set up local firewall

In the DevTest Azure resource group

• Create public IP address with sub-domain learndbdev.eastus.cloudapp.azure.com
• Create public IP address with sub-domain classdb.eastus.cloudapp.azure.com
• Create network interface associated with learndbdev.eastus.cloudapp.azure.com
• Create network interface associated with classdb.eastus.cloudapp.azure.com
• Set up inbound rules in the network security group

Production environment

• Install Postgres 11
• Install ClassDB
• Complete other items as for DevTest, except use sub-domains learndb.wcsu.edu and classdb.wcsu.edu

LearnDB development

• Develop "Change Password" stop-gap web app

ClassDB development

• Permit only known roles to connect to database
• Update documentation

LearnDB extensions to ClassDB

• Add table ClassDB.PasswordChangeActivity
• Revise view ClassDB.getUserActivity to include password change activity
• Add function ClassDB.getUserPasswordChangeActivity
• Add function ClassDB.getMyPasswordChangeActivity
• Add view ClassDB.MyPasswordChangeActivity
• Update documentation

LearnDB Private Repo

• Create private GitHub repo: never to become public
• Document pgweb parameters
• Document Local firewall rules
• Document Azure network security rules
• Track postgresql.conf: start by adding Postgres's default file
• Track pg_hba.conf: start by adding Postgres's default file