Only this pageAll pages
Powered by GitBook
1 of 23

v0.3.1

Loading...

Loading...

For System Administrators

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

For Developers

Loading...

Loading...

Loading...

Loading...

Deployment

These pages explain how to deploy MedCo in different scenarios.

Each deployment scenario corresponds to a deployment profile, as described below. All these instructions use the deployment scripts from the medco-deployment repository.

If you are new to MedCo…

… and want to try to deploy the system on a single machine to test it, you should should follow the Local Test Deployment guide.

… and want to create or join a MedCo network for test purposes, you should follow the Network Test Deployment guide.

… and want to create or join a MedCo network in production, you should follow the Network Production Deployment guide.

… and want to develop around MedCo, you should follow the Local Development Deployment guide.

Deployment Profiles

A deployment profile is composed of two things:

  • a compose profile in medco-deployment/compose-profiles/<profile name>/: docker-compose file and parameters like ports to expose, log level, etc.

  • a configuration profile in medco-deployment/configuration-profiles/<profile name>/: files mounted in the docker containers, containing the cryptographic keys, the certificates, etc.

Some profiles are provided by default, for development or testing purposes. Those should not be used in a production scenario with real data, as the private keys are set by default, thus not private. Other types of profiles must generated using the scripts in medco-deployment/resources/profile-generation-scripts/<profile name>/.

The different profiles are the following:

test-local-3nodes ()

  • for test on a single machine (used by the MedCo live demo)

  • 3 nodes on any host

  • using the latest release of the source codes

  • no debug logging

test-network ()

  • for test on several different hosts

  • a single node on a host part of a MedCo network

  • using the latest release of the source codes

  • no debug logging

prod-network ()

  • for a deployment in production

  • a single node on a host part of a MedCo network

  • using the latest release of the source codes

  • no debug logging

dev-local-3nodes ()

  • for software development

  • 3 nodes on the local host

  • using development version of source codes

  • debug logging enabled

The database is pre-loaded with some encrypted test data using a key that is pre-generated from the combination of all the participating nodes’ public keys. For the test-network and prod-network deployment profiles this data will not be correctly encrypted, since the public key of each node is generated independently, and, as such, the data must be re-loaded.

profile pre-generated

profile must be generated prior to use with the provided scripts

profile must be generated prior to use with the provided scripts

profile pre-generated

Local Test Deployment
Network Test Deployment
Network Production Deployment
Local Development Deployment

Requirements

We recommend the following specifications for running MedCo:

  • Network Bandwidth: >100 Mbps (ideal), >10 Mbps (minimum), symmetrical

  • Ports Opening and IP Restrictions: see Network Architecture

  • Hardware

    • CPU: 8 cores (ideal), 4 cores (minimum)

    • RAM: >16 GB (ideal), >8GB (minimum)

    • Storage: dependent on data loaded, >100GB

  • Software

    • OS: Any flavor of Linux, physical or virtualized (tested with Ubuntu 16.04, 18.04, Fedora 29)

    • OpenSSL

    • version >= 18.09.1

Docker-Compose version >= 1.23.2

Docker

Home

Resources

  • MedCo software repositories

    • (forked from )

  • Other resources

  • Deprecated repositories

    • (forked from )

Contact

For assistance with deploying MedCo or any other technical questions, send an email at or any of the contributors.

  • (Privacy and Security Software Engineer, EPFL) -

  • (Privacy and Security Software Engineer, EPFL) -

  • (Privacy and Security Software Engineer, EPFL) -

License

MedCo is licensed under a End User Software License Agreement (‘EULA’) for non-commercial use. If you need more information, please contact us.

