Configuring PostgreSQL to accept external connections

  • 7004893
  • 19-Nov-2009
  • 26-Apr-2012

Environment

Novell Identity Audit
Novell Identity Audit Reports

Situation

Unable to connect to PostgreSQL database while configuring Jasper iReport.

Resolution

1) Edit /opt/novell/identity_audit_1.0_x86-64/3rdparty/postgresql/data/pg_hba.conf and add:
host    all         all         <subnet>/<mask>            md5

Example: host    all         all         10.0.0.0/8            md5

2) Edit /opt/novell/identity_audit_1.0_x86-64/3rdparty/postgresql/data/postgresql.conf and add:
listen_addresses = '*'

3) Restart Identity Audit services: /etc/init.d/identity_audit restart

Additional Information

NOTE: there are some Jasper templates available at: /opt/novell/identity_audit_1.0_x86-64/data/server.cache/JASPER_REPORT.