...

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

This .zip file contains schemas as .ddls and template shrine.conf and tomcat context.xml and server.xml files. You'll be using the schemas first.

MariaDB

SHRINE uses four databases to log its operations: qepAuditDB, adapterAuditDB, stewardDB, and shrine_query_history. Sign into mariaDB as the 'shrine' user to perform these commands:

...

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

MS SQL Server

Install schemas for MS SQL Server, instead of schemas labeled with mysql.sql, use schemas ending with mssql.sql from shrine-setup.zip:

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

Oracle

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

...