Note: This is a beta release of Red Hat Bugzilla 5.0. The data contained within is a snapshot of the live data so any changes you make will not be reflected in the production Bugzilla. Also email is disabled so feel free to test any aspect of the site that you want. File any problems you find or give feedback here.
Bug 1688722 - insufficient priviledges granted to vm_device_history when enabling rhevm datastore access to cloudforms following cfme documentation
Summary: insufficient priviledges granted to vm_device_history when enabling rhevm dat...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat CloudForms Management Engine
Classification: Red Hat
Component: Documentation
Version: 5.8.5
Hardware: All
OS: All
medium
high
Target Milestone: GA
: 5.11.0
Assignee: Suyog Sainkar
QA Contact: Red Hat CloudForms Documentation
Red Hat CloudForms Documentation
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2019-03-14 10:17 UTC by Felix Dewaleyne
Modified: 2019-04-12 16:21 UTC (History)
5 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2019-04-12 16:21:43 UTC
Category: ---
Cloudforms Team: Documentation
Target Upstream Version:


Attachments (Terms of Use)


Links
System ID Priority Status Summary Last Updated
Red Hat Bugzilla 1459342 None CLOSED Documentation for adding database access to RHV for C&U doesn't seem to provide sufficient access 2019-04-12 15:01:04 UTC

Description Felix Dewaleyne 2019-03-14 10:17:04 UTC
Document URL: 
https://access.redhat.com/documentation/en-us/red_hat_cloudforms/4.5/html-single/deployment_planning_guide/#data_collection_for_rhev_4.x

Section Number and Name: 
data collection for rhev 4.x

Describe the issue: 
the commands listed do not give enough permissoins to vm_device_history

Suggestions for improvement: 
new commands need to be researched to grant those permissions in a better way

Additional information: 
results of following the commands in customer environment :


