The hub requires a few extra tables in the qepAuditDB database.
mysql -u shrine -pdemouser qepAuditDB < shrine-setup/hub/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; 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:
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: