Quick Installation & Configuration of the new Deflashed Version of Insight (v2021.0.1 – Full Product) in Windows

[Avik_Dey1 (Avik Dey)]

INSIGHT SERVER INSTALLATION

PREREQUISITES

1. Java 8 SDK should be installed & the path to [Java Installation Folder]\bin should be set in the Path variable in System variables section of the Environment Variables window of the target machine.

STEPS TO INSTALL

PREREQUISITE: Download the package Insight(v2021.0.1 – Full Product) from Empower

1. Unzip the installer package.
2. Open the install.cmd file located in the [unzipped package] folder in an editor
3. Locate the part - %INSIGHT_BASE% in the opened file & replace it with the location where the installation needs to happen(Ex: C:\BaseFolder).
4. Save the install.cmd file.
5. Open the command prompt in Administrator mode & navigate to the location of [unzipped package] folder & run the install.cmd
6. Once the installation is complete, the following message will be displayed in the command prompt window:

STEPS TO START THE SERVER

1. Open the command prompt in the Administrator mode & navigate to the path as shown below & run launchcontainer.bat file
   C:\BaseFolder\Messenger\Containers\Insight.ctInsightMessenger
2. Once the Messenger is successfully started, the below message should be displayed as a part of the starting up log:

1. Open the command prompt in the Administrator mode & navigate to the path as shown below & run StartInsightServer.cmd file
   C:\BaseFolder\InsightServer\DefaultProfile\bin

2. Once the Insight Server is successfully started, the below message should be displayed as a part of the starting up log:

DATABASE & TABLE CREATION

The chosen DB & GUI to interact with the DB is MS SQL 2019 & SQL Server Management Studio v18.8. The DB resides in a different machine.

1. Create a DB in the MS SQL Server 2019 using the ‘sa’ user.
2. Create a user using the ‘sa’ user & map the user-created to the DB created in step 1
3. The Database role membership for the user created in Step 2 for the DB created in Step 1 should be db owner & public.
4. Navigate to the folder as shown below in the Insight Server installation machine & locate the ActionalServerCreationScript.sql script
   C:\BaseFolder\InsightServer\config\SQL\SQLServer
5. Execute the script ActionalServerCreationScript.sql in the DB created in Step 1 & make sure there are no visible errors

SQL Server Management Studio is the interface through which all interactions with the MSSQL 2019 is done.

The embedded DB i.e. Derby can also be used as per convenience of the setup & scale.

CONFIGURING THE INSIGHT SERVER

1. Invoke the URL
   http://[machine_name]:4040/lgserver/initial/index.jsp

2. Click on the START button shown below:

3. Provide the license either as a string or as a file & click Next.

4. Specify the intended User Name & Password for logging in to the Admin console of the server as shown below & click Next.

5. In the Database section input the following details:

• Database Type (drop down) –Ex : External JDBC Driver
• Username & Password for logging into MS SQL 2019 server
• Connection URL - jdbc:sqlserver://[machine_name]:1433;databaseName=[DBName]
• JDBC Driver Name: com.microsoft.sqlserver.jdbc.SQLServerDriver
• JAR File: mssql-jdbc-8.4.1.jre8

Once the details are filled & the JAR file uploaded, click on Verify Database(green) button as shown below & if everything is fine, the connection successful message would be displayed. Click Next.

6. The below screen will be displayed. Click Finish.

7. Page with a prompt to fill in the username & password for logging in to the Administration console of the Insight Server will be displayed. Click on Sign in after filling in the details.

8. The following screen should be displayed.

INSIGHT AGENT INSTALLATION

PREREQUISITES

1. Java 8 SDK should be installed & the path to [Java Installation Folder]\bin should be set in the Path variable in System variables section of the Environment Variables window of the target machine.

STEPS TO INSTALL

2. Navigate to the [unzipped package] folder & copy the Insight_Agent_Launcher.zip file to the machine which will be monitored.
3. Create a directory i.e. C:\Insight\InsightAgent in the machine where the above zip is copied
4. Extract the archive in this directory.
5. Edit configuration.json inside C:\Insight\InsightAgent\Insight_Agent_Launcher with the information below :

