How do I enable monitoring of the PostgresSQL database using the UIM jdbc_response probe?

book

Article ID: 35831

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

Introduction:

As of UIM 8.31 there currently is not a dedicated probe to monitor the PostgreSQL database Server. By following the steps below you can enable monitoring of this SQL database by utilizing the jdbc_response probe.
  

Environment:  

  •  UIM 8.2 or UIM 8.31
  •  Controller version 7.X
  •  Jdbc_response probe 1.23
  •  UIM java_jre 1.7X
  

Instructions: 

Part I - On PostgreSQL Server:

Depending on OS (Windows/Linux) and *NIX flavor (RPM-based or Debian-based), configuration may vary (please refer to your platform's PostgreSQL documentation). Generally PostgreSQL configuration file is postgresql.conf
  1. Enable Remote access for PostgreSQL:
        a. In postgresql.conf, make PostgreSQL Listen on Ethernet IP address: listen_addresses = '10.0.0.2'
 
        b. Enable remote access from jdbc_response probe robot:
              In pg_hba.conf
              host all all 10.0.0.31/24 password
 
        c. Restart PostgreSQL database service:
              # /etc/init.d/postgresql restart
 
    2. Create/allow PostgreSQL monitoring user:
        a. Login to PostgreSQL using 'psql' command as an admin user
              $psql -U pguser -W
              Enter password for the PostgreSQL admin user
 
        b. Create PostgreSQL monitoring user:
              postgres =# createuser dbuser with password 'password';
 
        c. Grant new user access to monitored databse:
               postgres=# grant all on database pgdb to dbuser;

  

Part-II - On 'jdbc_response' Probe Robot:

 
  1. Download PostgreSQL JDBC Driver from PostgreSQL site:
 
  2. Rename postgresql-8.4-701.jdbc4.jar to pg.jar for your convenience to use driver name
 
  3. Copy pg.jar to \probe\database\jdbc_response\jar\
 
  4. Change runprobe.bat:
      set CLASSPATH should look like this:
      set CLASSPATH=jar\jdbc_response.jar;jar\nimsoft.jar;jar\TwoFish.jar;jar\oracle.jar;jar\sql_drv.jar;jar\pg.jar
     Verify the existence of jar\pg.jar
 
  5. In jdbc_response probe connection properties:
      Database URL: jdbc:postgresql://10.0.0.2:5432/pgdb
      Driver Name: org.postgresql.Driver
      Driver Path: /Program Files/Nimsoft/probes/database/jdbc_response/jar/pg.jar
      User ID: dbuser
      Password: dbuser_password
 
You should be able to connect PostgreSQL Server database using the jdbc_response probe.

Note:

  1. Make sure you have JRE installed on jdbc_response probe robot.
  2. On PostgreSQL server, modify firewall rules to allow connection to PostgreSQL port (default is 5432/tcp).
  3. URL to jdbc driver could be outdated but should be able to find the latest from the website. 

 

Additional Alternative:

You can use the sql_response probe to monitor a Postgresql database.
You can add Postgresql as successfully queried through an ODBC connection using the Postgresql ODBC driver.


The PostgreSQL database driver can be downloaded from the following location:

http://wwwmaster.postgresql.org/download/mirrors-ftp/odbc/versions/msi/psqlodbc_08_03_0400.zip

 

Environment

Release: CNMSPP99000-7.6-Unified Infrastructure Mgmt-Server Pack-- On Prem
Component: