Setting up the database for Reports Manager
Reports Manager uses a relational database for storing preferences such as the type of directories that are selected to be included in reports and data to be displayed on the reports themselves. You must set up this database manually before adding the Reports Manager role.
Cloudera recommends that you set up the database on the same host where you are planning to add the Reports Manager role.
Before adding the first cluster, ensure you set up the database for Reports Manager on a new Cloudera Manager deployment.
Perform the following steps for setting up the database for Reports Manager.
The exact parameters and SQL are dependent on the database environment.
MySQL or MariaDB
CREATE USER rman IDENTIFIED BY '***password***'; CREATE DATABASE rman; GRANT ALL ON rman.* TO rman;
CREATE DATABASE rman; CREATE USER rman WITH PASSWORD '***password***'; GRANT ALL ON DATABASE rman TO rman;
Oracle (container example)
- Log into the container database using
sqlplus system/ as sysdba
- Create a pluggable
CREATE PLUGGABLE DATABASE rmanpdb ADMIN USER rmanpdbadmin IDENTIFIED BY ***admin password*** FILE_NAME_CONVERT = ('/opt/oracle/oradata/ORCLCDB/pdbseed', '/opt/oracle/oradata/ORCLCDB/rmanpdb');
- Create a user in the pluggable
ALTER SESSION SET CONTAINER = rmanpdb; ALTER DATABASE OPEN; CREATE USER rman IDENTIFIED BY ***user password***; GRANT ALL PRIVILEGES TO rman;