Integrating with a MySQL Server database

This topic describes how to create and configure a MySQL Server database to integrate it with Netcool/OMNIbus.

To integrating the JDBC Gateway with MySQL Server, use the following steps:

Step 1: Installing the MySQL JDBC Driver

Refer to the MySQL website for more information on the currently supported driver versions.

Copy the MySQL JDBC Driver for example, mysql-connector-java-8.0.20.jar to the $OMNIHOME/gates/java directory.

Step 2: Preparing tables for Netcool integration

Preparing AUDIT mode:

Use the scripts bundled in the nco-g-jdbc-audit-scripts package under the directory mysql.

In the command prompt, navigate to the mysql directory and run the following command to create the AUDIT tables in your database:

> run ./mysqlinstall

Run mysqlinstall to install the database tables.

You can check that the tables have been created using the following command:

Login to mysql -u <user_name> -p <password>
 mysql> show databases;
 mysql> use alerts; 
 mysql> show tables;
Note: Mysql is only supported in AUDIT Mode.

Step 3: Configuring the gateway

Specify the correct mode to be used (namely, AUDIT):

Gate.Jdbc.Mode: 'AUDIT' # STRING (JDBC gateway mode (AUDIT|REPORTING))

Specify the JDBC connection properties:

Gate.Jdbc.Driver: 'com.mysql.cj.jdbc.Driver' # STRING (JDBC Driver) 
Gate.Jdbc.Url: 'jdbc:mysql://<hostname or IP address of the MySQL Server>:3306/alerts' # STRING (JDBC connection URL) 
Gate.Jdbc.Username: 'netcool' # STRING (JDBC username) 
Gate.Jdbc.Password: 'password' # STRING (JDBC password)

In the above example, the gateway is configured to connect to the ALERTS database using the user netcool.

If a secure connection is required to be used by the gateway, the following should be configured:

Gate.Java.Arguments: ‘-Djavax.net.ssl.trustStore=<path to truststore file> -Djavax.net.ssl.trustStorePassword=<truststore file password>' # STRING (JDBC connection URL)