Description of problem: The user configured on the Infrastructure provider RHEV has to have SUPERUSER privileges set on the RHEV postgres database. From the documentation the example provided to create the user for C & U: postgres=# CREATE ROLE cfme LOGIN UNENCRYPTED PASSWORD 'smartvm' SUPERUSER VALID UNTIL 'infinity'; Version-Release number of selected component (if applicable): How reproducible: Creating a user without SUPERUSER privileges won't allow C & U data to be collected. Steps to Reproduce: 1. 2. 3. Actual results: Expected results: Additional info:
This not the proper way to collect C&U. I would expect the admin to create a non superuser for CFME by running: create role xxx with login encrypted password 'password'; And grant read only access to tables and views: SELECT 'GRANT SELECT ON ' || relname || ' TO xxx;' FROM pg_class JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace WHERE nspname = 'public' AND relkind IN ('r', 'v', 'S'); I suggest closing this bug.
HiHo, the official documentation suggests that the user has to be superuser: https://access.redhat.com/documentation/en-US/Red_Hat_CloudForms/3.2/html-single/Insight_Guide/index.html#Notes_on_Capacity_and_Utilization_Collection_for_RHEVM_3.1 Are you saying, it's actually a documentation bug? Regards, Christian
(In reply to Christian Jung from comment #3) > HiHo, > the official documentation suggests that the user has to be superuser: > https://access.redhat.com/documentation/en-US/Red_Hat_CloudForms/3.2/html- > single/Insight_Guide/index. > html#Notes_on_Capacity_and_Utilization_Collection_for_RHEVM_3.1 > > Are you saying, it's actually a documentation bug? > > Regards, > Christian Yes, I see no reason for CFME to need to be able to write to the DWH database.
Can you update/reassign this bug if necessary?
I'm from the RHEV team, so don't know the process. Andrew, can you help with this?
Hi Yaniv, From the looks of it, this is a documentation bug for at least the 3.2 version of the CFME documentation. My suggestion is that we move this over to CFME under the 'Documentation' component and take care of it there. Would this be alright? Kind regards, Andrew
Sounds good, done.
Hi Yaniv, Thanks for moving this over - received! Kind regards, Andrew
Assigning to Suyog for review.