Page History

To make sure that your new SHRINE instance can communicate with the i2b2 instance, there are a couple of places that we will address. First, you will need to make sure the PM, ONT, CRC cell urls are correctly defined within the shrine.conf file. These urls are what SHRINE uses to communicate with the i2b2 backend:

In the main shrine {} section:

Code Block

language	bash
theme	rdark

pmEndpoint {
    url = "http://localhost:9090/i2b2/services/PMService/getServices"
  }

ontEndpoint {
    url = "http://localhost:9090/i2b2/services/OntologyService"
  }

In the adapter {} section:

Code Block

language	bash
theme	rdark

crcEndpoint {
      url = "http://localhost:9090/i2b2/services/QueryToolService"
    }

Next, you will need to add the SHRINE project into the pm_project_data table within the i2b2pm schema:

Code Block

language	sql
theme	rdark

$ psql -U postgres i2b2
 
i2b2=# set search_path = i2b2pm;
 
i2b2=# insert into PM_PROJECT_DATA (project_id, project_name, project_wiki, project_path, status_cd) values ('SHRINE', 'SHRINE', 'http://open.med.harvard.edu/display/SHRINE', '/SHRINE', 'A');

After loading the ontology into SHRINE, you will need to add a SHRINE CRC connection to the pm_cell_data table within the i2b2pm schema:

Code Block

language	sql
theme	rdark

$ psql -U postgres i2b2
 
i2b2=# set search_path = i2b2pm;
 
i2b2=# insert into PM_CELL_DATA (cell_id, project_path, name, method_cd, url, can_override, status_cd) values ('CRC', '/SHRINE', 'SHRINE Federated Query', 'REST', 'https://your_shrine_url:6443/shrine/rest/i2b2/', 1, 'A');

This should result in something that looks like this:

After doing that, you will also need to add the Shrine Ontology data source (DS) to the ont-ds.xml file within the i2b2 instance. This file should be located within your i2b2 deployments directory (/opt/wildfly/standalone/deployments):

Code Block

language	xml
theme	rdark

<datasource jta="false" jndi-name="java:/ShrineOntologyDS" pool-name="ShrineOntologyDS" enabled="true" use-ccm="false">
    <connection-url>jdbc:postgresql://localhost:5432/i2b2</connection-url>
    <driver-class>org.postgresql.Driver</driver-class>
    <driver>postgresql-9.2-1002.jdbc4.jar</driver>
    <security>
    	<user-name>shrine_ont</user-name>
    	<password>demouser</password>
    </security>

    <validation>
    	<validate-on-match>false</validate-on-match>
    	<background-validation>false</background-validation>
    </validation>

    <statement>
    	<share-prepared-statements>false</share-prepared-statements>
    </statement>
</datasource>

Once all of that is done, you will need to restart WildFly and Tomcat.

Page tree

Versions Compared

Old Version 6

New Version 7

Key