PostgreSQL ODBC connection fails due to SSL off

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

After upgrading to Datamaker 4.11.19.0 the PostgreSQL ODBC connection fails with the following error:

"Cannot connect using supplied values.
Connection: Data Source
Profile: <Profile_name>
odbc: <ODBC_Connection>
SQLSTATE = 08001
FATAL: no pg_hba.conf entry for host "10.247.x.x", user "<username>", database "<database name>", SSL off"

Environment

TDM 4.11

Cause

This is being thrown by the PostgreSQL database. The error is stating that the PostgreSQL database doesn't contain an entry for the host, user, or database in the pg_hba.conf file. Your PostgreSQL DBA should be able to help you resolve this issue.

In short, the PostgreSQL pg_hba.conf configuration file needs to be modified to allow the host, and user to connect to the database. The pg_hba.conf file is located in the PostgreSQL installation directory\data sub-directory.

The type of connection needed, will depend on what section of the file needs to be modified. If you're using an IPv4 connection, the IPv4 local connections section will need to be updated to allow this host, and user access to the database. If you are using an IPv6 connection, then the IPv6 local connection should be updated.

For more information, see the PostgreSQL documentation that covers configuring the pg_hba.conf file.

Resolution

Consulting with the DBA, who suggested changing the authentication method from SSL off to SSL on for the connection profile. Looking at the ODBC connection details, there was a dropdown which had SSL Mode as 'disable'. Changing that to 'allow' and updated the connection details resolved the issue.