# Question wrt assigning data from Opal server (dsBase 6.0.1)

**URL:** <https://datashield.discourse.group/t/question-wrt-assigning-data-from-opal-server-dsbase-6-0-1/273>\
**Category:** Analyst Support\
**Created:** [9 September 2020 11:28 UTC](https://datashield.discourse.group/t/question-wrt-assigning-data-from-opal-server-dsbase-6-0-1/273 "2020-09-09T11:28:44Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Elaine.Smith](https://avatars.discourse-cdn.com/v4/letter/e/edb3f5/32.png) [@Elaine.Smith](https://datashield.discourse.group/u/Elaine.Smith)\
**Post date:** [9 September 2020 11:28 UTC](https://datashield.discourse.group/t/question-wrt-assigning-data-from-opal-server-dsbase-6-0-1/273/1 "2020-09-09T11:28:44Z")

</div>

Dear dataSHIELD team,

I have a question that I hope you can help me with.

We have just upgraded from dsBase 5.0.0 to dsBase 6.0.1 on our Opal server and I have some problems assigning data in dataSHIELD version 6.0.1.

I have looked at the training at [https://data2knowledge.atlassian.net/wiki/spaces/DSDEV/pages/1241120778/DataSHIELD+Training+Part+1+Introduction+and+logging+in](https://data2knowledge.atlassian.net/wiki/spaces/DSDEV/pages/1241120778/DataSHIELD+Training+Part+1+Introduction+and+logging+in)

And my script based on this tutorial is as follows:

## Loading libraries

library(DSI)

library(DSOpal)

library(dsBaseClient)

## Lists functionality currently available in DS.

ls(“package:DSI”)

ls(“package:DSOpal”)

ls(“package:dsBaseClient”)

## Login information

server = “dnbc”

url = “[https://opal.sund.ku.dk](https://opal.sund.ku.dk)”

user=“x”

password =“y”

table = “lc\_dnbc\_core\_2\_0.2\_0\_core\_1\_0\_non\_rep”

driver = ‘OpalDriver’

## Gathering login information

builder \<- DSI::newDSLoginBuilder()

builder$append(server, url, table, resource="", driver, user, password)

logindata \<- builder$build()

logindata

## Defining variables

nonrep.vars \<- c(

“child\_id”, “sex”, “agebirth\_m\_y”, “preg\_smk”, “parity\_m”, “height\_m”,

“prepreg\_weight”, “ga\_bj”, “ga\_us”, “cohort\_id”)

## Assigning data

connections \<- DSI::datashield.login(logins = logindata, assign = TRUE, symbol = “D”, variables=nonrep.vars)

I get the following error:

Logging into the collaborating servers

Error in curl::curl\_fetch\_memory(url, handle = handle) :

Peer certificate cannot be authenticated with known CA certificates

Do you have an idea as to why it is not working? I have permission to access the table on the Opal server.

---

<div class="post-metadata">

**Author:** ![swheater](https://yyz2.discourse-cdn.com/free1/user_avatar/datashield.discourse.group/swheater/32/182_2.png) [@swheater](https://datashield.discourse.group/u/swheater)\
**Post date:** [9 September 2020 11:50 UTC](https://datashield.discourse.group/t/question-wrt-assigning-data-from-opal-server-dsbase-6-0-1/273/2 "2020-09-09T11:50:30Z")

</div>

Hi, Please could you try adding, to the Login information::

> options=“list(ssl\_verifyhost=0,ssl\_verifypeer=0)”

This will TLS disable certificate checking, but if you want to have certificate validation you will need to install the your CA certificate.

Stuart

---

<div class="post-metadata">

**Author:** ![yannick](https://yyz2.discourse-cdn.com/free1/user_avatar/datashield.discourse.group/yannick/32/19_2.png) [@yannick](https://datashield.discourse.group/u/yannick)\
**Post date:** [9 September 2020 13:38 UTC](https://datashield.discourse.group/t/question-wrt-assigning-data-from-opal-server-dsbase-6-0-1/273/3 "2020-09-09T13:38:37Z")

</div>

Hi,

I agree with Stuart, this is an SSL error that may be due to the opal server (or any proxy that is in between) having a self-signed/invalid/not recognized certificate. SSL options mentioned by Stuart would work, but it is definitely not secure.

Regards  
Yannick

---

<div class="post-metadata">

**Author:** ![Luise](https://avatars.discourse-cdn.com/v4/letter/l/f1d935/32.png) [@Luise](https://datashield.discourse.group/u/Luise)\
**Post date:** [10 September 2020 09:55 UTC](https://datashield.discourse.group/t/question-wrt-assigning-data-from-opal-server-dsbase-6-0-1/273/4 "2020-09-10T09:55:20Z")

</div>

Thank you both for your replies! I will definitely sort out the CA certificate!