- Newest
- Most votes
- Most comments
It appears to be still occurring.
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.
Sorry guys but... no way to connect to Postgres 14.2 on Aurora yet?
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
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.
Hello,
I understand that you are trying to connect your PostgresSQL DB instance to a QuickSight instance but are receiving the error: "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." when validating the connection.
I believe the issue is related the PostgreSQL version that your DB instance is running. Certain versions of PostgreSQL use the authentication type 10 which causes the aforementioned error.
The issue was replicated by using version 14.2 of PostgreSQL which received the same error. I solved it by using another DB instance running version 13.4 which lead to a successful validation.
It is currently not possible to downgrade the PostgreSQL version of a DB instance. I recommend using AWS Database Migration Service to transfer your data to another DB instance.
Step-by-Step AWS DMS Walkthroughs: https://docs.aws.amazon.com/dms/latest/sbs/dms-sbs-welcome.html
Why would the suggested solution be to downgrade PosgreSQL?? That's a regression, not a solution.
Relevant content
- asked 2 years ago
- asked 6 months ago
- asked 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 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.