[----] I, [2019-03-14T09:32:46.171118 #5797:6f3114]  INFO -- : MIQ(MiqQueue#delivered) Message id: [1000052685780], State: [error], Delivered in [0.029256931] seconds
[----] E, [2019-03-14T09:32:46.173938 #5778:6f3114] ERROR -- : MIQ(ManageIQ::Providers::Redhat::InfraManager::MetricsCapture#perf_collect_metrics) [realtime] for: [ManageIQ::Providers::Redhat::InfraManager::Vm], [1000000000656], [rhvm.rhev.pekao.com.pl] Unhandled exception during perf data collection: [PG::InsufficientPrivilege: ERROR:  permission denied for relation vm_device_history
[----] E, [2019-03-14T09:32:46.174074 #5778:6f3114] ERROR -- : MIQ(ManageIQ::Providers::Redhat::InfraManager::MetricsCapture#perf_collect_metrics) [realtime] for: [ManageIQ::Providers::Redhat::InfraManager::Vm], [1000000000656], [rhvm.rhev.pekao.com.pl]   Timings at time of error: {:capture_state=>0.0015130043029785156, :rhevm_connect=>0.0020542144775390625, :collect_data=>0.018987178802490234}
[----] E, [2019-03-14T09:32:46.174176 #5778:6f3114] ERROR -- : [ActiveRecord::StatementInvalid]: PG::InsufficientPrivilege: ERROR:  permission denied for relation vm_device_history
[----] E, [2019-03-14T09:32:46.174224 #5778:6f3114] ERROR -- : /opt/rh/cfme-gemset/gems/ovirt_metrics-2.0.0/lib/active_record/connection_adapters/ovirt_legacy_postgresql_adapter.rb:611:in `async_exec'
[----] E, [2019-03-14T09:32:46.174376 #5778:6f3114] ERROR -- : MIQ(MiqQueue#deliver) Message id: [1000052685781], Error: [PG::InsufficientPrivilege: ERROR:  permission denied for relation vm_device_history
[----] E, [2019-03-14T09:32:46.174501 #5778:6f3114] ERROR -- : [ActiveRecord::StatementInvalid]: PG::InsufficientPrivilege: ERROR:  permission denied for relation vm_device_history
[----] E, [2019-03-14T09:32:46.174551 #5778:6f3114] ERROR -- : /opt/rh/cfme-gemset/gems/ovirt_metrics-2.0.0/lib/active_record/connection_adapters/ovirt_legacy_postgresql_adapter.rb:611:in `async_exec'
[----] I, [2019-03-14T09:32:46.174630 #5778:6f3114]  INFO -- : MIQ(MiqQueue#delivered) Message id: [1000052685781], State: [error], Delivered in [0.029195134] seconds
[----] E, [2019-03-14T09:32:46.178675 #5806:6f3114] ERROR -- : MIQ(ManageIQ::Providers::Redhat::InfraManager::MetricsCapture#perf_collect_metrics) [realtime] for: [ManageIQ::Providers::Redhat::InfraManager::Vm], [1000000000260], [bikmqt] Unhandled exception during perf data collection: [PG::InsufficientPrivilege: ERROR:  permission denied for relation vm_device_history
[----] E, [2019-03-14T09:32:46.178762 #5806:6f3114] ERROR -- : MIQ(ManageIQ::Providers::Redhat::InfraManager::MetricsCapture#perf_collect_metrics) [realtime] for: [ManageIQ::Providers::Redhat::InfraManager::Vm], [1000000000260], [bikmqt]   Timings at time of error: {:capture_state=>0.0017080307006835938, :rhevm_connect=>0.00235748291015625, :collect_data=>0.021016836166381836}
[----] E, [2019-03-14T09:32:46.178879 #5806:6f3114] ERROR -- : [ActiveRecord::StatementInvalid]: PG::InsufficientPrivilege: ERROR:  permission denied for relation vm_device_history
[----] E, [2019-03-14T09:32:46.178925 #5806:6f3114] ERROR -- : /opt/rh/cfme-gemset/gems/ovirt_metrics-2.0.0/lib/active_record/connection_adapters/ovirt_legacy_postgresql_adapter.rb:611:in `async_exec'
[----] E, [2019-03-14T09:32:46.179031 #5806:6f3114] ERROR -- : MIQ(MiqQueue#deliver) Message id: [1000052685782], Error: [PG::InsufficientPrivilege: ERROR:  permission denied for relation vm_device_history
[----] E, [2019-03-14T09:32:46.179117 #5806:6f3114] ERROR -- : [ActiveRecord::StatementInvalid]: PG::InsufficientPrivilege: ERROR:  permission denied for relation vm_device_history
[----] E, [2019-03-14T09:32:46.179157 #5806:6f3114] ERROR -- : /opt/rh/cfme-gemset/gems/ovirt_metrics-2.0.0/lib/active_record/connection_adapters/ovirt_legacy_postgresql_adapter.rb:611:in `async_exec'
[----] I, [2019-03-14T09:32:46.179229 #5806:6f3114]  INFO -- : MIQ(MiqQueue#delivered) Message id: [1000052685782], State: [error], Delivered in [0.032587252] seconds

the document is virtually unchanged and the same for all the latest versions, meaning this issue likely still exists.
I do not have the version of rhev in use at this date and am waiting for it to add it to this case.

Comment 2 Felix Dewaleyne 2019-03-14 10:22:21 UTC
adding the bugzilla https://bugzilla.redhat.com/show_bug.cgi?id=1459342 to this. I don't see that other one having an update to confirm the changes made it to the documentation.

Comment 6 Suyog Sainkar 2019-04-12 16:19:01 UTC
Thanks Felix!

PR merged, and doc republished on the customer portal:

https://access.redhat.com/documentation/en-us/red_hat_cloudforms/4.7/html/deployment_planning_guide/capacity_planning#data_collection_for_rhev_4.x


Note You need to log in before you can comment on or make changes to this bug.