Mica/Opal connection

[Paulo Nuin]

Hi

WE are trying to setup some connection between Mica and Opal using https and we're getting this error:

"Error while importing variables for study <STUDY NAME>: Curl Error: unable to use client certificate (no key found or wrong pass phrase?)"

Any help appreciated.

Thanks

Paulo

[Etienne Morency]

Hi Paulo,

I think I can help you.

For Mica to be able to communicate with Opal, it needs to have the right permissions to access the data (See http://wiki.obiba.org/display/MICADOCDEV/Mica+Installation+Guide#MicaInstallationGuide-CreateEncryptionKeyPair). 

1. Navigate to Configuration > Mica to generate the certificate (If you have not configured a private file system, you will see an information message. Follow the link and set your private file system and come back to this page afterwards).
   
2. Copy the generated certificate key.
3. Log in to Opal. In Opal, you can manage permissions per "Unit" (See http://wiki.obiba.org/display/OPALDOC/Working+with+Units). Basically, you have to attach the certificate to a "Unit" and you give permissions to this unit to access certain tables.
4. Click on Units and click on the "Add Unit" button. Give a name to this unit e.g. Mica
5. Select the unit Mica and from the "Plus Sign" button/menu, select "Add Cryptographic Key".
6. Set the name of the certificate e.g. www.mymicawebsite.org and select the "Import a certificate (usable to identify this unit)" option and click on "Next >".
7. Paste the certificate that you copied from Mica and click on "Finish".
8. Still in Opal, click on the "Datasources" menu, select the datasource you want to connect in Mica and select the table or view that you want.
9. Select the "Permissions" tab.
10. Type in the name of the unit into the "User Name" textbox and click "Add".
11. Mica currently needs the permissions: "View dictionnary and summaries" and "Administrate".
12. You should now be able to import from Mica.

N.B. In theory, Mica does not need to have access to the values stored in Opal to work but in the current state of our work, you still have to give the "Administrate" permission... We are currently working on the next version of Opal and Mica and this issue will be fixed. It means that Mica would only need to have access to aggregated data (and the metadata about the variables) to be able to show the statistics of a variable.

I hope it helps and don't hesitate to contact us,

P.S. May I inquire about your research project and planned usage of Mica/Opal ? You can contact me or Vincent Ferretti <vincent....@oicr.on.ca> in private if you want.

- Etienne

- Etienne Morency

(514) 934-1934 #71693

[Yannick Marcon]

Hi,

The correct public Mica Doc url is:
http://wiki.obiba.org/display/MICADOC/Mica+Installation+Guide#MicaInstallationGuide-CreateEncryptionKeyPair

Yannick

[Raffaele Alfieri]

Come si fà l'import dei dati da Opal a Mica????

GRAZIE

[Raffaele Alfieri]

How i can import in Mica the Opal Datasource??? I have create a key and insert in Opal....but now???

How i can see in Mica the data that i have in Opal???

Thanks

Il giorno giovedì 15 novembre 2012 19:46:30 UTC+1, nuin ha scritto:

[Etienne Morency]

Have you look here: http://wiki.obiba.org/display/MICADOC/Mica+Installation+Guide#MicaInstallationGuide-CreateEncryptionKeyPair

To connect to an Opal server, in Opal, add a new unit and add a new "Cryptographic key". Select the option to "import a certificate..." and paste the key generated by Mica. To allow Mica to access a table or view, edit the table/views permisssions and add the unit name with the desired permissions. Then, in Mica

1. Edit the dataset that should be connected to Opal

1. Click on "Edit Studies"

1. Add at least one study

1. Click on "edit" for the connected study

1. Fill out the form as follows: 

1. Connection type : Opal

1. Opal server: https://[OPAL SERVER ADDRESS]:8443 (or other https port)

1. Datasource: Name of the datasource in Opal that contains the view/table for which to retrieve variables

1. Table: Name of the table or view

1. Click on Save

1. Now on the dataset page, click on "Import variables"

--
You received this message because you are subscribed to the Google Groups "obiba-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to obiba-users...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Raffaele Alfieri]

Hi have import this example data in Opal.
https://github.com/obiba/opal-home/blob/master/fs/home/administrator/datashield/hop.zip

But now, how i can see this data in Mica??? Which study i must edit???

Help me

Il giorno giovedì 15 novembre 2012 19:46:30 UTC+1, nuin ha scritto:

[Etienne Morency]

You should 

1. Create a new study
   
2. Create a new dataset
3. On the dataset page, click on Edit Studies and add the study
4. Click on "Edit" to specify the connection to Opal.

- Etienne