Installation Guide elproMONITOR 3.0.0
1. System Requirements
This manual is based on Windows Server 2019 (ENU) and SQL Server 2019 (ENU). If you use other Windows versions, some details may vary from the instructions in this manual.
For Windows Server and client oprating systems like Windows 10/11 only English and German are supported!
1.1. Supplied Program Packets
The list below contains the software packets supplied.
SW Module | Description | Directory |
|
|---|---|---|---|
elproMONITOR Service | Service which reads the measuring values out of the loggers and writes them to the database. | Program Files\elproMONITOR <VersionNumber>\MonitorService\ |
|
elproMONITOR Web Application | elproMONITOR web application called up from the browser. | websites\elproMONITOR <version number>\WebClient |
|
elproMONITOR SQL Script | SQL script which is needed to create the schema for the elproMONITOR database. | Setup Files\SQLScripts\CreateMonitorSchema.sql |
|
Management Tool | The Management Tool is needed to create the configuration XMLs and to enter and activate the license key. | Program Files\elproMONITOR ManagementTool <Version Number> |
|
MSVC Redistributables | Redistributables which are needed to execute elproMONITOR. | Setup Files |
|
elproEVENT Application | The elproEVENT application. | Program Files\elproEVENT <Version Number>\Application Folder |
|
elproEVENT SQL Script | SQL script which is needed to create the schema for the elproEVENT database. | Setup Files\SQLScripts\CreateEventSchema.sql |
|
elproUSER Service | Service that uses rights and user management. | Program Files\elproUSER<Versionsnumber>\UserService |
|
elproUSER SQL Script | SQL script which is needed to create the schema for the elproUSER database. | Setup Files\SQLScripts\CreateUserSchema.sql |
|
RabbitMQ Service | Service, which communicates with the ECOLOG-PRO Radio Module via MQTT protocol. | Setup Files\RabbitMQ 3.12.10 |
|
ProModulConfigurator | Configuration tool for editing the ECOLOGPRO modules | Program Files |
|
RBRConfigurator | Config-Tool zum bearbeiten der ECOLOG-PRO RBR Modules | Program Files |
|
3. Definition of Target System
Before you start the installation, define how the target system should look like.
3.1. Default Proposal to Create New Users
User | Access Rights |
|---|---|
elproMonitorDBUser | Dedicated user for the elproMONITOR application database. Has read/write rights to this database. |
elproEventDBUser | Dedicated user for the elproEVENT application database. Has read/write rights to this database. |
elproUserDBUser | Dedicated user for the elproUSER application database. Has read/write rights to this database. In addition, read-only rights must be granted for the following tables in the elproMONITOR and elproEVENT application databases.
|
elproUser | Optionally, you can create a Windows user. Is the executing user of the elproMONITOR Service, elproEVENT, and elproUSER. |
3.2. Default Proposal to Create New Databases
Database | Description |
|---|---|
elproMONITOR | Database for the elproMONITOR application. |
elproEVENT | Database for the elproEVENT application. |
elproUSER | Database for the elproUSER application. |
3.3. Default Proposal to Create Directories
Name | Description | Default Path Proposal |
|---|---|---|
Program Directory | Programs are installed in the default program directory. | C:\Program Files\ELPRO |
Configuration Directory | Stores database access configurations and licensing data | C:\ProgramData\ELPRO\License |
Web Application Directory | For safety reasons, we urgently advise you to install the web client application in the official web publication directory. It is possible to install the web application together with IIS on a separate computer. The installation directory relates to this computer | C:\ProgramData\ELPRO\Websites |
4. Installing the Basic System
4.1 Server
4.1.1. Server Setup
Standard server installation
Configure server name
Control Panel → System → Change Settings → Computer Name → Change
Enter new name:
e.g. MONITOR
4.1.2. Firewall Configuration
4.1.2.1. Activate Remote Desktop Service
Remote Desktop
Control Panel → System → Change settings → Remote → Remote DesktopAllow
Allow remote connection on this computer only from computers running Remote Desktop with Network Level Authentication.
Firewall Rules
Control Panel → Windows Firewall → Advanced Settings → Inbound RulesAllow
Remote Desktop - User Mode (TCP-In) Profile Public
4.1.2.2. Allow Ping
Firewall Rules
Control Panel → Windows Firewall → Advanced Settings → Inbound RulesAllow
File and Printer Sharing (Echo Request - ICMPv4-In)
4.1.2.3. Firewall ports and protocol overview
Name | Windows Firewal Rule | From | To | Port | Protocol | Comments |
ECOLOG-NET | Incoming | AppServer | Logger | 2101 | TCP | n/a |
ECOLOG-PRO | Incoming | AppServer | Logger | 502 | TCP | n/a |
ECOLOG-PRO Push | Incoming | AppServer | Logger | 1883 | TCP/UDP | unencrypted access |
ECOLOG-PRO Push | Incoming | AppServer | Logger | 8883 | TCP/UDP | encrypted access |
SMS-Modem | Incoming | AppServer | Modem | 10001 | TCP | n/a |
Website Access | Incoming | WebServer | Clients | 80, 81 | http | unencrypted access |
Website Access | Incoming | WebServer | Clients | 443 | https | encrypted access |
SQL-Instance | Incoming | SQL-Server | AppServer | 1433 | TCP | Default Instance |
SQL-Browser | Incoming | SQL-Server | AppServer | 1434 | UDP | Named Instance |
WcfBaseAddress | Incoming | AppServer | WebServer | 8000, 8001 | TCP | Webserver is separated |
4.1.2.4. Firewall Rules
elproMONITOR WebClient
Should the elproMONITOR WebClient be located on a different server, the port between IIS and Service must be opened on the elproMONITOR Service Machine.
Control Panel → Windows Firewall → Advanced Settings → Inbound Rules → NewRule→Port→TCP, Specific Local Ports: <Service Port (8000 as default)→ Allow Connection → All Profiles
Port 8000
Open Port 8000 only if the webserver is dedicated
Database
If the database is located on a different server, set up the necessary port to allow access.
Control Panel → Windows Firewall → Advanced Settings → Inbound Rules → New Rule → Port → TCP, Specific Local Ports: <Service Port (1433 as default) → Allow Connection → All Profiles
Port 1433
ECOLOG-NET
Open this port for accesses:
New Rule → Port → Tcp, Specific Local Ports: <Service Port (Standard 2101) → Allow Connection → All profiles
Port 2101
ECOLOG-PRO
Open this port for accesses:
New Rule → Port → Tcp, Specific Local Ports: <Service Port (standard 502) → Allow Connection → All profiles
Port 502
ECOLOG-PRO PUSH
Open this port for accesses:
New Rule → Port → TCP, Specific Local Ports: <Service Port (standard 1883) → Allow Connection → All profiles
Port 1883 - TLS unencryptedNew Rule → Port → TCP, Specific Local Ports: <Service Port (standard 8883) → Allow Connection → All profiles
Port 8883 - TLS encryptedNew Rule → Port → TCP, Specific Local Ports: <Service Port (standard 5672) → Allow Connection → All profiles
Port 15672
Open Port 15672 only if RabbitMQ should be available from an external source like client PC
New Rule → Port → UDP, Specific Local Ports: <Service Port (standard 1883) → Allow Connection → All profiles
Port 1883 - TLS unencryptedNew Rule → Port → UDP , Specific Local Ports: <Service Port (standard 8883) → Allow Connection → All profiles
Port 8883 - TLS encrypted
ECOLOG-PRO RBR Configurator
New Rule → Port → TCP, Specific Local Ports: <Service Port → Allow Connection → All profiles
Port 22123
SMS modem
New Rule → Port → TCP, Specific Local Ports: <Service Port → Allow Connection → All profiles
Port 10001
http://msdn.microsoft.com/de-ch/library/ms175043.aspx
4.2 IIS Installation
IIS must be installed on the computer on which the web application is to run.
Start Server Manager.