Salta al contenuto

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?

posta 4 anni fa2,5K visualizzazioni

1 Risposta
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

con risposta 4 anni fa

AWS
ESPERTO

verificato 4 anni fa

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

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

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.