export ORACLE_HOME=/usr/local/oracle/instantclient_11_2
export LD_LIBRARY_PATH=${ORACLE_HOME}/lib64:${LD_LIBRARY_PATH}

Remember to adjust the path to the Oracle installation directory and choose the correct library subdirectory based on the architecture of the Netprobe in use.

Mandatory: Yes

The application name to be set to the connection created from the sampler to the Database Server.

The name of the Sybase interface. This is specified in the sql.ini or interfaces file.

Mandatory: Yes

The name of the database to use when running the query.

Mandatory: Yes

The application name to be set to the connection created from the sampler to the Database Server.

The name of the SQL Server.

Note: When connecting to named instances the format should be "ServerName\InstanceName". On connection Geneos will verify the named instance actually matches the one listening on the specified port.

The port number that MySQL is listening on.

The application name to be set to the connection created from the sampler to the Database Server.

Note: This option is only valid for Windows platforms.

The name of the database to use when running the query if the database name is not specified in the query. If the query contains a valid database name, this value will be ignored.

Mandatory: No

Login using Windows authentication instead of SQL authentication.

Credentials used for Windows authentication is the username and password supplied by the user. If the username and password fields are left blank, then the currently logged-on user executing the probe will be used. Users can specify a domain by entering the username using the UPN format or the Down-level Logon format. If invalid Windows credentials are supplied, sqlServer will fallback to SQL authentication.

Note: This option is only valid for Windows platforms.

The alias of the database to use when running the query.

Mandatory: Yes

The name of the PostgreSQL server.

Mandatory: Yes

The name of the PostgreSQL database to use when running the query.

Mandatory: Yes

The port number of the PostgreSQL server.

Mandatory: Yes

The application name to be set to the connection created from the sampler to the Database Server.

The password with which to connect to the database. To set an encrypted password, click on the "Set Password" button, then enter and confirm the password to be used.

Mandatory: No

If set to true the sampler will close the connection to the database after each query. This frees resources for other processes that may connect to the database but makes the sampler a little less efficient. If false the connection remains open but is returned to a pool of connections for reuse within the netprobe.

When using a large sample interval (e.g. running queries every hour), setting this parameter to true will reduce database resources without significantly impacting Netprobe performance.

Headlines showing the rows returned, query status and query time taken should be displayed

Mandatory: No

It is generally not useful to set the plug-in sample interval to a very small value, as most queries take some time to evaluate (if you are interested in real-time plots of data, the Active Chart feature of ActiveConsole may be more suitable). If the system attempts to sample before the current query has returned, the plug-in will ignore the sample request.

Each row should be numbered to indicate its place relative to the other rows.

To help track down problems, the printing of debug statements can be enabled by adding a debug setting to the sampler set-up called SQL-TOOLKIT. This results in the plug-in printing statements each time it attempts something of significance e.g. attempting to open a connection to a database, being unable to connect to a database, etc.

Depending on what database your Netprobe needs to connect to, you may have to amend your environment to expose the appropriate libraries to the Netprobe. The Netprobe indirectly loads these libraries depending on what database the plug-in has been configured to connect to.

Note:  For MySQL 8.0, only mysql_native_password authentication is supported. The caching_sha2_password option is not supported.

Linux

When MySQL is installed via packaged installation, it automatically adds /user/lib64/mysql to the list of directories (/etc/ld.so.conf.d) where the dynamic linker searches for libraries. This way, even if you do not set LD_LIBRARY_PATH, the Netprobe can find the library in /usr/lib64/mysql.

Windows set PATH=C:\Program Files\MySQL\MySQL Server 5.0\bin;%PATH%