Date: Thu, 28 Mar 2024 18:00:14 -0400 (EDT) Message-ID: <1580362971.824.1711663214771@prodopencatalystconfluence.catalyst> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_823_471706506.1711663214769" ------=_Part_823_471706506.1711663214769 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Download this .zip file and unpack it = in a temporary directory:
wget https://repo= .open.catalyst.harvard.edu/nexus/content/groups/public/net/shrine/shrine-se= tup/3.2.1/shrine-setup-3.2.1-dist.zip -O shrine-setup.zip unzip shrine-setup.zip
This .zip file contains schemas as .ddls and t= emplate shrine.conf and tomcat context.xml and server.xml files. You'll be = using the schemas first.
SHRINE uses four databases to log its operatio= ns: qepAuditDB, adapterAuditDB, stewardDB, and shrine_query_hi= story. Sign into mariaDB as the 'shrine' user to= perform these commands:
$ mysql -u shrine= -pdemouser
To create the 4 SHRINE databases, you will nee= d to run these commands within the MySQL prompt:
CREATE DATABASE ad= apterAuditDB; CREATE DATABASE qepAuditDB; CREATE DATABASE stewardDB; CREATE DATABASE shrine_query_history;
After creating these databases, you will need = to install schemas.
mysql -u shrine -p= demouser adapterAuditDB < shrine-setup/adapter/sql/adapterAuditDB-mysql.= ddl mysql -u shrine -pdemouser shrine_query_history < shrine-setup/adapter/s= ql/shrine_query_history-mysql.ddl mysql -u shrine -pdemouser shrine_query_history < shrine-setup/adapter/s= ql/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
Sign into MySQL as root and grant the shrine user full access again= to all of these databases and their tables:
$ mysql -u root MariaDB [(none)]> GRANT ALL privileges ON *.* TO 'shrine'@'localhost'; MariaDB [(none)]> FLUSH PRIVILEGES;
Install schemas for MS SQL Server, instead of schemas labeled with mysql= .sql, use schemas ending with mssql.sql from shrine-setup.zip:
To install oracle schemas load all of the SHRINE databases into one cent= ral schema: ShrineDB (use this name when you configure context.xml).
Once you have created the database, load all the schemas into it. Instea= d of schemas labeled with mysql.sql, load schemas ending with oracle.ddl.= p>
Specifically, for SHRINE release 3.2.1, there are four (4) ddl files tha= t you should load. These files are found within the shrine-setup.zip = archive file: