Page History
...
Code Block | ||||
---|---|---|---|---|
| ||||
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:
...
Code Block | ||||
---|---|---|---|---|
| ||||
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
mysql -u shrine -pdemouser qepAuditDB < shrine-setup/qep/sql/mysql-update.ddl |
Sign into MySQL as root and grant the shrine user full access again to all of these databases and their tables:
Code Block | ||||
---|---|---|---|---|
| ||||
$ mysql -u root
MariaDB [(none)]> GRANT ALL privileges ON *.* TO 'shrine'@'localhost';
MariaDB [(none)]> FLUSH PRIVILEGES; |
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
- ./qep/sql/mssql-update.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).
...
- ./dsa/sql/oracle.ddl
- ./qep/sql/oracle.ddl
- ./qep/sql/oracle-update.ddl
- ./adapter/sql/adapterAuditDB-oracle.ddl
- ./adapter/sql/shrine_query_history-oracle.ddl
...
Overview
Content Tools