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

Dplyr-snowflakedb + Okta SSO #15

Open
dtran1 opened this issue Mar 27, 2019 · 2 comments
Open

Dplyr-snowflakedb + Okta SSO #15

dtran1 opened this issue Mar 27, 2019 · 2 comments

Comments

@dtran1
Copy link

dtran1 commented Mar 27, 2019

Can't seem to open the connection to the Snowflake after installing the dplyr-snowflakedb package.

Error message:
Error in .jcall(drv@jdrv, "Ljava/sql/Connection;", "connect", as.character(url)[1], :
net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver encountered communication error. Message: Exception encountered when opening connection: no protocol: /login/cert.

@zhuoyizhang
Copy link

I encountered the same issue.

Aug 08, 2019 8:17:53 PM net.snowflake.client.core.SessionUtil handleFederatedFlowError
SEVERE: IOException when authenticating with https://otkayak.okta.com/
java.net.MalformedURLException: no protocol: /login/cert

I am sure the authentication is correct because when I used wrong user name and password, the error message was different.

@anujkumar93
Copy link

anujkumar93 commented Dec 3, 2019

This may be too late, but for people coming across the same issue in the future: Make sure your Okta setup is not with MFA. If it is, you need to use externalbrowser as the authenticator instead. See note in https://docs.snowflake.net/manuals/user-guide/admin-security-fed-auth-use.html#using-sso-with-mfa

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants