search

snowflakedb / dplyr-snowflakedb

SnowflakeDB backend for dplyr
Apache License 2.0
65 stars 25 forks source link

Dplyr-snowflakedb + Okta SSO #15

Open dtran1 opened 5 years ago

dtran1 commented 5 years ago

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 commented 5 years ago

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 commented 4 years ago

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