Administering IDM Postgres from a Linux desktop

  • 7015958
  • 07-Dec-2014
  • 07-Dec-2014

Environment

Identity Manager 4.5
PostgreSQL

Situation

NetIQ provides a convenience installer for PostgreSQL to be used as the database for the Roles Based Provisioning Module. The NetIQ Identity Reporting module also uses PostgreSQL.

The Postgres administration tool, pgadmin3 is installed by the convenience installer on the Identity Manager server.
This tool is started with the command

/opt/netiq/idm/apps/postgresql/pgAdmin3/bin/pgadmin3

if no other configuration is done, the likely response is
/opt/netiq/idm/apps/postgresql/pgAdmin3/bin/pgadmin3: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory

Resolution

On a linux desktop, a GUI such as Gnome or KDE is required and two parameters need to be configured.
- A path to java is needed
This could be set in the users profile
for example

#Java Home
export JAVA_HOME=/root/jdk1.8.0_25
#JRE Home
export JRE_HOME=$JAVA_HOME/jre
export PATH=$JAVA_HOME/bin:$PATH


- a path to the share libraries required by pgAdmin3
this could be added to a script that launches pgAdmin3
for example

#!/bin/bash
export LD_LIBRARY_PATH=/opt/netiq/idm/apps/postgresql/pgAdmin3/lib/:/opt/netiq/idm/apps/postgresql/lib/
/opt/netiq/idm/apps/postgresql/pgAdmin3/bin/pgadmin3