The Application Server and the Database

The Ekran System Application Server is the main component in the system. It provides for the interaction between the other components. The Application Server stores all monitored data, user accounts, and system settings in the database.

Table of Contents

• Comparison of Database Types
• Comparison of Standard and High Availability Modes
• Installing the Remote PostgreSQL Database Server and Configuring Remote Access
• Installing/Uninstalling/Updating the Application Server
  • Installing the Application Server
  • Backing Up the Master Certificate
  • Deleting the Master Certificate
  • Importing the Master Certificate
  • Reissuing the Ekran System Master Certificate
  • Installing the Application Server in the Cloud
  • Adding the Application Server Executable to Windows Firewall
  • Using an External/Cloud-Based Application Server
  • Updating the Application Server
  • Uninstalling the Application Server
  • Changing the Application Server Port for Client Connection
  • Running the EkranServer Service under a User Account
  • Adding Permissions for a Non-Admin User to Start EkranServer
  • Enabling SWIFT Username Monitoring
  • Enabling the Displaying of the Warning and Consent Banner
• The Server Tray Application
• Database Management
  • Cleanup Parameters
  • One-Time Cleanup
    • One-Time Cleanup while Editing a Client
    • One-Time Cleanup while Editing a Client Group
  • Scheduled Cleanup
    • Scheduling a Cleanup while Editing a Client
    • Scheduling a Cleanup while Editing a Client Group
  • Editing the Database Parameters
  • Cleaning Up the Sessions of Deleted Clients
  • Shrinking the MS SQL Database Transaction Log
  • Autovacuuming the PostgreSQL Database
  • Deleting Clients
  • Moving the Server Database
    • Moving the MS SQL Database
      • Moving the MS SQL Database on the Same Computer
      • Moving the MS SQL Database to Another Computer
      • Moving the MS SQL Database Signed with a Certificate to Another Computer
        • Exporting the Trusted Certificate
    • Moving the PostgreSQL Database
      • Moving the PostgreSQL Database on the Same Computer
      • Moving the PostgreSQL Database to Another Computer?
  • Validating Monitoring Data
    • Validating Monitoring Data Using Hash Codes
    • Signing Monitoring Data with a Certificate
      • Step 1. Importing a Trusted Certificate
      • Step 2. Enabling the of Signing of Monitoring Data with a Certificate
  • Deleting the PostgreSQL Database
  • Isolating the Database from Clients