Passer au contenu
En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
AWS re:Postre:Post
À propos de 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?

Sujets
Analyse
Balises
Amazon Redshift
Langue
English

demandé il y a 4 ans2,5 k vues

1 réponse
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

répondu il y a 4 ans

AWS
EXPERT

vérifié il y a 4 ans

  • rePost-User-6310049
    il y a 3 ans

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

  • DA
    il y a 2 ans

    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...

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Contenus pertinents