Using SQL to monitor applications, processes, networks, and servers with HEYMon and HEYMonSQL.


Next ===>

HEYMonSQL Application components

There are two components to HEYMonSQL, a client and the HMSQL Server.
The client is used to send SQL requests to the HEYMonSQL (HMSQL) Server.
The HMSQL Server receives requests from clients and converts SQL into a HEYMon job request. The HEYMon job is executed immediately and the results of the job are returned to the client.

By supporting a client/server connection, HEYMonSQL allows you to place the HEYMon engine on one system and execute queries from the same system, or any other system on the network.

Before installing the HEYMonSQL files, determine where you want to host the HMSQL Server and the clients.
You can setup everything on the same system, and do not have to use two separate systems for HEYMonSQL. HEYMon and HEYMonSQL will run on just about any operating system, including Linux, Windows (all versions), and UNIX.
HEYMonSQL and its clients can be setup on any operating system, and do not need to both be on the same operating system.


Installing HMSQL Server and the HEYMon engine

The HMSQL Server is comprised of the HEYMonSQL.jar file, a lib directory with some other JAR files, and a script to start the HMSQL Server process.
HMSQL is delivered in a single TAR.GZ or ZIP file. The TAR/ZIP file should be decompressed with the directory/folder names included.
To install HMSQL Server you should create a directory/folder to hold the files. The directory/folder and its contents should allow process execution and should allow read and write by its owner. On the Windows platform, a directory/folder should be created by an Administrator user on the C: drive, such as C:\HEYMonSQL. The directory/folder name can be any value.
Also on Windows, DO NOT create or use a directory/folder which is in the Program Files or Program Files(X86) location.
Once the directory/folder is created, extract the contents of the TAR/ZIP file into the directory/folder and the 'installation process' is complete.
When the files are extracted on a non-Windows platform, the file HMSQLServer.sh should be setup for execution (ex: chmod +x).
When the files are extracted on the Windows platform, select the file HMSQLServer.bat and configure it to 'Run as Administrator'.
The files, and HMSQL Server are ready to run! No other setup or configuration is needed!


Startup HEYMonSQL and the HEYMon engine

To use HEYMonSQL, the server process should be started first. To start HEYMonSQL, just execute the HMSQLServer script on your favorite computer (any platform will run HEYMonSQL).
On Windows, double-click on the file HMSQLServer.bat to start HEYMonSQL.
On platforms other than Windows, execute the HMSQLServer.sh script to start HEYMonSQL.
When HEYMonSQL is started you will see a message indicating the server has started:

     Starting HEYMon HMSQL Server v.3.7
   HMSQL server listening on port 7164


Note that HEYMonSQL listens for connections on port 7164. If there is a firewall or malware program on the same system as HEYMonSQL, then TCP-IP port 7164 may need to be configured to allow traffic to and from remote systems.
In the next release of HEYMon we will allow ways to configure the port number to a different value.


How to interact with HMSQL Server

To communicate with HMSQL Server you will need to use one of the HMSQL clients.
In version 3.7 there are two clients for the HMSQL Server, which can be described as follows:


          Next ===>