Installation

This installation procedure assumes that you use a freshly installed Windows computer e.g. running Windows Server 16. It installs the latest release of MySQL 5.7 and the Helium Management Software 2.7.2.

1. Download the latest version of the Helium Management Software. For the moment, the binaries can only be downloaded from the HZB cloud.

2. Download MySQL server 5.7.34 from the MySQL website. Select the community installer (513 MB).

3. Install MySQL Server

• Allow Windows to execute the installer
• Choose "Server only"
• Accept to install the Microsoft Visual C++ redistribute package
• Select the configuration type "Server Computer"
• Keep the default port 3306 and open the firewall port
• Provide a root password "!password!"
• Create a user account "user" (replace user with your username)
• Accept the windows service name "MySQL57"
• Run service as Standard Windows Account
• Apply the configuration

4. Add MySQL server path to known apps

• Open the File Explorer
• Navigate to the folder C:/Program Files/MySQL/MySQL Server 5.7
• Hold down the shift key and then right-click the bin folder, then select copy as a path
• Open the Windows 10 settings, search "Environment Variables", select "Edit env. variables for your account"
• Under the user variables section, select the variable Path, and then click the Edit button
• Add the copied path

5. Create the database

• Open the Command Prompt
• Enter the command mysql -u root -p followed by the root password
• Create the database with CREATE DATABASE helium CHARACTER SET utf8 COLLATE utf8_unicode_ci;
• To check the creation use SHOW CREATE DATABASE helium;

6. Create tables

• Access the created database with USE helium;
• Create tables from the latest provided SQL file (gam_create_MySQL_********.sql) with e.g. SOURCE C:\Users\lelievre\Desktop\gam_create_MySQL_20201126.sql;
• (Replace tabs with spaces if needed in the .sql file)

7. Add data required to run the server app

• Insert data from the latest provided SQL file (gam_inserts_MySQL_********.sql) with e.g. SOURCE C:\"Users\lelievre\Desktop\gam_inserts_MySQL_20201126.sql;

8. Create a user 'helium' with appropriate permissions for the server application

• CREATE USER IF NOT EXISTS helium IDENTIFIED BY '<PASSWORD>';
• GRANT DELETE, INSERT, SELECT, UPDATE ON helium.* TO helium;

9. Create virtual COM ports on server for each base station

• Download CPR v4.3.0.3 from the Lantronix website
• Install CPR v4.3.0.3
• Open "Windows Firewall Advanced Security" and open UDP Ports 30718, 43282, 43283
• Launch CPR as administrator
• Click on "Add/Remove" to add COM ports. In the Settings section, enter the IP address and port number 10001.
• Click on "Add Rx Port/Users/lelievre/Desktop/CPR-Screenshot.png" to allow the traffic through the firewall (if it is enabled).