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;