Page History

...

$ cd /opt/shrine/tomcat/webapps
$ wget --no-check-certificate https://repo.open.med.harvard.edu/nexus/content/groups/public/net/shrine/dashboard-war/1.22.4/dashboard-war-1.22.4 -O shrine-dashboard.war

Deploy New SHRINE Node Metadata Service

Like other SHRINE artifacts, the SHRINE Node Metadata Service can be found on the HMS Sonatype Nexus server at https://repo.open.med.harvard.edu/nexus/content/groups/public/net/shrine/meta-war/. Navigate to the folder for 1.22.4. From there, download meta-war-1.22.4.war to the webapps/ directory on the SHRINE server and rename it to shrine-meta.war.

For example:

$ cd /opt/shrine/tomcat/webapps
$ wget --no-check-certificate https://repo.open.med.harvard.edu/nexus/content/groups/public/net/shrine/dashboard-war/1.22.4/dashboard-war-1.22.4 -O shrine-dashboard.war

(Optional) For Users of Oracle or SQL Server

If you experience issues in getting the SHRINE Data Steward (or the new audit logging functionality) working with Oracle or SQL Server, please try the instructions in this article written by a SHRINE developer: Using SHRINE Data Steward with Oracle or SQL Server

This article contains links to alternative database drivers, as well as links to alternative database scripts for creating tables for the SHRINE Data Steward. It also includes information on the necessary changes to make to shrine.xml, steward.xml,  shrine.conf, and steward.conf.Also note that due to the new query audit database functionality added in SHRINE 1.20.1, you will also need to modify and shrine.conf.

There are audit{} blocks that must be added to both the adapter{} and queryEntryPoint{} sections of shrine.conf includes several instances of slickProfileClassName. By default, these are configured to use MySQL, so users of MySQL do not need to add anything to their shrine.conf. However, users . Users of Oracle or SQL Server for SHRINE must add them. See the below for an example:

...

Replace "freeslick.driverNameHere$" with the name of the driver you are using ("freeslick.OracleProfile$" for Oracle, and "freeslick.MSSQLServerProfile$" for SQL Server).

TODO start here with database work

Create Query Audit Databases

SHRINE 1.2022.1 4 adds query audit databases, which will need to be created in order for SHRINE 1.20.1 to function.

...