The hub requires a few extra tables in the qepAuditDB database.

MariaDB

mysql -u shrine -pdemouser qepAuditDB < shrine-setup/hub/sql/mysql.ddl
mysql -u shrine -pdemouser qepAuditDB < shrine-setup/hub/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:

$ mysql -u root
MariaDB [(none)]> GRANT ALL privileges ON *.* TO 'shrine'@'localhost';
MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> \q

MS SQL Server

To install the hub schema for MS SQL Server use schemas starting with mssql.sql from shrine-setup.zip:

  • ./hub/sql/mssql.ddl

Oracle

Install oracle schemas load all of the SHRINE databases into one central schema: ShrineDB (use this name when you configure context.xml).

Load the hub schema into your database:

  • ./hub/sql/oracle.ddl
  • No labels