Common errors while connecting to PostgreSQL or Oracle datamarts

You may encounter these errors while configuring your datamart to allow queries from external tools.

PostgreSQL database access error

Error: psql: FATAL: no pg_hba.conf entry for host "111.111.111.111", user "test", database "datamart"

This error in a PostgreSQL datamart is because TeamForge is not granting access to your IP address.

Solution: Have the TeamForge administrator grant access to your IP address.

PostgreSQL authentication error

Error: psql: FATAL: password authentication failed for user "test"

Solution: Specify the correct user name and password.

PostgreSQL connection error

Error: psql: could not connect to server: Connection refused. Is the server running on host "<datamart-host>" and accepting TCP/IP connections on port 5632?

Solution:

Check the host and port numbers; the database must be running on host "datamart-host" and accept TCP/IP connections on port 5632.
Check if remote access is enabled on TeamForge; the Teamforge administrator can enable the required access.

Oracle connection error

Error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor.

This error in an Oracle datamart occurs when some connection parameters are set incorrectly.

Solution: Check and set your connection parameters appropriately.