error_ssl-certificate-problem_unable-to-get-local-issuer-certificate.md

Here: https://bit.ly/3KuXgpE

--

On my local machine

url <- "https://esastar-emr.sso.esa.int/PublicEntityDir/PublicEntityDirGridSme?term=&isForRegister=False&isForEmits=True&grid-page=3"
jsonlite::fromJSON(url)
#> Error in open.connection(con, "rb"): SSL certificate problem: unable to get local issuer certificate

On Docker

url <- "https://esastar-emr.sso.esa.int/PublicEntityDir/PublicEntityDirGridSme?term=&isForRegister=False&isForEmits=True&grid-page=3"
jsonlite::fromJSON(url)
#> Error in open.connection(con, "rb"): SSL certificate problem: unable to get local issuer certificate

On rstudio.cloud

url <- "https://esastar-emr.sso.esa.int/PublicEntityDir/PublicEntityDirGridSme?term=&isForRegister=False&isForEmits=True&grid-page=3"
jsonlite::fromJSON(url)
#> Error in open.connection(con, "rb"): server certificate verification failed. CAfile: none CRLfile: none

I tried this workaround but it made no difference to me:

git config --global http.sslVerify false

Solution

Thanks CJ

url <- "http://esastar-emr.sso.esa.int/PublicEntityDir/PublicEntityDirGridSme?term=&isForRegister=False&isForEmits=True&grid-page=3"

tmp <- tempfile()
h <- curl::new_handle(ssl_verifypeer= 0)
curl::curl_download(url, destfile = tmp, handle = h)

