aws / aws/amazon-redshift-python-driver
password authentication failed for user xxxx
- Dominant language
- Python
- Stars
- 220
- Forks
- 86
- PR merge metrics
- No merged PRs in 30d
Description
## 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'}
Contributor guide
Research direction
The report names no repository files, tests, or entry points; it identifies redshift-connector 2.1.3, Windows with Python 3.11, and a password authentication error. Start by reproducing the same connection on Windows and macOS and comparing diagnostics; done means identifying a reproducible cause or documenting the information needed to fix it.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python
- Domain
- authentication, database
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100