R Peer certificate cannot be authenticated with given CA certificates, Windows

r ssl curl ca r-googlesheets
Malan Kriel picture Malan Kriel · Nov 3, 2016 · Viewed 9.6k times · Source

When trying to import a google sheet using the gs_read() function, I get the following error message:

Error in curl::curl_fetch_memory(url, handle = handle) : Peer certificate cannot be authenticated with given CA certificates

I am following this vignette and get the error when using the code:

oceania <- gap %>%  gs_read(ws = "Oceania")

I have found similar issues for Ubuntu and php, but nothing that has been able to help me.

Does anyone know why I am getting this error and how to fix it?

I am using R 3.3.2 and Windows 7.

Answer

KERO picture KERO · Dec 2, 2016

My colleague had the same issue and I stumbled on this post on R-Bloggers by Andrew Collier. The solution below will fix your problem, but I don't know if it might cause other security issues.

library(httr)
set_config(config(ssl_verifypeer = 0L))

update: This will disable ssl verification. https://github.com/r-lib/httr/issues/262

Related questions

SSL verification causes RCurl and httr to break - on a website that should be legit

i'm trying to automate the login of the UK's data archive service. that website is obviously trustworthy. unfortunately, both RCurl and httr break at SSL verification. my web browser doesn't give any sort of warning. i can work around the …

Read More
SSL certificate failed for twitteR in R

I know similar questions have been asked again. However, I've tried everything I found here and on google and nothing seems to work for me. My code is the following: reqURL <- "http://api.twitter.com/oauth/request_token" …

Read More
Remove rows with all or some NAs (missing values) in data.frame

I'd like to remove the lines in this data frame that: a) contain NAs across all columns. Below is my example data frame. gene hsap mmul mmus rnor cfam 1 ENSG00000208234 0 NA NA NA NA 2 ENSG00000199674 0 2 2 2 2 3 ENSG00000221622 0 NA NA NA NA 4 …

Read More