Environment
Identity Manager 4.5
PostgreSQL
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
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
- 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