Page History
...
Code Block | ||||
---|---|---|---|---|
| ||||
mysql -u shrine -pdemouser adapterAuditDB < shrine-setup/adapter/sql/adapterAuditDB-mysql.ddl
mysql -u shrine -pdemouser shrine_query_history < shrine-setup/adapter/sql/shrine_query_history-mysql.ddl
mysql -u shrine -pdemouser stewardDB < shrine-setup/dsa/sql/mysql.ddl
mysql -u shrine -pdemouser qepAuditDB < shrine-setup/qep/sql/mysql.ddl
mysql -u shrine -pdemouser qepAuditDB < shrine-setup/qep/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:
Code Block | ||||
---|---|---|---|---|
| ||||
$ mysql -u root
MariaDB [(none)]> GRANT ALL privileges ON *.* TO 'shrine'@'localhost';
MariaDB [(none)]> FLUSH PRIVILEGES; |
MS SQL Server
Install schemas for MS SQL Server, instead of schemas labeled with mysql.sql, use schemas ending with mssql.sql from shrine-setup.zip:
- ./dsa/sql/mssql.ddl
- ./qep/sql/mssql.ddl
- ./qep/sql/mssql-update.ddl
- ./adapter/sql/adapterAuditDB-mssql.ddl
- ./adapter/sql/shrine_query_history-mssql.ddl
...
Specifically, for SHRINE release 3.0.0, there are four (4) ddl files that you should load. These files are found within the shrine-setup.zip archive file:
- ./dsa/sql/oracle.ddl
- ./qep/sql/oracle.ddl
- ./qep/sql/oracle-update.ddl
- ./adapter/sql/adapterAuditDB-oracle.ddl
- ./adapter/sql/shrine_query_history-oracle.ddl
...
Overview
Content Tools