Informix

Plugin to remotely pull metrics data from informix.

Introduction

Ver. 09-01-2023

Plugin to remotely pull metrics data from informix.

Type: Server plug-in

Compatibility matrix

Systems where tested

CentOS 7, Fedora, rocky linux

Systems where it should work

Any linux system

Pre requisites

Parameters

Parameters 

--database Name of the database.
--hostname Ip or host.
--agent_name Name of agent.
--agent_alias Agent's alias
--use_alias_as_name Use agent alias as name
--module_prefix It is used to prefix the modules with
--port Default 9089
--uid User name
--password Password
--database Database name

Pandora configuration parameters

--tentacle_port Tentacle port (default 41121) (optional)
--tentacle_address Ip of the tentacle server to send the data to (optional)
-g,--group Pandora FMS target group (optional)
--data_dir Pandora FMS data directory. By default it is /var/spool/pandora/data_in/ (optional)
--as_agent_plugin It is optional, if you want the plugin to be an agent plugin and put the modules in the pandora agent, execute this with a 1 (optional)

Manual execution

python3 pandora_informix.py --hostname <host> --port <port> --uid <user> --database <database> --password <password> --conf <path conf> --as_agent_plugin 1

Configuration in PandoraFMS

As server plugin

Manual installation

Go to servers > plugins:

image-1629974405286.png

Click on add:

image-1629974430627.png

We put in name and the description that is preferred.

We put as command the execution with the path of the plugin:

Remember that the recommended path for the use of the server plugins is: /usr/share/pandora_server/util/plugin/

And in plugin parameters we will introduce these followed by the macro "_field<N>_", the connection parameters --hostname, --uid, --database and --password are mandatory. The default port is 9089 but it can be changed.

Remember that you can give a custom name to the agents with the --agent_name parameter

 

Once this is done, we will click on "create".

Once this is done, the only thing left to do is to call it, so we will go to some agent's view and create an add-in module:

 

image-1646741530197.png

We will give it a name and in the section "plugin" we will put the one we have just configured.

Once this is done, click on create.

If the module is shown with 1, it means that it is running correctly.

 

Modules generated by the plugin

The plugin will create an agent, with a custom name and the following modules:

 

Dbspace I/O
fname
dreads
dwrites
Dbspace usage
nchunks
total
used
pct_used
Checking tables I/O
tabnames
diskreads
diskwrites
Session statistics
hostname
logint_time
s_state
Session profile
access
locksheld
seqscans
total_sorts
dsksorts