Page History
...
Code Block | ||||
---|---|---|---|---|
| ||||
wget https://repo.open.catalyst.harvard.edu/nexus/content/groups/public/net/shrine/shrine-setup/3.2.0-PR11/shrine-setup-3.2.01-PR1-dist.zip -O shrine-setup.zip unzip shrine-setup.zip |
...
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 stewardDBshrine_query_history < shrine-setup/dsaadapter/sql/shrine_query_history-update-mysql.ddlsql mysql -u shrine -pdemouser qepAuditDBstewardDB < shrine-setup/qepdsa/sql/mysql.ddl mysql -u shrine -pdemouser qepAuditDB < shrine-setup/qep/sql/mysql-update.sqlddl |
Sign into MySQL as root and grant the shrine user full access again to all of these databases and their tables:
...
- ./dsa/sql/mssql.ddl
- ./qep/sql/mssql.ddl
- ./qepadapter/sql/adapterAuditDB-mssql-update.ddl
- ./adapter/sql/adapterAuditDBshrine_query_history-mssql.ddlddl
- ./adapter/sql/shrine_query_history-update-mssql.ddl sql
Oracle
To install oracle schemas load all of the SHRINE databases into one central schema: ShrineDB (use this name when you configure context.xml).
...
Specifically, for SHRINE release 3.02.01, 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
- ./qepadapter/sql/adapterAuditDB-oracle-update.ddl
- ./adapter/sql/adapterAuditDBshrine_query_history-oracle.ddl
- ./adapter/sql/shrine_query_history-update-oracle.ddlsql
Overview
Content Tools