aws / aws/amazon-redshift-python-driver

Using IDC BrowserAuthPlugin to connect to Redshift

Open
#241 1 comment 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
2.0.0

## Redshift version
([1372],)

## Client Operating System
MacOS

## Python version
Python 3.12.4

## Table schema
not needed

## Problem description

1. Expected behaviour: Trying to connect to IDC using BrowserAuthPlugin, but running into various errors.
2. Actual behaviour: Running into various errors
3. Error message/stack trace: Error connecting to Redshift: {'S': 'FATAL', 'C': '28000', 'M': 'no PostgreSQL user name specified in startup packet', 'F': '/home/ec2-user/padb/src/pg/src/backend/postmaster/postmaster.c', 'L': '3518', 'R': 'ProcessStartupPacket'}
4. Any other details that can be helpful:

-- CODE --

conn = redshift_connector.connect(
ssl=True,
host=cluster_endpoint,
port=port,
database=database,
idc_region=idc_region,
provider_name='BrowserIdcAuthPlugin',
issuer_url=issuer_url
)

Looking for code that connects to Redshift using IDC BrowserAuthPlugin, seems like I am missing some important params

Contributor guide

Open the contributing guide

Research direction

Start with the redshift_connector.connect call and the BrowserIdcAuthPlugin parameters shown in the issue. Trace how those arguments form the startup packet and compare the required IDC authentication inputs with the reported missing PostgreSQL user error. Done means the required connection parameters are identified and a working or clearly reproducible connection example is provided.

Written by the indexing model from the issue text.

Assessment

Tech stack
aws, python
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.