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
Set up the MySQL or MariaDB database by running the following
command:
CREATE USER rman IDENTIFIED BY '***password***';
CREATE DATABASE rman;
GRANT ALL ON rman.* TO rman;
PostgreSQL
Set up the PostgreSQL database by running the following
command:
CREATE DATABASE rman;
CREATE USER rman WITH PASSWORD '***password***';
GRANT ALL ON DATABASE rman TO rman;
Oracle (container example)
Set up the Oracle database by running the following commands:
- Log into the container database using
SQL*Plus
sqlplus system/ as sysdba
- Create a pluggable
database:
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
database:
ALTER SESSION SET CONTAINER = rmanpdb; ALTER DATABASE OPEN; CREATE USER rman IDENTIFIED BY ***user password***; GRANT ALL PRIVILEGES TO rman;