Date: Fri, 29 Mar 2024 04:26:09 -0400 (EDT) Message-ID: <639715360.918.1711700769111@prodopencatalystconfluence.catalyst> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_917_579056895.1711700769108" ------=_Part_917_579056895.1711700769108 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Download shrine-setup.zip in temporary directory and unpack it.
wget https://repo= .open.catalyst.harvard.edu/nexus/content/groups/public/net/shrine/shrine-se= tup/3.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 d=
atabase: adapter/adapterAuditDB-update-brand.sql, adapter/shrine_query_hist=
ory-update-mysql.sql and qep/update-brand.sql . Run each of the appropriate=
scripts on your databases. For MariaDB run the following shell commands:
mysql -u shrine -= pYourPassword adapterAuditDB < /tmp/shrine-setup/adapter/sql/adapterAudi= tDB-update-mysql.sql mysql -u shrine -pYourPassword shrine_query_history < /tmp/shrine-setup/= adapter/sql/shrine_query_history-update-mysql.sql mysql -u shrine -pYourPassword qepAuditDB < /tmp/shrine-setup/qep/sql/up= date-mysql.sql
For MS SQL and Oracle, run the scripts appropriate for your databases.&n= bsp;
Increase the number of connections to mariadb from the default 151 to at= minimum 2049. In /etc/my.cnf add a max_connnections value.
[mysqld_safe] max_connections =3D 2049 |