aws / amazon-redshift-python-driver

Redshift Python Connector. It supports Python Database API Specification v2.0.
Apache License 2.0
204 stars 76 forks source link

Using IDC BrowserAuthPlugin to connect to Redshift #241

Open bpatchin1 opened 3 weeks ago

bpatchin1 commented 3 weeks ago

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