trinodb / trino-python-client

Python client for Trino
Apache License 2.0
307 stars 150 forks source link

Cannot connect to Trino via OAUTH2 with SSO credentials #444

Open matialm opened 4 months ago

matialm commented 4 months ago

Discussed in https://github.com/trinodb/trino-python-client/discussions/437

Originally posted by **lejanco** January 18, 2024 I am trying to connect to trino via oauth2 using the externalauthentication instructions in the README(e.g. keyring). I have tried (what seems like) everything. You can see the commented out efforts here as well. I have done the pip install 'trino[]' ` trino_connection = trino.dbapi.connect(host=host, port=port, user=username, catalog=catalog, schema=schema, auth=trino.auth.OAuth2Authentication( # redirect_auth_url_handler=redirect_auth_url_handler ), http_scheme=http_scheme, # verify=False, # extra_credential=[('user', username), # ('password', password), # ("SSL", "true"), # ("SSLVerification", "NONE"), # ("externalAuthentication", "true") # ] )` The debug suggests the token is being retrieved but not being authenticated. Help is greatly appreciated, but please limit suggestions that require admin rights to trino as I do not have that authorization. Thanks: DEBUG:
matialm commented 4 months ago

PR created https://github.com/trinodb/trino-python-client/pull/445