aws / aws/amazon-redshift-python-driver

password authentication failed for user xxxx

Open
#237 3 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.