Skip to content

Documentation for Minimal Viable Solution implementation of LearnDB with pgweb

Adam Jeniski edited this page Oct 23, 2019 · 22 revisions

Installation:

  • Install IIS, following the instructions as described here under the heading "Add IIS Manager".
  • Install the URL-rewrite 2.1 extension as described here under the heading "Setting up the reverse proxy for HTTPS connections".
    • Additional context for several steps:
      • Step 1:
        • Within IIS, open up the "Default Web Site" by expanding the tabs in the "Connections" window and double click on the site. The "Bindings..." option will appear in the "Actions" window on the far right, under the "Edit Site" tab.
      • Step 7:
        • Enter localhost:8081 into the only active input box, then stop after step 7. We do not need to allow "Rewrite the domain names of links in HTTP responses".
  • Download/Install node.js with npm via this link. I used the Long Term Support version.
  • Clone, (fork, or download) the temp branch of the LearnDB GitHub repo in order to work with the files locally.
    • To install the specific npm packages/modules required, navigate to the src fold of the LearnDB clone, then run the command npm install
  • To install pgweb, follow the directions as described here.

How to Run each Service:

  • pgweb:
    • Run from the command line with the flag --sessions
    • (By default in the DASSL VM, pgweb is intalled in C:/pgweb)
  • IIS:
    • Start from GUI. Search for iis in the windows search feature. Select "Internet Information Services (IIS) Manager"
    • Expand the tabs under the "Connections" window on the far left and navigate to and double click on "Default Web Site".
    • Click "Start" on the right-hand side in the "Actions" tab, underneath the "Manage Website" sub-tab.
  • LearnDB node.js server for Change Password functionality:
    • In a command terminal, navigate to the src folder of the LearnDB clone, then run the command npm start.

How to import rules:

  • Go to the /scripts/ folder of the cloned 'temp' branch of the LearnDB repo.
  • Run the importRules.bat script

How to export rules:

  • Go to the /scripts/ folder of the cloned 'temp' branch of the LearnDB repo.
  • Run the exportRules.bat script

Common Errors:

  • If you are getting a 404 error, make sure that ARR is installed and enabled, then restart IIS.
    • To install ARR, open IIS. In the 'Connections' tab on the far left, navigate to "Default Web Site".
    • Double click on "Add Rules..." in the 'Action' tab.
    • Double click on "Reverse Proxy"
    • If a window pops up asking you to Download ARR, follow the prompts. Else, if a window appears allowing you to input a reverse proxy rule, then ARR is already installed and enabled. You may need to try creating a reverse proxy again after installing it for the first time in order to enable ARR. If ARR is installed but not enabled, it will prompt the user asking if they wish to enable ARR upon trying to create a reverse proxy rule.
Clone this wiki locally