Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

QuickSight Unable to Connect to RDS(postgres)

0

I have QuickSight and an RDS(postgres) instance, both in the same region (US-West-2). I also have a valid VPC Connection (checked in the "Reachability Analyzer") between my QuickSight ENI and the RDS ENI.

My Goal is to connect QuickSight to the RDS DB, so I can use the DB as a QuickSight Data Source.

However, when I go to create a dataset in QuickSight, I am unable to validate the connection. The error I get back is a Postgres authentication error (copied below).

I've verified that:

  • The VPC Connection is valid
  • The DB username/password is correct
  • Security Groups are configured as specified in AWS Documentation (gone over these multiple times)
  • I can interact with the DB otherwise (via application)

Error message after failed connection validation:

The authentication type 10 is not supported. Check that you have configured the pg_hba.conf file to include the client's IP address or subnet, and that it is using an authentication scheme supported by the driver.
  • George
    3 years ago

    Hi, what is the status of this issue? We are also getting the same error trying to connect from QuickSight to an RDS PostgreSQL 14.x database. It appears to be still occurring.

Topics
AnalyticsNetworking & Content DeliveryDatabase
Tags
Amazon VPCAmazon Quick SightPostgreSQL
Language
English

asked 4 years ago3.6K views

4 Answers
0

It appears to be still occurring.

answered 3 years ago

  • Elliott
    3 years ago

    Hey George,

    I have found a workaround for this yesterday.

    I suggest creating an RDS proxy for your database and setting the encryption method to MD5 within the proxy. This seems to work with the JDBC used by quicksight. You can then use the RDS proxy endpoint in your dataset connection for Quicksight. Please do not forget to set up the correct security group so that Quicksight can access your proxy (This link may be handy when setting up your security groups - https://docs.aws.amazon.com/quicksight/latest/user/regions.html).

    Hope that helps.

0

Sorry guys but... no way to connect to Postgres 14.2 on Aurora yet?

answered 4 years ago

0

Hi,

You can try to update the cluster parameter group for parameter "Password encryption" to "md5". Create new dba user for your scenario and try connecting using that user on quicksight.

Thanks, Shashi

AWS

answered 3 years ago

0

I was able to find a workaround in the QuickSight Community without downgrading. It was simple fix by creating a new user with MD5 based password. I am running Postgresql 15 on Aurora Serverless V2.

Steps for new user: set password_encryption = 'md5'; create user (quicksight_user) with password (PASSWORD_HERE); grant connect on (database) to (quicksight_user);

If you already have a user created for QuickSight then simply Alter the user after setting MD5 Steps for Existing user: set password_encryption = 'md5'; ALTER USER quicksight_user WITH PASSWORD '79kjrkay73334gF';

Once QuickSight supports the new password encryption then this will not be necessary.

Source: https://community.amazonquicksight.com/t/my-quicksight-cannot-connect-to-rds-postgresql-db-via-vpc/4696/4

answered 3 years ago

EXPERT

reviewed 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content