Page History

...

This migration tool can be found on the HMS Sonatype Nexus server at https://repo.open.med.harvard.edu/nexus/content/groups/public/net/shrine/adapter-queries-to-qep/. Navigate to the folder for 1.21.1. From there, download adapter-queries-to-qep-1.21.1.zip to the /opt/shrine/ directory of your SHRINE server and rename it to adapter-queries-to-qep.zip. Then, unzip the adapter-queries-to-qep.zip file and navigate to the directory it creates.

For example:

$ cd /opt/shrine/
$ wget --no-check-certificate https://repo.open.med.harvard.edu/nexus/content/groups/public/net/shrine/adapter-queries-to-qep/1.21.1/adapter-queries-to-qep-1.21.1.zip -O adapter-queries-to-qep.zip
$ unzip adapter-queries-to-qep.zip
$ cd adapter-queries-to-qep-1.21.1/

After this, edit conf/adapter-queries-to-qep.conf. There are two major blocks to this conf file: adapter{} and queryEntryPoint{}. adapter{} refers to the old shrine_query_history dataSource, which will be used as the source of previous query history. queryEntryPoint{} refers to the new qepAuditDB dataSource, which will be the migration destination. Both sections have the following configuration values, which mirror attributes in shrine.xml for their corresponding <Resource/> element:

...

• i2b2 domain used by SHRINE. i2b2 demo installations use i2b2demo by default.
• path to config file for the adapter-queries-to-qep tool. This is almost always conf/adapter-queries-to-qep.conf
• path to SHRINE config file. This is typically /opt/shrine/tomcat/lib/shrine.conf

For example:

...

$ chmod +x adapter-queries-to-qep

...

 $ ./adapter-queries-to-qep 

...

i2b2demo conf/adapter-queries-to-qep.conf /opt/shrine/tomcat/lib/shrine.conf

Depending on the size of your database, this process may take a few minutes.

...