wget https://repo.open.med.harvard.edu/nexus/content/groups/public/net/shrine/shrine-setup/2.0.0/shrine-setup-2.0.0-dist.zip -O shrine-setup.zip
unzip shrine-setup.zip

MariaDB

$ mysql -u shrine -pdemouser


CREATE DATABASE adapterAuditDB;
CREATE DATABASE qepAuditDB;
CREATE DATABASE stewardDB;
CREATE DATABASE shrine_query_history;


mysql -u shrine -pdemouser adapterAuditDB < shrine-setup/adapter/sql/adapterAuditDB-mysql.ddl
mysql -u shrine -pdemouser shrine_query_history < shrine-setup/adapter/sql/shrine_query_history-mysql.ddl
mysql -u shrine -pdemouser stewardDB < shrine-setup/dsa/sql/mysql.ddl
mysql -u shrine -pdemouser qepAuditDB < shrine-setup/qep/sql/mysql.ddl


Sign into MySQL as root and grant the shrine user full access again to all of these databases and their tables:

$ mysql -u root
MariaDB [(none)]> GRANT ALL privileges ON *.* TO 'shrine'@'localhost';

MS SQL Server

To install schemas for MS SQL Server, instead of schemas labeled with mysql.sql, use schemas ending with mssql.sql. 

Oracle

To install oracle schemas load all of the SHRINE databases into one central schema: ShrineDB (you will use this name when you are configuring context.xml).

Once you have created the database, load all the schemas into it. Instead of schemas labeled with mysql.sql, load schemas ending with oracle.ddl.

Specifically, for SHRINE release 2.0.0, there are four (4) ddl files that you should load.  These files are found within the shrine-setup.zip archive file:

  • ./dsa/sql/oracle.ddl
  • ./qep/sql/oracle.ddl
  • ./adapter/sql/adapterAuditDB-oracle.ddl
  • ./adapter/sql/shrine_query_history-oracle.ddl


  • No labels