KNOWLEDGE BASE

Error "An error occurred while setting up the SSL connection" When Connecting to PostgreSQL


Published: 18 Dec 2023
Last Modified Date: 18 Dec 2023

Issue

When attempting to connect to a PostgreSQL database (such as a Tableau Server repository) behind an Application Load Balancer (ALB), the following error occurs:

The connection to the data source might have been lost.
Error Code: 02D8AB5A
An error occurred while setting up the SSL connection.

OR

Error Code: BC42EF73
expected authentication request from server, but received H

Environment

  • Tableau Desktop
  • Tableau Server
  • PostgreSQL
  • Application Load Balancer (ALB)

Resolution

As a possible workaround, try using the name of the computer hosting the PostgreSQL database instead of the alias for the load balancer.

Cause

An ALB is a Layer 7 load balancer type, and that means that it only supports HTTP, HTTPS and gRPC protocols; Therefore, it does not support connections with a PostgreSQL server.
 
Did this article resolve the issue?