Jean Louis Raisaro (Data Protection Specialist, CHUV) - jean.raisaro@chuv.ch
  • Juan Troncoso-Pastoriza (Post-Doctoral Researcher, EPFL) - juan.troncoso-pastoriza@epfl.ch

  • Jean-Pierre Hubaux (Professor, EPFL) - jean-pierre.hubaux@epfl.ch

  • MedCo Connector
    Unlynx Wrapper
    Data Loader
    Glowing Bear MedCo
    The Hyve
    Deployment
    Documentation
    Docker Hub organization
    NPM.js organization
    IRCT
    HMS-DBMI
    I2B2 Cell
    Unlynx Javascript Crypto Library
    medco@epfl.ch
    Mickaël Misbach
    mickael.misbach@epfl.ch
    Francesco Marino
    francesco.marino@epfl.ch
    Joao Andre Sa
    joao.gomesdesaesousa@epfl.ch

    Network Production Deployment

    Deployment of profile prod-network.

    Coming in MedCo v1.0.0.

    Network Test Deployment

    Deployment of profile test-network.

    This deployment profile comes with default pre-generated keys and default passwords. It is not meant to contain any real data nor be used in production. If you wish to do so, use instead the Network Production Deployment (prod-network) deployment profile.

    This test profile deploys an arbitrary set of MedCo nodes independently in different machines that together form a MedCo network. This deployment assumes each node is deployed in a single dedicated machine. All the machines have to be reachable between each other. Nodes should agree on a network name and individual indexes beforehand (to be assigned a unique ID).

    The next set of steps must be fully executed individually by each node of the network.

    Pre-requisites

    First step is to get the MedCo Deployment latest release at each node. Adapt ${MEDCO_SETUP_DIR} to where you wish to install MedCo.

    Generation of the deployment Profile

    Next the compose and configuration profiles must be generated using a script, executed in two steps.

    • Step 1: each node generates its keys and certificates, and shares its public information with the other nodes

    • Step 2: each node collects the public keys and certificates of the all the other nodes

    Step 1

    For step 1, the network name ${MEDCO_SETUP_NETWORK_NAME} should be common to all the nodes. ${MEDCO_SETUP_NODE_DNS_NAME} corresponds to the machine domain name where the node is being deployed. As mentioned before the different parties should have agreed beforehand on the members of the network, and assigned an index ${MEDCO_SETUP_NODE_IDX} to each different node to construct its UID (starting from 0, to n-1, n being the total number of nodes).

    This script will generate the compose profile and part of the configuration profile, including a file srv${MEDCO_SETUP_NODE_IDX}-public.tar.gz. This file should be shared with the other nodes, and all of them need to place it in their configuration profile folder (${MEDCO_SETUP_DIR}/configuration-profiles/test-network-${MEDCO_SETUP_NETWORK_NAME}-node${MEDCO_SETUP_NODE_IDX}).

    Step 2

    Before proceeding to this step, you need to have gathered all the files srv${MEDCO_SETUP_NODE_IDX}-public.tar.gz from the persons deploying MedCo on the other nodes.

    Once all nodes have shared their srv${MEDCO_SETUP_NODE_IDX}-public.tar.gz file with all other nodes, step 2 can be executed:

    At this point, it is possible to edit the default configuration generated in ${MEDCO_SETUP_DIR}/configuration-profiles/test-network-${MEDCO_SETUP_NETWORK_NAME}-node${MEDCO_SETUP_NODE_IDX}/.env This is needed if you want to modify the default passwords. When editing this file, be careful to change only the passwords and not the other values. Note that setting the passwords that way works only on the first deployment. If the passwords need to be updated later, you should use the specific component way of modifying password.

    The deployment profile is now ready to be used.

    MedCo Stack Deployment

    Next step is to download the docker images and run the node:

    Wait some time for the initialization of the containers to be done, this can take up to 10 minutes. For the subsequent runs, the startup will be faster. You can use docker-compose stop to stop the containers and docker-compose down to delete them.

    Keycloak Configuration

    You will need to follow two sets of instruction to make Keycloak functional and be able to log in. and then:

    Test the deployment

    Note that by default the certificates generated by the script are self-signed and thus, when using Glowing Bear, the browser will issue a security warning. To use your own valid certificates, see .

    The database is pre-loaded with some encrypted test data using a key that is pre-generated from the combination of all the participating nodes’ public keys. For the test-network deployment profile this data will not be correctly encrypted, since the public key of each node is generated independently, and, as such, the data must be re-loaded before being able to test the system successfully.

    Run first the MedCo loader (see ) to load some data and be able to test this deployment. Then access Glowing Bear in your web browser at https://${MEDCO_SETUP_NODE_DNS_NAME} and use the default credentials specified in . If you are new to Glowing Bear you can watch the video. You can also use the to perform tests.

    Access the Keycloak administration interface
    Update the MedCo OIDC client
    Update the Keycloak realm keys
    HTTPS Configuration
    Loading Data
    Keycloak user management
    Glowing Bear user interface walkthrough
    CLI client
    export MEDCO_SETUP_DIR=~/medco-deployment MEDCO_SETUP_VER=0.3.1
    wget https://github.com/ldsec/medco-deployment/archive/v${MEDCO_SETUP_VER}.tar.gz
    tar xvzf v${MEDCO_SETUP_VER}.tar.gz
    mv medco-deployment-${MEDCO_SETUP_VER} "${MEDCO_SETUP_DIR}"
    export MEDCO_SETUP_NETWORK_NAME=example \
        MEDCO_SETUP_NODE_IDX=0 \
        MEDCO_SETUP_NODE_DNS_NAME=medconode0.example.com
    cd "${MEDCO_SETUP_DIR}/resources/profile-generation-scripts/test-network"
    bash step1.sh ${MEDCO_SETUP_NETWORK_NAME} ${MEDCO_SETUP_NODE_IDX} ${MEDCO_SETUP_NODE_DNS_NAME}
    cd "${MEDCO_SETUP_DIR}/resources/profile-generation-scripts/test-network"
    bash step2.sh ${MEDCO_SETUP_NETWORK_NAME} ${MEDCO_SETUP_NODE_IDX}
    cd "${MEDCO_SETUP_DIR}/compose-profiles/test-network-${MEDCO_SETUP_NETWORK_NAME}-node${MEDCO_SETUP_NODE_IDX}"
    docker-compose -f docker-compose.yml -f docker-compose.tools.yml pull
    docker-compose up -d

    Releases

    v0.3.1 - 6th March 2020

    • Several bug fixes and enhancements

    v0.3.0 - 11th February 2020

    • Many corrections to comply with security reviews

    • Architecture changes: removal of PICSURE, new implementation of genomic annotations querying

    • Keycloak auto-provisioning

    • Support of several identity providers per MedCo node

    v0.2.1 - 15th August 2019

    • Implementation of additional query types (patient list, locally obfuscated count, global count, shuffled count)

    • Implementation of OIDC-based authorization model

    • Implementation of CLI client

    • Timers improvements

    v0.2.0 - 3rd May 2019

    • Architecture revisit

    • Replaced medco-i2b2-cell by medco-connector

    • Upgrades (IRCT v1.4 to PICSURE v2.0, Onet suite v3, Keycloak, Nginx, PHP)

    • Consolidation of deployment

    v0.1.1 - 23rd January 2019

    • Deployment for test purposes on several machines

    • Enhancements of documentation and deployment infrastructure

    • Nginx reverse proxy with HTTPS support

    • Keycloak update

    v0.1.0 - 1st December 2018

    First public release of MedCo, running with i2b2 v1.7, PIC-SURE/IRCT v1.4 and centralized OpenID Connect authentication. Deployment for development and test purpose on a single machine.

    Rework of Glowing Bear MedCo

  • Various smaller improvements, bug fixes and better stability

  • Upgrade of dependencies

  • Various smaller improvements and bug fixes

  • Many smaller fixes and enhancements

    Local Test Deployment

    Deployment of profile test-local-3nodes.

    This deployment profile comes with default pre-generated keys and default passwords. It is not meant to contain any real data nor be used in production. If you wish to do so, use instead the Network Production Deployment (prod-network) deployment profile.

    This test profile deploys 3 MedCo nodes on a single machine for test purposes. It can be used either on your local machine, or any other machine to which you have access. The version of the docker images used are the latest released versions. This profile is for example used for the MedCo public demo.

    MedCo Stack Deployment

    First step is to get the MedCo Deployment latest release and download the docker images. Adapt ${MEDCO_SETUP_DIR} to where you wish to install MedCo.

    The default configuration of the deployment is suitable if the stack is deployed on your local host, and if you do not need to modify the default passwords. If so, edit the file ${MEDCO_SETUP_DIR}/compose-profiles/test-local-3nodes/.env to reflect your configuration. For example:

    MEDCO_NODE_HOST should be the fully qualified domain name of the host, MEDCO_NODE_HTTP_SCHEME should be http or https. The other fields control the default passwords for the various services running. Note that setting the passwords that way works only on the first deployment. If the passwords need to be updated later, you should use the specific component way of modifying password.

    If you enable HTTPS, follow to set up the needed certificates.

    Final step is to run the nodes, all three will run simultaneously:

    Wait some time for the initialization of the containers to be done (up to the message: “i2b2-medco-srv… - Started x of y services (z services are lazy, passive or on-demand)”), this can take up to 10 minutes. For the subsequent runs, the startup will be faster. In order to stop the containers, hit Ctrl+C in the active window.

    You can use the command docker-compose up -d instead to run MedCo in the background and thus not keeping the console captive. In that case use docker-compose stop to stop the containers.

    Keycloak Configuration

    Only needed if you are deploying somewhere else than your local host. Otherwise the default configuration will work fine.

    Follow the instructions for to be able to login in Glowing Bear.

    Test the deployment

    In order to test that the local test deployment of MedCo is working, access Glowing Bear in your web browser at http(s)://${MEDCO_NODE_HOST} and use the default credentials specified in . If you are new to Glowing Bear you can watch the video. You can also use the to perform tests.

    By default MedCo loads a specific test data, refer to for expected results to queries. To load a dataset, follow the guide .

    HTTPS Configuration
    configuring the MedCo OpenID Connect client in Keycloak
    Keycloak user management
    Glowing Bear user interface walkthrough
    CLI client
    Description of the default test data
    Loading Data
    export MEDCO_SETUP_DIR=~/medco-deployment MEDCO_SETUP_VER=0.3.1
    wget https://github.com/ldsec/medco-deployment/archive/v${MEDCO_SETUP_VER}.tar.gz
    tar xvzf v${MEDCO_SETUP_VER}.tar.gz
    mv medco-deployment-${MEDCO_SETUP_VER} "${MEDCO_SETUP_DIR}"
    cd "${MEDCO_SETUP_DIR}/compose-profiles/test-local-3nodes"
    docker-compose -f docker-compose.yml -f docker-compose.tools.yml pull
    MEDCO_NODE_HOST=medco-demo.epfl.ch
    MEDCO_NODE_HTTP_SCHEME=https
    POSTGRES_PASSWORD=postgres_password
    PGADMIN_PASSWORD=pgadmin_password
    KEYCLOAK_PASSWORD=keycloak_password
    I2B2_WILDFLY_PASSWORD=i2b2_wildfly_password
    I2B2_SERVICE_PASSWORD=i2b2_service_password
    I2B2_USER_PASSWORD=i2b2_user_password
    cd "${MEDCO_SETUP_DIR}/compose-profiles/test-local-3nodes"
    docker-compose up

    Configuring SwitchAAI Authentication

    This guide walks you through the process of configuring Keycloak as a Service Provider to one or more SwitchAAI identity provider(s), in order for MedCo to rely on SwitchAAI for user authentication.

    Prerequisites

    • A MedCo network is up and running, with one or more functional Keycloak within the network.

    • One or several identity provider(s) part of the SwitchAAI federation is/are chosen to be used as user source.

    • The institution at which the Keycloak of MedCo is deployed is ready to accept being registered as the home organization.

    • You have access to the .

    Right now the SwitchAAI WAYF (Where Are You From) mechanism is not supported (i.e. the web UI used to select with institution the user wishes to login). This means that you will need to register in Keycloak each identity provider you wish to support.

    The process described in this guide will need to be repeated for each instance of Keycloak deployed, if there are more than one in the MedCo network.

    Configure the identity provider(s) in Keycloak

    The following instructions are to be executed on the administration UI of Keycloak, e.g. https://medco-demo.epfl.ch/auth/admin.

    Configure the first login flow

    The behavior of Keycloak during the very login of users through the identity provider is highly customisable. We propose below an example of a working flow but this can be changed to fit your need.

    • Navigate to Authentication > Flows, select First Broker Login and make a Copy of it. Name it for example SwitchAAI-Test Demo IdP First Broker Login.

    • Change the list of executions to make it look like the following image.

    Add the identity provider

    • In the Identity Providers menu, choose Add provider... > SAML v2.0

    • Specify an Alias. Note this will not be changeable later without redoing the whole process. Example: SwitchAAI-Test.

    • Specify a Display Name, which will be displayed to the user in the login page. Example:

    Add the username mapper

    We need to import a unique but intelligible username in Keycloak from the identity provider. For this we use the SwitchAAI mandatory attribute swissEduPersonUniqueID.

    • Open the Mappers tab and click Create.

    • Fill the field as:

      • Name: SwitchAAI Unique ID.

    Setup a certificate

    A certificate compliant with the SwitchAAI federation needs to be generated and configured. First to generate a self-signed certificate that meets their requirements. You will need from the Keycloak instance:

    • Its FQDN (fully-qualified domain name). Example: medco-demo.epfl.ch.

    • Its SAML entityID, that you can find out in the XML descriptor from the Export tab of the previously configured Keycloak identity provider. Example: https://medco-demo.epfl.ch/auth/realms/master.

    Once you have generated the certificate, set it up in Keycloak:

    • Navigate to the settings page Realm Settings > Keys > Providers and select Add Keystore... > rsa.

    • Specify a name in Console Display Name. Example: rsa-switchaaitest.

    • Specify a Priority higher than any other RSA key. Example: 150

    Register Keycloak instance as a Service Provider in SwitchAAI

    The following instructions are to be executed in the . As a result, a Keycloak instance will be registered as a service provider linked to a home organization in the SwitchAAI federation.

    Register new resource

    Click Add a Resource Description and fill the 7 categories of information according to the following instructions. Note that if some fields are not listed in this documentation, their value are not important for the registration of the Keycloak instance and can be set according to the explanations provided by the resource registry.

    1. Basic Resource Information

    • Entity ID: the same SAML entityID you used to generate the certificate. Example: https://medco-demo.epfl.ch/auth/realms/master.

    • Home Organization: the organization that hosts the Keycloak instance currently being registered. The responsible persons of the organization specified here will need to approve the registration. This will typically be the the institution where the MedCo node is deployed. For the purpose of our test we are using AAI Demo Home Organization (aai-demo-idp.switch.ch, AAI Test).

    • Home URL

    2. Descriptive Information

    3. Contacts

    4. Service Locations

    • SAML2 HTTP POST binding (x2): the URL at witch the SwitchAAI infrastructure will communicate with the Keycloak instance. You will find it in the configuration page of the configured identity provider in Keycloak under Redirect URI. Example: https://medco-demo.epfl.ch/auth/realms/master/broker/SwitchAAI-Test/endpoint

    5. Certificates

    Copy/paste in this field the PEM part of the certificate that was previously generated. Note that in the example showed below the certificate has already been validated through a separate channel.

    6. Requested Attributes

    Put on Required at least the following attributes. Note that the release of attributes needs to have a justification.

    • E-mail (email). Example reason: Identify user for being able to assign them specific authorizations.

    • Unique ID (swissEduPersonUniqueID). Example reason: Get a unique ID of user.

    7. Intended Audience and Interfederation

    Get the new resource approved

    Once submitted, the responsible persons from the home organization will need to approve the new resource and validate the fingerprint of the certificate submitted. This is a manual process that will most likely be done through email.

    Once this is done, the setup should be functional, and the users will be able to select the configured identity provider to login. Don't forget that this covers only users' authentication, their authorization needs to be handled manually through Keycloak after they login at least once.

    Command-Line Interface (CLI)

    MedCo provides a client command-line interface (CLI) to interact with the medco-connector APIs.

    Prerequisites

    To use the CLI, you must first follow one of the deployment guides. However, the version of the CLI documented here is the one shipped with the Local Development Deployment.

    How to use

    To show the CLI manual, run:

    For a start, you can use the credentials of the default user: username:test password:test

    query

    You can use this command to query the MedCo network.

    This is the syntax of an example query using the pre-loaded .

    You will get something like that:

    Not that, in the queries, the OR operator has the highest priority, so 1 AND 2 OR 3 AND 2 is factorised as (1) AND (2 OR 3) AND (2).

    genomic-annotations-get-values

    You can use this command to get the values of the genomic annotations that MedCo nodes make available for queries.

    To do some tests, you may want to .

    Then, for example, if you want to know which genomic annotations of type "protein_change" containing the string "g32" are available, you can run:

    You will get:

    The matching is case-insensitive and it is not possible to use wildcards. At the moment, with the loader v0, only three types of genomic annotations are available: variant_name, protein_change and hugo_gene_symbol.

    genomic-annotations-get-variants

    You can use this command to get the variant ID of a certain genomic annotation.

    To do some tests, you may want to .

    Then, for example, if you want to know the variant ID of the genomic annotation "HTR5A" of type "hugo_gene_symbol" with zygosity "heterozygous" or "homozygous", you can run:

    You will get:

    The matching is case-insensitive and it is not possible to use wildcards. If you request the ID of an annotation which is not available (e.g, in the previous, example, "HTR5") you will get an error message. At the moment, with the loader v0, only three types of genomic annotations are available: variant_name, protein_change and hugo_gene_symbol.

    Configuration

    This set of pages provide configuration instructions for MedCo. Note that all of them are not necessarily always needed, follow one of the deployment instructions to know which ones are.

    default test data
    load some data first
    load some data first
    export MEDCO_SETUP_DIR=~/medco-deployment
    cd ${MEDCO_SETUP_DIR}/compose-profiles/dev-local-3nodes/
    docker-compose -f docker-compose.tools.yml run medco-cli-client --user [USERNAME] --password [PASSWORD] --help
    
    NAME:
       medco-cli-client - Command-line query tool for MedCo.
    
    USAGE:
       medco-cli-client [global options] command [command options] [arguments...]
    
    VERSION:
       1.0.0
    
    COMMANDS:
       query, q                                Query the MedCo network
       genomic-annotations-get-values, gval    Get genomic annotations values
       genomic-annotations-get-variants, gvar  Get genomic annotations variants
       help, h                                 Shows a list of commands or help for one command
    
    GLOBAL OPTIONS:
       --user value, -u value      OIDC user login
       --password value, -p value  OIDC password login
       --token value, -t value     OIDC token
       --disableTLSCheck           Disable check of TLS certificates
       --help, -h                  show help
       --version, -v               print the version
    docker-compose -f docker-compose.tools.yml run medco-cli-client --user test --password test query --help
    
    NAME:
       medco-cli-client query - Query the MedCo network
    
    USAGE:
       medco-cli-client query [command options] [patient_list|count_per_site|count_per_site_obfuscated|count_per_site_shuffled|count_per_site_shuffled_obfuscated|count_global|count_global_obfuscated] [query string]
    
    OPTIONS:
       --resultFile value, -r value  Output file for the result CSV. Printed to stdout if omitted.
    docker-compose -f docker-compose.tools.yml run medco-cli-client --user test --password test query patient_list 1 AND 2 OR 3
    node_name,count,patient_list,DDTRequestTime,KSRequestTime,KSTimeCommunication,KSTimeExec,TaggingTimeCommunication,TaggingTimeExec,medco-connector-DDT,medco-connector-i2b2-PDO,medco-connector-i2b2-PSM,medco-connector-local-agg,medco-connector-local-patient-list-masking,medco-connector-overall,medco-connector-unlynx-key-switch-count,medco-connector-unlynx-key-switch-patient-list
    0,8,[1 2 3 4 5 6 7 8],268,162,154,0,218,23,275,2561,16507,0,32,19619,50,179
    1,0,[],212,61,43,0,179,12,232,2078,17993,0,1,20433,38,87
    2,0,[],196,38,30,0,172,7,216,1574,18889,1,2,20779,30,53
    docker-compose -f docker-compose.tools.yml run medco-cli-client --user test --password test genomic-annotations-get-values --help
    
    NAME:
       medco-cli-client genomic-annotations-get-values - Get genomic annotations values
    USAGE:
       medco-cli-client genomic-annotations-get-values [command options] [-l limit] [annotation] [value]
    OPTIONS:
       --limit value, -l value  Maximum number of returned values (default: 0)
    docker-compose -f docker-compose.tools.yml run medco-cli-client --user test --password test genomic-annotations-get-values protein_change g32
    G325R
    G32E
    docker-compose -f docker-compose.tools.yml run medco-cli-client --user test --password test genomic-annotations-get-variants --help
    
    NAME:
       medco-cli-client genomic-annotations-get-variants - Get genomic annotations variants
    
    USAGE:
       medco-cli-client genomic-annotations-get-variants [command options] [-z zygosity] [-e] [annotation] [value]
    
    DESCRIPTION:
       zygosity can be either heterozygous, homozygous, unknown or a combination of the three separated by |
    If omitted, the command will execute as if zygosity was equal to "heterozygous|homozygous|unknown|"
    
    OPTIONS:
       --zygosity value, -z value  Variant zygosysty
       --encrypted, -e             Return encrypted variant id
    docker-compose -f docker-compose.tools.yml run medco-cli-client --user test --password test genomic-annotations-get-variants -z "heterozygous|homozygous" hugo_gene_symbol HTR5A
    -7039476204566471680
    -7039476580443220992
    SwitchAAI-Test Demo IdP
    .
  • Specify the Single Sign-On Service URL of the identity provider you are linking with. Example: https://aai-demo-idp.switch.ch/idp/profile/SAML2/POST/SSO.

  • Specify the First Login Flow previously configured to use. Example: SwitchAAI-Test Demo IdP First Broker Login.

  • Toggle to ON the following buttons:

    • Enabled

    • Trust Email

    • HTTP-POST Binding Response

    • HTTP-POST Binding for AuthnRequest

    • Validate Signature

  • Specify the NameID Policy Format as Persistent.

  • Add the certificate(s) (PEM format, separated by commas if there are several of them) of the identity provider you are linking with in Validating X509 Certificates.

  • Save the changes.

  • Mapper Type: Username Template Importer.

  • Template: ${ATTRIBUTE.swissEduPersonUniqueID}

  • Save the changes.

  • .
  • In Private RSA Key and X509 Certificate fields, copy/paste the respective PEM parts of both the private key and the certificate that were previously generated.

  • : the address of the MedCo node, at which the UI Glowing Bear can be accessed. Example:
    https://medco-demo.epfl.ch/
    .
    SwitchAAI Resource Registry
    follow this SwitchAAI guide
    AAI Resource Registry
    Resulting configuration for the authentication flow.
    Resulting configuration for the identity provider.
    Resulting configuration for the username mapper.
    Resulting configuration.
    Example configuration for the basic resource information.
    Example configuration for the descriptive information.
    Example configuration for the contacts.
    Example configuration for the service locations.
    Example configuration for the certificates.
    Example configuration for the requested attributes.
    Example configuration for the intended audience.

    Data Loading

    The current version of the loader offers two different loading alternatives: (v0) loading of clinical and genomic data based on MAF datasets; and (v1) loading of generic i2b2 data. Currently these two loaders support each one dataset:

    • v0: a genomic dataset (tcga_cbio publicly available in cBioPortal)

    • v1: the i2b2 demodata.

    Future releases of this software will allow for other arbitrary data sources, given that they follow a specific structure (e.g. BAM format).

    Pre-Requisite: Download test data

    From the medco-deployment folder, execute the resources/data/download.sh script to download the test datasets.

    Dummy Generation

    The provided example data set files come with dummy data pre-generated. Those data are random dummy entries whose purpose is to prevent frequency attacks. In a future release, the generation will be done dynamically by the loader.

    HTTPS Configuration

    HTTPS is supported for the profiles test-local-3nodes, test-network and prod-network.

    Certificate

    The certificates are held in the configuration profile folder (e.g, ${MEDCO_SETUP_DIR}/configuration-profiles/test-local-3nodes):

    • certificate.key: private key

    • certificate.crt: certificate of own node

    • srv0-certificate.crt, srv1-certificate.crt, …: certificates of all nodes of the network

    Enable HTTPS for the Local Local Deployment

    To enable HTTPS for the profile test-local-3nodes, replace the files certificate.key and certificate.crt from the configuration profile folder with your own versions. Such a certificate can be obtained for example through .

    Then edit the file .env from the compose profile, replace the http with https, and restart the deployment.

    Configure HTTPS for the Network Test and Production Deployments

    For these profiles, HTTPS is mandatory. The profile generation scripts generate and use default self-signed certificates for each node. Those are perfectly fine to be used, but because they are self-signed, an HTTPS warning will be displayed to users in their browser when accessing one of the Glowing Bear instance.

    There is currently only one way of avoiding this warning: configuring the browsers of your users to trust this certificate. This procedure is specific to the browsers and operating systems used at your site.

    In MedCo v1.0.0 the possibility of using your own trusted certificates will be added.

    v1 (I2B2 Demodata)

    The v1 loader expects an already existing i2b2 database (in .csv format) that will be converted in a way that is compliant with the MedCo data model. This involves encrypting and deterministically tagging some of the data.

    List of input (‘original’) files:

    • all i2b2metadata files (e.g. i2b2.csv)

    • dummy_to_patient.csv

    • patient_dimension.csv

    • visit_dimension.csv

    • concept_dimension.csv

    • modifier_dimension.csv

    • observation_fact.csv

    • table_access.csv

    How to use

    Ensure you have before proceeding to the loading.

    The following examples show you how to load data into a running MedCo deployment. Adapt accordingly the commands your use-case.

    Examples

    Loading the three nodes on the dev-local-3nodes profile

    Loading one node on a network-test profile

    Explanation of the command's arguments

    Test that the loading was successful

    To check that it is working you can query for:

    -> Diagnoses -> Neoplasm -> Benign neoplasm -> Benign neoplasm of breast

    You should obtain 2 matching subjects.

    Keycloak

    Here follows some MedCo-specific instructions for the administration of Keycloak. For anything else, please refer to the Keycloak Server Administration Guide. Those instructions do not necessarily need to be all followed for all deployments, refer to the deployment guide to know which ones are important.

    For a production deployment, it is crucial to change the default keys and credentials.

    Accessing the web administration interface

    You can access the Keycloak administration interface at http(s)://<node domain name>/auth/admin. For example if MedCo is deployed on your local host, you can access it at http://localhost/auth/admin. Use the admin default credentials if you had just deployed MedCo.

    User Management

    Default users

    The default configuration shipped with the MedCo deployments come with two users.

    Admin user

    The default admin credentials has all the admin access to Keycloak, but no access rights to MedCo. Its credentials are :

    • User keycloak

    • Password keycloak (unless configured otherwise through the .env file)

    Test user

    The default MedCo user has all the authorizations to run all types of MedCo query. It is this user you should use to log in MedCo. Its credentials are:

    • User test

    • Password test

    Add a user

    • Go to the configuration panel Users, click on Add user.

    • Fill the Username field, toggle to ON the Email Verified button and click Save.

    • In the next window, click on Credentials, enter twice the user’s password, toggle to OFF the

    Give query permissions to a user

    • Go to the configuration panel Users, search for the user you want to give authorization to and click on Edit.

    • Go to the Role Mappings tab, and select medco (or another client ID set up for the MedCo OIDC client) in the Client Roles.

    • Add the roles you wish to give the user, each of the roles maps to a query type.

    MedCo Default Settings

    medco OpenID Connect client

    The default Keycloak configuration provides an example of a fully working configuration for deployments on your local host. In other cases, you will need to modify this configuration.

    Access the configuration panel of the MedCo client by going to the Clients tab, and click on the medco client. Then, in the Settings tab, fill Valid Redirect URIs to reflect the following table (you can delete the existing entries):

    In the same tab, fill Web Origins with + and save.

    Securing a production deployment

    Changing default passwords

    Both keycloak and test users comes with default passwords. For a production deployment they need to be changed:

    • Go to the configuration panel Users, click on View all users.

    • For each of the users you want to change the password of:

      • Click on Edit, then go the Credentials tab.

    Changing default realm keys

    The example configuration comes with default keys. They have to be changed for a network deployment where there are several Keycloak instances.

    • Go to the configuration panel Realm Settings, then to the Keys tab and Providers subtab.

    • Click on Add keystore... and add the three following providers:

      • aes-generated

    Enabling brute force detection

    • Go to the configuration panel Realm Settings, then to the Security Defenses tab and Brute Force Detection subtab.

    • Toggle to ON the Enabled button.

    • Fill the following:

    System Architecture

    Containers

    medco-connector

    Component orchestrating the MedCo query at the clinical site. Implements the resource-side of the PIC-SURE API. It communicates with

    Temporary
    button if desired and click
    Reset Password
    .

    Enter the new password of the user

  • Optionally toggle to OFF the Temporary button; if ON the user at the next login will need to update his password.

  • Click on Reset Password.

  • Console Display Name: aes-medco

  • Priority: 100

  • hmac-generated

    • Console Display Name: hmac-medco

    • Priority: 100

    • rsa-generated

      • Console Display Name: rsa-medco

      • Priority: 100

  • Finally, delete all the other key providers listed that you did not just add. They should be named xxx-generated. Note that it is normal if you get logged out during the operation, just log back in and continue the process.

  • Max Login Failures: 3

  • Wait Increment: 30 Seconds

  • Save the configuration.

  • Deployment Profile

    Valid Redirect URIs

    test-local-3nodes

    http(s)://<node domain name>/*

    test-network + prod-network

    https://<node domain name>/*

    dev-local-3nodes

    http://localhost:4200/*

    Let’s Encrypt
    cd ${MEDCO_SETUP_DIR}/resources/data
    bash download.sh
    downloaded the data
    export MEDCO_SETUP_DIR=~/medco-deployment \
        MEDCO_DEPLOYMENT_PROFILE=dev-local-3nodes
    cd "${MEDCO_SETUP_DIR}/compose-profiles/${MEDCO_DEPLOYMENT_PROFILE}"
    docker-compose -f docker-compose.tools.yml run medco-loader-srv0 v1 \
        --sen /data/i2b2/sensitive.txt \
        --files /data/i2b2/files.toml
    docker-compose -f docker-compose.tools.yml run medco-loader-srv1 v1 \
        --sen /data/i2b2/sensitive.txt \
        --files /data/i2b2/files.toml
    docker-compose -f docker-compose.tools.yml run medco-loader-srv2 v1 \
        --sen /data/i2b2/sensitive.txt \
        --files /data/i2b2/files.toml
    export MEDCO_SETUP_DIR=~/medco-deployment \
        MEDCO_DEPLOYMENT_PROFILE=test-network-xxx-node0
    cd "${MEDCO_SETUP_DIR}/compose-profiles/${MEDCO_DEPLOYMENT_PROFILE}"
    docker-compose -f docker-compose.tools.yml run medco-loader v1 \
        --sen /data/i2b2/sensitive.txt \
        --files /data/i2b2/files.toml
    NAME:
        medco-loader v1 - Convert existing i2b2 data model
    
    USAGE:
        medco-loader v1 [command options] [arguments...]
    
    OPTIONS:
        --group value, -g value               UnLynx group definition file
        --entryPointIdx value, --entry value  Index (relative to the group definition file) of the collective authority server to load the data
        --sensitive value, --sen value        File containing a list of sensitive concepts
        --dbHost value, --dbH value           Database hostname
        --dbPort value, --dbP value           Database port (default: 0)
        --dbName value, --dbN value           Database name
        --dbUser value, --dbU value           Database user
        --dbPassword value, --dbPw value      Database password
        --files value, -f value               Configuration toml with the path of the all the necessary i2b2 files
        --empty, -e                           Empty patient and visit dimension tables (y/n)
    medco-unlynx
    to execute the distributed cryptographic protocols.
    .

    medco-unlynx

    The software executing the distributed cryptographic protocols, based on Unlynx. Sources on GitHub.

    glowing-bear-medco

    Nginx web server serving Glowing Bear and the javascript crypto module. Sources on GitHub.

    medco-loader

    ETL tool to encrypt and load data into MedCo. Sources on GitHub.

    i2b2

    The i2b2 stack (all the cells). Project website.

    keycloak

    OpenID Connect identity provider, providing user management and their authentication to MedCo. Project website.

    postgresql

    The SQL database used by all other services, contains all the data. Project website.

    pg-admin

    A web-based administration tool for the PostgreSQL database. Project website.

    nginx

    Web server and (HTTPS-enabled) reverse proxy. Project website.

    Sources on GitHub

    Common Problems

    Docker-related issues

    Changing the Docker default address pool

    If after deploying MedCo you notice some connectivity problems on your machine, or on the opposite the running containers have connectivity problems, check for potential conflict between your machine networks and Docker's virtual network (e.g. with ifconfig). If you do have such conflicts, you can edit Docker's configuration to set the addresses to use. Example:

    Using Docker as non-root user

    If you get such an error message while trying to execute commands as a non-root user:

    You will need to follow .

    Local Development Deployment

    Deployment profile dev-local-3nodes.

    This deployment profile comes with default pre-generated keys and password. It is not meant to contain any real data nor be used in production. If you wish to do so, use instead the Network Production Deployment (prod-network) deployment profile.

    This deployment profile deploys 3 MedCo nodes on a single machine for development purposes. It is meant to be used only on your local machine, i.e. localhost. The tags of the docker images used are all dev, i.e. the ones built from the development version of the different source codes. They are available either through Docker Hub, or built locally from the sources of each component.

    MedCo Stack Deployment (except Glowing Bear)

    First step is to clone the medco-deployment repository with the correct branch. This example gets the data in the home directory of the current user, but that can be of course changed.

    Next step is to obtain the docker images defined in the medco-deployment repository:

    Note that this will pull from Docker Hub the docker images tagged with dev. Because those are development versions, there is no guarantee that they will work at any point in time.

    Next step is to run the nodes. They will run simultaneously, and the logs of the running containers will maintain the console captive. No configuration changes are needed in this scenario before running the nodes. To run them:

    Wait some time for the initialization of the containers to be done (up to the message: “i2b2-medco-srv… - Started x of y services (z services are lazy, passive or on-demand)”), this can take up to 10 minutes. For the subsequent runs, the startup will be faster.

    Deploy new docker image of a running service

    In order to deploy new code in the running deployment, it is enough to stop and start again the running container(s). Example:

    To confirm that a new version of the image has been deployed, Docker will output in the console "Recreating container ...".

    Glowing Bear Deployment

    First step is to clone the glowing-bear repository with the correct branch.

    Glowing Bear is deployed separately for development, as we use its convenient live development server:

    Note that the first run will take a significant time in order to build everything.

    In order to stop the containers, simply hit Ctrl+C in all the active windows.

    Test the deployment

    In order to test that the development deployment of MedCo is working, access Glowing Bear in your web browser at http://localhost:4200 and use the default credentials specified in . If you are new to Glowing Bear you can watch the video. You can also use the to perform tests.

    By default MedCo loads a specific test data, refer to for expected results to queries. To load a dataset, follow the guide .

    v0 (Genomic Data)

    The v0 loader expects an ontology, with mutation and clinical data in the MAF format. As the ontology data you must use ${MEDCO_SETUP_DIR}/resources/data/genomic/tcga_cbio/clinical_data.csv and ${MEDCO_SETUP_DIR}/resources/data/genomic/tcga_cbio/mutation_data.csv. For clinical data you can keep using the same two files or a subset of the data (e.g. 8_clinical_data.csv). More information about how to generate sample data files can be found below. After the following script is executed all the data is encrypted and deterministically tagged in compliance with the MedCo data model.

    How to use

    Description of the default test data

    The default data loaded in MedCo is a small artificially generated dataset, appropriate to test a fresh deployment. The same data is replicated on all the nodes. Note that as of now it is encrypted using the test keys, i.e. the ones used for deployment profiles dev-local-3nodes and test-local-3nodes.

    It contains 4 patients: 1 (real), 2 (real), 3 (real), 4 (dummy).

    And 3 concepts: 1, 2, and 3.

    The observation fact contains the following entries:

    • patient 1, concept 1

    Network Architecture

    External Entities

    Entities that need to connect to a machine running MedCo can be categorized as follow:

    • System administrators: Persons administrating the MedCo node. Likely to remain inside the clinical site internal network.

    Database

    Administration with PgAdmin

    PgAdmin can be accessed through http(s)://<node domain name>/pgadmin with username admin and password admin (by default). To access the test database just create a server with the name MedCo, the address postgresql, username postgres

    patient 2, concept 1

  • patient 2, concept 2

  • patient 3, concept 2

  • patient 3, concept 3

  • patient 4, concept 1

  • patient 4, concept 2

  • patient 4, concept 3

  • Example queries and expected results (per node):

    • 1 AND 2: 1 (patient 2)

    • 2 AND 3: 1 (patient 3)

    • 1 AND 2 AND 3: 0

    • (1 OR 2): 3 (patients 1, 2 and 3)

    • (1 OR 3) AND 2: 1 (patients 2 and 3)

    /etc/docker/daemon.json
    {
      "default-address-pools": [{
          "base": "10.10.0.0/16",
          "size": 24
      }]
    }
    docker: Got permission denied while trying to connect to the Docker daemon socket at ...
    these instructions from the Docker official documentation
    Keycloak user management
    Glowing Bear user interface walkthrough
    CLI client
    Description of the default test data
    Loading Data

    Ensure you have downloaded the data before proceeding to the loading.

    The following examples show you how to load data into a running MedCo deployment. Adapt accordingly the commands your use-case.

    Examples

    Loading the three nodes on the dev-local-3nodes profile

    Loading one node on a network-test profile

    Explanation of the command's arguments

    Test that the loading was successful

    To check that it is working you can query for:

    -> MedCo Gemomic Ontology -> Gene Name -> BRPF3

    For the small dataset 8_xxxx you should obtain 3 matching subjects (one at each site).

    cd ~
    git clone -b dev https://github.com/ldsec/medco-deployment.git
    cd ~/medco-deployment/compose-profiles/dev-local-3nodes
    docker-compose -f docker-compose.yml -f docker-compose.tools.yml pull
    $ docker-compose up
    docker-compose stop medco-connector-srv0 medco-connector-srv1 medco-connector-srv2
    docker-compose up -d medco-connector-srv0 medco-connector-srv1 medco-connector-srv2
    cd ~
    git clone -b dev https://github.com/ldsec/glowing-bear-medco.git
    cd ~/glowing-bear-medco/deployment
    docker-compose up dev-server
    export MEDCO_SETUP_DIR=~/medco-deployment \
        MEDCO_DEPLOYMENT_PROFILE=dev-local-3nodes
    cd "${MEDCO_SETUP_DIR}/compose-profiles/${MEDCO_DEPLOYMENT_PROFILE}"
    docker-compose -f docker-compose.tools.yml run medco-loader-srv0 v0 \
        --ont_clinical /data/genomic/tcga_cbio/8_clinical_data.csv \
        --sen /data/genomic/sensitive.txt \
        --ont_genomic /data/genomic/tcga_cbio/8_mutation_data.csv \
        --clinical /data/genomic/tcga_cbio/8_clinical_data.csv \
        --genomic /data/genomic/tcga_cbio/8_mutation_data.csv \
        --output /data/
    docker-compose -f docker-compose.tools.yml run medco-loader-srv1 v0 \
        --ont_clinical /data/genomic/tcga_cbio/8_clinical_data.csv \
        --sen /data/genomic/sensitive.txt \
        --ont_genomic /data/genomic/tcga_cbio/8_mutation_data.csv \
        --clinical /data/genomic/tcga_cbio/8_clinical_data.csv \
        --genomic /data/genomic/tcga_cbio/8_mutation_data.csv \
        --output /data/
    docker-compose -f docker-compose.tools.yml run medco-loader-srv2 v0 \
        --ont_clinical /data/genomic/tcga_cbio/8_clinical_data.csv \
        --sen /data/genomic/sensitive.txt \
        --ont_genomic /data/genomic/tcga_cbio/8_mutation_data.csv \
        --clinical /data/genomic/tcga_cbio/8_clinical_data.csv \
        --genomic /data/genomic/tcga_cbio/8_mutation_data.csv \
        --output /data/
    export MEDCO_SETUP_DIR=~/medco-deployment \
        MEDCO_DEPLOYMENT_PROFILE=test-network-xxx-node0
    cd "${MEDCO_SETUP_DIR}/compose-profiles/${MEDCO_DEPLOYMENT_PROFILE}"
    docker-compose -f docker-compose.tools.yml run medco-loader v0 \
        --ont_clinical /data/genomic/tcga_cbio/8_clinical_data.csv \
        --sen /data/genomic/sensitive.txt \
        --ont_genomic /data/genomic/tcga_cbio/8_mutation_data.csv \
        --clinical /data/genomic/tcga_cbio/8_clinical_data.csv \
        --genomic /data/genomic/tcga_cbio/8_mutation_data.csv \
        --output /data/
    NAME:
        medco-loader v0 - Load genomic data (e.g. tcga_bio dataset)
    
    USAGE:
        medco-loader v0 [command options] [arguments...]
    
    OPTIONS:
        --group value, -g value               UnLynx group definition file
        --entryPointIdx value, --entry value  Index (relative to the group definition file) of the collective authority server to load the data
        --sensitive value, --sen value        File containing a list of sensitive concepts
        --dbHost value, --dbH value           Database hostname
        --dbPort value, --dbP value           Database port (default: 0)
        --dbName value, --dbN value           Database name
        --dbUser value, --dbU value           Database user
        --dbPassword value, --dbPw value      Database password
        --ont_clinical value, --oc value      Clinical ontology to load
        --ont_genomic value, --og value       Genomic ontology to load
        --clinical value, --cl value          Clinical file to load
        --genomic value, --gen value          Genomic file to load
        --output value, -o value              Output path to the .csv files

    End-users: Researchers using MedCo to access the shared. Likely to remain inside the clinical site internal network.

  • Other MedCo nodes: MedCo nodes belonging to other clinical sites of the network.

  • Firewall Ports Opening

    The following ports should be accessible by the listed entities, which makes IP address white-listing possible:

    • Port 22, 5432 (TCP): System Administrators

    • Port 80 (TCP): End-Users (HTTP automatic redirect to HTTPS (443))

    • Port 443 (TCP): System Administrators, End-Users, Other MedCo Nodes

    • Ports 2000-2001 (TCP): Other MedCo Nodes

    MedCo Network Architecture.
    and password
    postgres
    (by default). Note that PgAdmin is not included in the production deployments.
    PgAdmin server configuration.