Reports manager table structure?

Raja723 — Mon, 07 Oct 2019 06:24:26 GMT

Hi,

I have just downloaded the quickstart Cloudera VM and when I try to start all services it fails telling me that Service mgmt has 0 Reports Managers. Cloudera Management Service requires at least 1 Reports Manager.

I tried to configure Reports Manager by adding a Role instance for Reports Manager, however it requires me to give a databasename and a tablename. My question is what columns or table structure should I have for reports manager?

Thanks!

Re: Reports manager table structure?

lwang — Mon, 07 Oct 2019 18:45:59 GMT

Hi @Raja723 ,

Could you please share a screenshot for us to see which step you were asked to enter database name and table name?

Please use the Add a Role wizard to add the Reports Manager role. During the step, it should ask you the database host, database type, database name and username/password. As long as you specify the values correctly, the wizard should do a database connection and create the necessary tables in the database for you automatically.

Please make sure you follow the documentation to create the database first and make sure that CM server can make successful connection to the RMAN database.

Here is the documentation for Mysql:

https://docs.cloudera.com/documentation/enterprise/latest/topics/cm_ig_mysql.html#mysql_configure_cm_db

Thanks and hope this helps,

question Re: Reports manager table structure? in Support Questions

Reports manager table structure?

Re: Reports manager table structure?