jsonlite::fromJSON(tmp)
#> $html
#> [1] "\r\n\r\n    <div class=\"grid-mvc\" data-lang=\"en\" data-gridname=\"\" data-selectable=\"true\" data-multiplefilters =\"false\">\r\n        <div class=\"grid-wrap\">\r\n            <table class=\"table table-striped grid-table\">\r\n                \r\n                <thead>\r\n                        <tr>\r\n<th class=\"grid-header\"><div class=\"grid-filter\" data-filterdata=\"[]\" data-name=\"Name\" data-type=\"System.String\" data-url=\"?term=&amp;isForRegister=False&amp;isForEmits=True\" data-widgetdata=\"null\"><span class=\"grid-filter-btn\" title=\"Filter this column\"></span></div><div class=\"grid-header-title\"><a href=\"?term=&amp;isForRegister=False&amp;isForEmits=True&amp;grid-column=Name&amp;grid-dir=0\">Name</a></div></th><th class=\"grid-header\"><div class=\"grid-filter\" data-filterdata=\"[]\" data-name=\"NationalityDesc\" data-type=\"System.String\" data-url=\"?term=&amp;isForRegister=False&amp;isForEmits=True\" data-widgetdata=\"null\"><span class=\"grid-filter-btn\" title=\"Filter this column\"></span></div><div class=\"grid-header-title\"><a href=\"?term=&amp;isForRegister=False&amp;isForEmits=True&amp;grid-column=NationalityDesc&amp;grid-dir=0\">Country of Registration</a></div></th><th class=\"grid-header\"><div class=\"grid-filter\" data-filterdata=\"[]\" data-name=\"EntityTypeDesc\" data-type=\"System.String\" data-url=\"?term=&amp;isForRegister=False&amp;isForEmits=True\" data-widgetdata=\"null\"><span class=\"grid-filter-btn\" title=\"Filter this column\"></span></div><div class=\"grid-header-title\"><a href=\"?term=&amp;isForRegister=False&amp;isForEmits=True&amp;grid-column=EntityTypeDesc&amp;grid-dir=0\">Entity Type</a></div></th><th class=\"grid-header\"><div class=\"grid-filter\" data-filterdata=\"[]\" data-name=\"EntitySizeDesc\" data-type=\"System.String\" data-url=\"?term=&amp;isForRegister=False&amp;isForEmits=True\" data-widgetdata=\"null\"><span class=\"grid-filter-btn\" title=\"Filter this column\"></span></div><div class=\"grid-header-title\"><a href=\"?term=&amp;isForRegister=False&amp;isForEmits=True&amp;grid-column=EntitySizeDesc&amp;grid-dir=0\">Entity Size</a></div></th><th class=\"grid-header\"><div class=\"grid-filter\" data-filterdata=\"[]\" data-name=\"EntitySMEStatus\" data-type=\"System.String\" data-url=\"?term=&amp;isForRegister=False&amp;isForEmits=True\" data-widgetdata=\"null\"><span class=\"grid-filter-btn\" title=\"Filter this column\"></span></div><div class=\"grid-header-title\"><a href=\"?term=&amp;isForRegister=False&amp;isForEmits=True&amp;grid-column=EntitySMEStatus&amp;grid-dir=0\">SME Status</a></div></th><th class=\"grid-header\"><div class=\"grid-header-title\"><a href=\"?term=&amp;isForRegister=False&amp;isForEmits=True&amp;grid-column=EntityId&amp;grid-dir=0\">Details</a></div></th>    </tr>\r\n\r\n                </thead>\r\n                <tbody>\r\n                        <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">AALTA LAB D.O.O.</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">SI-Slovenia</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/58027\" title=\"View details\"> </a></td>    </tr>\r\n    <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">AATC  Analog Astronaut Training Center</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">PL-Poland</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/97207\" title=\"View details\"> </a></td>    </tr>\r\n    <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">AB5 CONSULTING</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">GB-United Kingdom</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/58835\" title=\"View details\"> </a></td>    </tr>\r\n    <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">Abaco Digital s.l.</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">ES-Spain</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/97153\" title=\"View details\"> </a></td>    </tr>\r\n    <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">ABACONS SRL</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">IT-Italy</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/83782\" title=\"View details\"> </a></td>    </tr>\r\n    <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">Abaqo Ingenieria Iberia</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">ES-Spain</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/83249\" title=\"View details\"> </a></td>    </tr>\r\n    <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">AB-ARCHIVIBIBLIOTECHE SRL</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">IT-Italy</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/86608\" title=\"View details\"> </a></td>    </tr>\r\n    <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">abaut GmbH</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">DE-Germany</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/72724\" title=\"View details\"> </a></td>    </tr>\r\n    <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">ABELIUM D.O.O.</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">SI-Slovenia</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/59501\" title=\"View details\"> </a></td>    </tr>\r\n    <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">Abiogenesis Computer Systems Lab AB</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">SE-Sweden</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/69364\" title=\"View details\"> </a></td>    </tr>\r\n    <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">ABmerit</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">SK-Slovakia</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/69956\" title=\"View details\"> </a></td>    </tr>\r\n    <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">ABOA SPACE RESEARCH OY - ASRO</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">FI-Finland</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/61897\" title=\"View details\"> </a></td>    </tr>\r\n    <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">AboveRF BV</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">BE-Belgium</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/128887\" title=\"View details\"> </a></td>    </tr>\r\n    <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">ABSOLUT-SYSTEM</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">FR-France</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/51969\" title=\"View details\"> </a></td>    </tr>\r\n    <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">ABSPACECONSULTING</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">FR-France</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/128794\" title=\"View details\"> </a></td>    </tr>\r\n    <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">AC Satcom</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">DK-Denmark</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/71811\" title=\"View details\"> </a></td>    </tr>\r\n    <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">Access Earth LTD</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">IE-Ireland</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/71409\" title=\"View details\"> </a></td>    </tr>\r\n    <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">ACM Coatings GmbH (subsidiary of Acktar Ltd.)</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">DE-Germany</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/66568\" title=\"View details\"> </a></td>    </tr>\r\n    <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">ACM Energy Limited</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">IE-Ireland</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/86755\" title=\"View details\"> </a></td>    </tr>\r\n    <tr class=\"grid-row \">\r\n<td class=\"grid-cell\" data-name=\"Name\">ACORDE TECHNOLOGIES SA</td><td class=\"grid-cell\" data-name=\"NationalityDesc\">ES-Spain</td><td class=\"grid-cell\" data-name=\"EntityTypeDesc\">Company</td><td class=\"grid-cell\" data-name=\"EntitySizeDesc\">TBD</td><td class=\"grid-cell\" data-name=\"EntitySMEStatus\">Yes</td><td class=\"grid-cell\" data-name=\"EntityId\"><a class=\"gridDetails\" href=\"/PublicEntityDir/PublicEntityDirPopupDetailSME/51949\" title=\"View details\"> </a></td>    </tr>\r\n\r\n                </tbody>\r\n            </table>\r\n                <div class=\"grid-footer\">\r\n        <div class=\"grid-pager\">\r\n    <ul class=\"pagination\">\r\n            <li>\r\n                <a href=\"?term=&amp;isForRegister=False&amp;isForEmits=True&amp;grid-page=2\">«</a>\r\n            </li>\r\n\r\n                    <li><a href=\"?term=&amp;isForRegister=False&amp;isForEmits=True&amp;grid-page=1\">1</a></li>\r\n            <li><a href=\"?term=&amp;isForRegister=False&amp;isForEmits=True&amp;grid-page=2\">2</a></li>\r\n            <li class=\"active\"><span>3</span></li>\r\n            <li><a href=\"?term=&amp;isForRegister=False&amp;isForEmits=True&amp;grid-page=4\">4</a></li>\r\n            <li><a href=\"?term=&amp;isForRegister=False&amp;isForEmits=True&amp;grid-page=5\">5</a></li>\r\n                    <li><a href=\"?term=&amp;isForRegister=False&amp;isForEmits=True&amp;grid-page=6\">...</a></li>\r\n            <li><a href=\"?term=&amp;isForRegister=False&amp;isForEmits=True&amp;grid-page=146\">146</a></li>\r\n                    <li><a href=\"?term=&amp;isForRegister=False&amp;isForEmits=True&amp;grid-page=4\">»</a></li>\r\n    </ul>\r\n</div>\r\n\r\n    </div>\r\n\r\n        </div>\r\n    </div>\r\n\r\n\r\n<script>\r\n    $(function () {\r\n        //details button: shows details popup\r\n        $(\".gridDetails\").click(function (event) {\r\n            event.preventDefault();\r\n            event.stopPropagation();\r\n\r\n            OpenPopupDialog(event.target, 'Entity Details', false, null);\r\n\r\n        });\r\n    });\r\n</script>"
#> 
#> $Success
#> [1] TRUE

^{Created on 2022-01-20 by the reprex package (v2.0.1)}