Page History
...
Code Block | ||||
---|---|---|---|---|
| ||||
wget https://repo.open.catalyst.harvard.edu/nexus/content/groups/public/net/shrine/shrine-setup/3.12.0-PR1/shrine-setup-3.2.0-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.ddl |
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).
...
- ./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
- ./adapter/sql/shrine_query_history-update-oracle.sql
Overview
Content Tools