Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SNOW-1446031: OAuth authentification failed #1141

Closed
SteveGad12345 opened this issue May 24, 2024 · 2 comments
Closed

SNOW-1446031: OAuth authentification failed #1141

SteveGad12345 opened this issue May 24, 2024 · 2 comments
Assignees
Labels
status-triage_done Initial triage done, will be further handled by the driver team

Comments

@SteveGad12345
Copy link

Hi,

I'm using terraform provider snowflake version 0.91 which uses GOSnowflake version 1.10.
I got an Authentication FAILED from gosnowflake. I activated the DEBUG and got the url used as shown below.
https://[ACCOUNT].snowflakecomputing.com:443/session/v1/login-request?requestId=...
When I try this url in my browser, I got an HTTP Status Code 405 with a kind of default error web page. If I only replace the version for v2, I got a HTTP 405, but with a page which displays "Error Method Not Allowed" and with Snowflake logo which is better.

I think that the version could be configurable (it is a const now) or forced to v2.

Additional version:

  • Running on Windows Server x64
@SteveGad12345 SteveGad12345 added the bug Erroneous or unexpected behaviour label May 24, 2024
@github-actions github-actions bot changed the title OAuth authentification failed SNOW-1446031: OAuth authentification failed May 24, 2024
@sfc-gh-dszmolka sfc-gh-dszmolka removed the bug Erroneous or unexpected behaviour label May 24, 2024
@sfc-gh-dszmolka sfc-gh-dszmolka self-assigned this May 24, 2024
@sfc-gh-dszmolka sfc-gh-dszmolka added the status-triage Issue is under initial triage label May 24, 2024
@sfc-gh-dszmolka
Copy link
Contributor

sfc-gh-dszmolka commented May 24, 2024

hello and thank you for raising this issue. Can you please attach the DEBUG logs made with
TF_LOG_PROVIDER=1 andSF_TF_GOSNOWFLAKE_LOG_LEVEL=DEBUG envvars set , then running the terraform action which fails for you ?
you will need to sanitize the logs from sensitive information; or alternatively you can raise a ticket to Snowflake Support and work 1:1 with a Support engineer if you prefer that.

Asking because the endpoint what you're seeing is normal, and it is also normal that method GET is not allowed (which your browser defaults to) for a login-request endpoint which expects POSTs with login information.

so for now, this is not a bug with the driver or the TF provider, but a simple login issue (perhaps due to misconfiguration) and we would like to troubleshoot it to see if it's otherwise. Thank you in advance!

@sfc-gh-dszmolka sfc-gh-dszmolka added the status-information_needed Additional information is required from the reporter label May 24, 2024
@SteveGad12345
Copy link
Author

Sorry, I found my error.

@sfc-gh-dszmolka sfc-gh-dszmolka added status-triage_done Initial triage done, will be further handled by the driver team and removed status-information_needed Additional information is required from the reporter status-triage Issue is under initial triage labels May 26, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
status-triage_done Initial triage done, will be further handled by the driver team
Projects
None yet
Development

No branches or pull requests

2 participants