My Oracle Support Banner

An Oracle Analytics Anlaysis Accessing A Redshift Database Fails With Error: No pg_hba.conf Entry (Doc ID 3000508.1)

Last updated on JANUARY 29, 2024

Applies to:

Oracle Analytics Server - Version 2022 (6.4) and later
Information in this document applies to any platform.

Symptoms

An ODBC DSN for an Amazon Redshift database was created in the <DOMAIN_HOME>/config/fmwconfig/bienv/core/odbc.ini file and the ODBC DSN was specified in the Database > Connection Pool > Data Source Name in the RPD. 

Running an analysis - that accesses the database - fails with the below error:

State: HY000. Code: 16027. [nQSError: 16027] ODBC error state: 28000 code: 3732480 message: [Oracle DataDirect][ODBC Redshift Wire Protocol driver][Redshift]FATAL: no pg_hba.conf entry for host "<host>", user "<user>", database "<database>", SSL off(File ../src/pg/src/backend/libpq/auth.c; Line 477; Routine ClientAuthentication; ). (HY000)
 State: HY000. Code: 16001. [nQSError: 16001] ODBC error state: 08S01 code: 0 message: [Oracle DataDirect][ODBC Redshift Wire Protocol driver]Socket closed.. (HY000)

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.