跳至內容

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?

已提問 4 年前檢視次數 2465 次

1 個回答
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

已回答 4 年前

AWS
專家

已審閱 4 年前

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

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。