Page History
...
Code Block | ||||
---|---|---|---|---|
| ||||
wget https://repo.open.catalyst.harvard.edu/nexus/content/groups/public/net/shrine/shrine-setup/3.2.1/shrine-setup-34.20.10-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 shrine_query_history < shrine-setup/adapter/sql/shrine_query_history-update-mysql.sql mysql -u shrine -pdemouser stewardDB < shrine-setup/dsa/sql/mysql.ddl mysql -u shrine -pdemouser qepAuditDB < shrine-setup/qep/sql/mysql.ddl |
...
- ./dsa/sql/mssql.ddl
- ./qep/sql/mssql.ddl
- ./adapter/sql/adapterAuditDB-mssql.ddl
- ./adapter/sql/shrine_query_history-mssql.ddl ./adapter/sql/shrine_query_history-update-mssql.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).
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 3.2.1, 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./adapter/sql/shrine_query_history-update-oracle.sql
Overview
Content Tools