Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagebash
themeRDark
wget https://repo.open.catalyst.harvard.edu/nexus/content/groups/public/net/shrine/shrine-setup/2.0.0/shrine-setup-3.0.0-dist.zip -O /tmp/shrine-setup.zip
unzip -d /tmp /tmp/shrine-setup.zip

In that directory find three database update scripts for your brand of database: adapter/adapterAuditDB-update-brand.sql, adapter/shrine_query_history-update-mysql.sql and qep/update-brand.sql . Run each of the appropriate scripts on your databases. For MariaDB run the following shell commands:

Code Block
languagebash
themeRDark
mysql -u shrine -pdemouserpYourPassword adapterAuditDB < /tmp/shrine-setup/adapter/sql/adapterAuditDB-update-mysql.sql
mysql -u shrine -pdemouserpYourPassword shrine_query_history < /tmp/shrine-setup/adapter/sql/shrine_query_history-update-mysql.sql
mysql -u shrine -pdemouserpYourPassword qepAuditDB < /tmp/shrine-setup/qep/sql/update-mysql.sql

...