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

Redshift error: authentication method 13 not supported when creating a user with sha256 hashed password

0

The redshift docs say when creating a new user, you can specify your password as cleartext, md5 hash, or sha256 hash with a salt. Two valid formats they give for sha256 are sha256|<cleartext password>, and sha256|<digest>|<salt>. I tried both formats when making a user and came up with the same error: error: authentication method 13 not supported.

I tried psql that came with postgres version 14, and psql that came with version 13, both reported the same error. I also tried connecting with Navicat, and it reported the same error.

Do we need to run SET password_encryption TO sha256 or something similar?

Topics
Analytics
Tags
Amazon Redshift
Language
English
asked 3 years ago2.3K views
1 Answer
1

I believe you are seeing an incompatibility with the Postgres psql support for sha256 based passwords. Can you try using the rsql command-line tool to connect?

https://docs.aws.amazon.com/redshift/latest/mgmt/rsql-query-tool.html

AWS
answered 3 years ago
AWS
EXPERT
reviewed 3 years ago
  • rePost-User-6310049
    2 years ago

    Got similar error when trying to connect from glue connection to redshift with user having sha256 password in redshift? any idea why

  • DA
    a year ago

    This answer seems woefully incomplete without a) link to github releases page where rsql can be downloaded (not just for RHEL like the link provided) - maybe also the list of supported auth methods? seems like jdbc drivers do work...

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