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

INSIGHT SERVER INSTALLATION

PREREQUISITES

  1. Java 8 SDK should be installed. OpenJDK has been used for this set up. Execute the command below from the terminal,

sudo yum install java-1.8.0-openjdk

  1. Open the .bashrc or .bash_profile file & add the following entries in sequence

export JAVA_HOME=/usr/lib/jvm/[OpenJDK jdk]

export PATH=$PATH:$JAVA_HOME/bin

export CLASSPATH=.:$JAVA_HOME/jre/lib:$JAVA_HOME/lib:$JAVA_HOME/lib/tools.jar

  1. Execute the command below,

sudo source ~/.bashrc or sudo source ~/.bash_profile

  1. Enable the ports 4040, 2506 in the machine where Insight Server will be installed for TCP connections by executing the below commands successively.

sudo firewall-cmd --add-port=4040/tcp --permanent

sudo firewall-cmd --add-port=2506/tcp --permanent

  1. Restart the machine.

This setup has been created with Insight Server, Agent & Database in 3 separate machines respectively. All the 3 software viz: Insight Server, Agent & Database can be in the same machine as well. Fit as per the case.

STEPS TO INSTALL

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

  1. Unzip the installer package in the location /home/[user]

  2. Open the install.sh file located in the [unzipped package] folder in a vi editor

  3. Locate the INSIGHT_BASE key in the opened file & replace the value with the location string where the installation needs to happen

         (Ex: /home/[user]/BaseFolder).
    
  4. Save the install.sh file.

  5. Open the terminal & navigate to the location where install.sh is located & run the sudo install.sh command.

  6. Once the installation is complete, the following message will be displayed in the terminal window:
    image

STEPS TO START THE SERVER

  1. Open the terminal & navigate to the path below & run sudo launchcontainer.sh

     /home/[user]/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:

image

  1. Open the terminal & navigate to the path below & run
    sudo StartInsightServer.cmd

/home/[user]/BaseFolder/InsightServer/DefaultProfile/bin

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

image

DATABASE & TABLE CREATION:

The chosen DB & GUI to interact with DB are 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

       /home/[user]/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 the 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

image

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

image

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

image

  1. 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.

image

  1. The below screen will be displayed. Click Finish

image

  1. 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 the details.

image

  1. The following screen should be displayed.

image

INSIGHT AGENT INSTALLATION

PREREQUISITES

  1. Java 8 SDK should be installed. OpenJDK has been used in this setup. Execute the command below,

sudo yum install java-1.8.0-openjdk
2. Open the .bashrc or .bash_profile file & add the following entries in sequence

export JAVA_HOME=/usr/lib/jvm/[OpenJDK jdk]
export PATH=$PATH:$JAVA_HOME/bin
export CLASSPATH=.:$JAVA_HOME/jre/lib:$JAVA_HOME/lib:$JAVA_HOME/lib/tools.jar 
  1. Execute the command below:

sudo source ~/.bashrc or source ~/.bash_profile

  1. Enable port 4041 in the machine where Insight Agent will be installed for TCP connections by executing the below command from the terminal.

sudo firewall-cmd --add-port=4041/tcp --permanent

  1. Restart the machine.

This setup has been created with Insight Server, Agent & Database in 3 separate machines respectively. All the 3 software viz: Insight Server, Agent & Database can be in the same machine as well. Fit as per case.

STEPS TO INSTALL

  1. Unzip the installer package.
  2. Navigate to the [unzipped package] folder & check if Insight_Agent_Launcher.tar.gz file is present.
  3. Create a directory i.e. /opt/insight/agent & copy the tar file of Step 2 here.
  4. Extract the archive in this directory.
  5. Edit configuration.json inside /opt/insight/agent 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.
  1. Save the configuration.json after the changes

DATABASE & TABLE CREATION

The chosen DB is MS SQL 2019 for this article & 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

/home/saguser/BaseFolder/InsightServer/config/SQL/SQLServer

  1. 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 /opt/insight/agent/bin & run sudo launcher.sh
  2. On the successful start of the agent, the following message is displayed in the starting up log:

image

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:

image

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

image

  1. The list of users is displayed as below:

image

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

image

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

image

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

image

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

image

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

image

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

image

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

image

  1. 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,

image

  1. Navigate to Configure>Platform>License in the Insight Server Admin page to have the page below,

image

  1. Click on Add to have the page as shown below,

image

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

image

  1. Navigate to the Provisioning tab in the Insight Server admin page to have the page below,

image

  1. Expand the dropdown under Message/Details to look for instructions as shown below,

image

  1. 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,

image

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

image

  1. Login with AgentAdmin & the password set up under Local Users to have the page below:

image

  1. 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:

image

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

image

image

image

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

image

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.

image

1 Like

Very detailed article.
I appreciate the efforts put forth to document and share it.

HI … has anyone been successful with this installation using UM as the JMS provider?

This is a knowledge-base article. You’ll have a better chance, if you create a new Forum post with your question and then reference this article in it.

KM

1 Like