Repository navigation
password authentication failed for user xxxx #237
Description
Activity
Hi @dxl568736988 , thank you for reporting this issue. Could you share the specific version of Windows you are using as well as the password hash type e.g. md5hash to assist my investigation
We have also gotten some user reports of running into this:
{'S': 'FATAL', 'C': '28000', 'M': 'password authentication failed for user "usr.dbt"', 'F': '/opt/brazil-pkg-cache/packages/RedshiftPADB/RedshiftPADB-1.0.9768.0/AL2_aarch64/generic-flavor/src/src/pg/src/backend/libpq/auth.c', 'L': '425', 'R': 'auth_failed'}Reacted by acriado-voloteaWe have also gotten some user reports of running into this:
{'S': 'FATAL', 'C': '28000', 'M': 'password authentication failed for user "usr.dbt"', 'F': '/opt/brazil-pkg-cache/packages/RedshiftPADB/RedshiftPADB-1.0.9768.0/AL2_aarch64/generic-flavor/src/src/pg/src/backend/libpq/auth.c', 'L': '425', 'R': 'auth_failed'}We are having the same issue. It's critical as it is happening suddenly for some connections, meanwhile other works fine. There are several production workloads using redshift-connector and it's urgent for us. Thanks,
Driver version
redshift-connector 2.1.3
Redshift version
PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.76230
Client Operating System
window
Python version
py 3.11
Problem description
When windos computers connected to redshift, the password error was reported, I was sure that my password was correct, and I was able to connect normally under mac, I suspected that it was special characters, but I changed the password to no special characters, only alphanumeric, and the error was still reported under windows, and the error content was:
{'S': 'FATAL', 'C': '28000', 'M': 'password authentication failed for user "ag_readonly"', 'F': '/home/ec2-user/padb/src/pg/src/backend/libpq/auth.c', 'L': '425', 'R': 'auth_failed'}