Pre Requisites for MathCraft Products

PROPRIETARY


The customer is responsible for completing all items listed below.
MathCraft will not assist with or perform any of these prerequisites.


Text Editor Application [Required]

  • NotePad++
    On both Database Server and Application Server

DNS Entries

Need 4 A records created pointing to the same App Server for Access Commander

  • Access Commander pplication
    This will be the URL that will be used by end users to access the application
    Sample A record: accesscomm.company.com
  • Dashboard
    Sample A record: accesscomm-dashboard.company.com
  • Adhoc Reporting
    Sample A record: accesscomm-reporting.company.com
  • CMS Credentials
    Sample A record: accesscomm-credentials.company.com

Need 1 A record created pointing to the same App Server for Portal Commander

  • Portal Commander Application
    This will be the URL that will be used by end users to access the application
    Sample A record: portalcomm.company.com

SSL Certificates

Will need either a wildcard certificate (*.company.com) OR separate SSL Certificates based on DNS A Records (CMS Credentials does not need one).

For Access Commander, 3 separate SSL Certificates will be needed if wildcard certificate is not an option.

For Porta Commander, 1 separate SSL Certificate will be needed if wildcard certificate is not an option.

SMTP Information

  • Host Name
  • Port Number
  • Outbound User Mailbox account with Credentials (similar to a donoreply account) or a Mail Relay Server

Database Server

  • SQL Server configured on Static Port instead of Dynamic Port
  • SQL Server configured for Mixed Mode Authentication
  • SQL Server Reporting Server installed

SQL Server Reporting Server

  • Create a non-RDP user account as ssrs-admin or ssrs-user and a password
  • Google Chrome or Microsoft Edge (Chromium) browser installed on the Database Server (temporary - you can delete after the configuration is completed)
  • Configuration of SQL Server Reporting Server Configuration Manager

Application Server

  • Oracle Java Runtime (JRE) 8 installed
  • SQL Server Connection Information
  • SMTP Information for E-Mail Services
  • SSL Certificate(s) installed in IIS for URL Bindings
  • IIS Configured to have the following Web Server features [No Exceptions]
  • Common HTTP Features
  • Default Document
  • Directory Browsing
  • HTTP Errors
  • Static Content
  • HTTP Redirection
  • Health and Diagnostics
  • HTTP Logging
  • Custom Logging
  • Logging Tools
  • ODBC Logging
  • Request Monitor
  • Tracing
  • Performance
  • Static Content Compression
  • Dynamic Content Compression
  • Security
  • Request Filtering
  • URL Authorization
  • Application Development
  • .NET Extensibility 3.5
  • .NET Extensibility 4.7
  • Application Initialization
  • ASP
  • ASP.NET 3.5
  • ASP.NET 4.7
  • CGI
  • ISAPI Extensions
  • ISAPI Filters
  • URL Rewrite IIS Module installed [Download here] [No Exception]
  • Application Request Routing IIS Module installed [Download here] [No Exception]
    Ensure the Application Request Routing proxy is enabled

Node Version

Will need Node version 22.19.0 installed on Application Server.

Google reCaptcha [Optional]

You will need Google Captcha set up and procure a Site Key and Secret Key.
Note: MathCraft doesn't provide you with the Google reCaptcha configuration..

Availability of following Port Numbers on Application Server

  • 5001
  • 5010
  • 5020
  • 5030
  • 5040
  • 6010
  • 6020
  • 6030
  • 7010
  • 7020
  • 7030
  • 7040
  • 80 (for CMS Credentials)