• Replace localhost with the name of the Insight server machine for the key, url
• For the key, username, the value is the Insight Server Admin login username.
• For the key, password, the value is the Insight Server Admin login password.

6. Save the configuration.json after the changes

DATABASE & TABLE CREATION

The chosen DB & GUI to interact with the DB are MS SQL 2019 & SQL Server Management Studio v18.8. The DB resides in a different machine.

1. Create a DB(InsightDB, here) in the MS SQL Server 2019 using the ‘sa’ user.

2. Create a user(InsightUser, here) using the ‘sa’ user & map the user-created to the DB created in step 1.

3. The Database role membership for the user created in Step 2 for the DB created in Step 1 should be ‘db owner’ & ‘public’.

4. Navigate to the folder as shown below in the Insight Server installation machine & locate the ActionalAgentCreationScript.sql script

          ` C:\BaseFolder\InsightServer\config\SQL\SQLServer `
   

5. Execute the script ActionalAgentCreationScript.sql in the DB created in Step 1 & make sure there are no errors
   SQL Server Management Studio is the interface through which all interactions with the MSSQL 2019 is done.

Both Insight Server & Insight Agent can point to the same DB or different DBs. In the scenario described in this article both the Agent & Server point to the same DB. Only Step 4 & 5 are applicable as Step 1 to 3 are already accomplished while setting up Insight Server.

Insight Agent stores & maintains statistical information in the DB whereas Insight Server stores runtime information.

The embedded DB i.e. Derby can also be used as per the convenience of the setup & scale.

STEPS TO START THE AGENT

1. Navigate to the C:\Insight\InsightAgent\Insight_Agent_Launcher\bin & run launcher.exe

2. On the successful start of the agent, the following message is displayed in the starting up log

CONFIGURATION FOR THE AGENT

1. Navigate to http://[machine name]:4040/lgserver/admin/services/profile/profile_details.jsp?task=edit&keyID=AgentDefaultProfile&origin=deployment/agents/agents_list

2. Make sure the following key=value pair is available under the label Additional JVM Options
   -Dcom.actional.lg.agent.allowRemoteConnections=true

   2(a). Navigate to Configure>Platform>Local Users in the Insight Server machine & click on the Add button as shown below:

3. Fill in all the details as shown below & click Finish . The created user is: AgentAdmin here.

4. The list of users is displayed as below:

5. Navigate to Configure>Platform>Local Roles in the Insight Server Admin as shown below:

6. Check the box next to Superuser & click on the Superuser link to have the page below:

7. Click on the Edit link next to the label – Users Belonging To Role to have the page
   below:

8. Click on the Add … button to have the page below:

9. Select the checkbox next to AgentAdmin & click on the Add Selected Items to Role button to have the page below:

10. Select the checkbox next to AgentAdmin & click on OK to have the page below:

11. Click on Done & navigate to Configure>Platform>Local Users in the Insight Server Admin page to verify the Role associated as shown below:

12. Navigate to
    http://[machine name]:4040/lgserver/admin/deployment/agents/agents_list.jsp?preSelectOutdated=true to see the license missing for Agent as shown below:

13. Navigate to Configure>Platform>License in the Insight Server Admin page to have the page below:

14. Click on Add to have the page as shown below:

15. Input the license key value by selecting the first radio button & click on OK to have the page as shown below:

16. Navigate to the Provisioning tab in the Insight Server admin page to have the page below:

17. Expand the dropdown under Message/Details to look for instructions as shown below:

18. Select the checkbox next to the Hostname & execute the action(s) of either provisioning or restarting as instructed under Message/Details . Restarting is done from the More dropdown. Once successfully completed the page below is displayed:

19. Invoke http://[machine name]:4041/lgagent to have the page below:

20. Login with AgentAdmin & the password set up under Configure>Platform>Local Users in the Insight Server Admin page to have the page below:

21. Navigate to Configuration>Agent Database in the Insight Agent Admin page & click on the edit link next to Main Database Configuration label as shown below:

22. Fill in the details as shown below & click on Verify Database

23. The below success message should be displayed. Click OK.

VISIBILITY OF AGENT NODE IN SERVER

1. Navigate to http://[machine name]:4040/lgserver/admin/operations/overview/index.jsp
2. The Agent Node should be visible as shown below:

The name of the node is blurred for security reasons.