Error: SSL certificate problem: self signed certificate in certificate chain

[Michaelcwl]

Hi All,

Trying to run one of the scripts and resulted in error below. Can anyone suggest a fix ?

Power BI Error:

Details: "ADO.NET: R script error. Loading required package: methods Loading required package: bitops

• Trying 78.129.173.117...
• Connected to eurapi.hornbill.com (78.129.173.117) port 443 (#0)
• successfully set certificate verify locations:
• CAfile: D:/Program Files/Microsoft/R Open/R-3.4.0/library/RCurl/etc/ca-bundle.crt CApath: none
• SSL certificate problem: self signed certificate in certificate chain
• Closing connection 0 Error in function (type, msg, asError = TRUE) : SSL certificate problem: self signed certificate in certificate chain Calls: invokeXmlmc ... getURL -> curlPerform -> .Call -> -> fun Execution halted

Regards,

Michael

[SteveGoldthorpe]

Hi Michael,

Looks like it may be your proxy getting in the way, causing Rcurl to believe that the cert presented is self-signed (which it most certainly isn't :) ).

Could you try again with a direct connection to the internet, and let me know how you get on please?

Thanks, Steve

[Michaelcwl]

Hi Steve,

The OPs guy informed me that we don't use proxy at all. I installed all the prerequisites on a dev server and connection is done directly to the Hornbill server. Are there anything extra I need to do on the certificates ?

Regards,

Michael

[Michaelcwl]

Hi SteveGoldthorpe,

I’ve bypassed the chained certificate error temporarily but getting the following error, can you help?

• upload completely sent off: 127 out of 127 bytes < HTTP/1.1 404 Not Found < Server: nginx < Date: Mon, 17 Jul 2017 09:41:48 GMT < Content-Type: text/html < Content-Length: 162 < Connection: keep-alive <
• Connection #0 to host eurapi.hornbill.com left intact

  xmltext = xmlTreeParse(reportRunResponse, asText = TRUE,useInternalNodes=T) Opening and ending tag mismatch: hr line 5 and body Opening and ending tag mismatch: body line 3 and html Premature end of data in tag html line 1 Error: 1: Opening and ending tag mismatch: hr line 5 and body 2: Opening and ending tag mismatch: body line 3 and html 3: Premature end of data in tag html line 1 runID = unlist(xpathApply(xmltext,'//methodCallResult/params/runId',xmlValue)) Error in xpathApply(xmltext, "//methodCallResult/params/runId", xmlValue) : object 'xmltext' not found

  reportSuccess = FALSE if(runID > 0){

• reportComplete = FALSE
• while(reportComplete == FALSE){

• Wait a second...

• suspendExec(1)

• Check status of report

• arrXmlmcRequest = c( "",
• "", runID, "",
• "")
• xml.request = paste(arrXmlmcRequest , collapse="")
• reportRunStatus = invokeXmlmc(xmlmcURL, apiKey, "reporting", "reportRunGetStatus", xml.request)
• xmlRunStatus = xmlTreeParse(reportRunStatus, asText = TRUE,useInternalNodes=T)
• runStatus = unlist(xpathApply(xmlRunStatus,'//methodCallResult/params/reportRun/status',xmlValue))
• if ( runStatus == "completed" ){
• reportCSVLink = unlist(xpathApply(xmlRunStatus,'//methodCallResult/params/reportRun/csvLink',xmlValue))
• reportSuccess = TRUE
• reportComplete = TRUE
• } else if ( runStatus == "failed" ){
• reportSuccess = FALSE
• reportComplete = TRUE
• }
• }
• } Error: object 'runID' not found

  if(reportSuccess == TRUE) {

• Now go get CSV

• Build Invoke URL

• invokeURL = paste(xmlmcURL, "/dav/reports/", reportID, "/", reportCSVLink, sep="")

• Build Headers

• espKeyAuth = paste('ESP-APIKEY ', apiKey, sep="")
• requestHeaders = c('Content-Type'='text/xmlmc',
• 'Authorization'=espKeyAuth)

• GET request for report CSV content

• reportContent = getURL( url = invokeURL, httpheader=requestHeaders ,ssl.verifypeer = FALSE)

• CSV vector in to data frame object

• dataframe <- read.csv(textConnection(reportContent))
• }

Regards,

Michael