R's bigrquery的身份验证问题

Question

This post明确指出应该使用函数bq_auth()对R中的BigQuery进行身份验证。然而，我已经创建了一个BigQuery-Admin服务帐户，下载了一个服务帐户密钥，并将该密钥传递给了bq_auth()函数，但是我仍然收到以下错误：

> bigrquery::bq_auth(path = '/Users/nicholas/Downloads/just_downladed_this_key.json')
trying token_fetch()
trying credentials_service_account()
adding 'userinfo.email' scope
Error: unable to load shared object '/Library/Frameworks/R.framework/Versions/3.5/Resources/library/openssl/libs/openssl.so':
  dlopen(/Library/Frameworks/R.framework/Versions/3.5/Resources/library/openssl/libs/openssl.so, 6): Library not loaded: /usr/local/opt/openssl/lib/libssl.1.0.0.dylib
  Referenced from: /Library/Frameworks/R.framework/Versions/3.5/Resources/library/openssl/libs/openssl.so
  Reason: image not found
trying credentials_app_default()
file exists at ADC path: /Users/nicholas/.config/gcloud
Error: parse error: premature EOF

                     (right here) ------^

trying credentials_gce()
Error: argument is of length zero
trying credentials_byo_oauth()
Error: inherits(token, "Token2.0") is not TRUE
trying credentials_user_oauth2()
Gargle2.0 initialize
attempt from: bigrquery
adding 'userinfo.email' scope
loading token from the cache
Error: unable to load shared object '/Library/Frameworks/R.framework/Versions/3.5/Resources/library/openssl/libs/openssl.so':
  dlopen(/Library/Frameworks/R.framework/Versions/3.5/Resources/library/openssl/libs/openssl.so, 6): Library not loaded: /usr/local/opt/openssl/lib/libssl.1.0.0.dylib
  Referenced from: /Library/Frameworks/R.framework/Versions/3.5/Resources/library/openssl/libs/openssl.so
  Reason: image not found

看起来我手上有个openssl / libssl的问题...

Answer 1

在R中重新安装openssl库，然后重新启动R，就成功了。运行options(gargle_quiet = FALSE)来暴露错误的日志才是真正起作用的地方，因为它暴露了问题。