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.0-PR11-dist.zip -O /tmp/shrine-setup.zip unzip -d /tmp /tmp/shrine-setup.zip |
...
In that directory find the following database update scripts script for your brand of database: hub/sql/brand-update.sql and adapter/sql/shrine_query_history-brand.sql . Run the appropriate script on your database. For MariaDB run the following shell commands:
Code Block | ||||
---|---|---|---|---|
| ||||
mysql -u shrine -pYourPassword qepAuditDB < /tmp/shrine-setup/hub/sql/mysql-update.sql mysql -u shrine -pYourPassword shrine_query_history < /tmp/shrine-setup/adapter/sql/shrine_query_history-update-mysql.sql |
For MS SQL and Oracle, run the scripts appropriate for your databases.
For hub administrators only, run the following shell command:
Code Block | ||||
---|---|---|---|---|
| ||||
mysql -u shrine -pYourPassword qepAuditDB < /tmp/shrine-setup/hub/sql/mysql-update.sql
|
Overview
Content Tools