Red Hat Satellite engineering is moving the tracking of its product development work on Satellite to Red Hat Jira (issues.redhat.com). If you're a Red Hat customer, please continue to file support cases via the Red Hat customer portal. If you're not, please head to the "Satellite project" in Red Hat Jira and file new tickets here. Individual Bugzilla bugs will be migrated starting at the end of May. If you cannot log in to RH Jira, please consult article #7032570. That failing, please send an e-mail to the RH Jira admins at rh-issues@redhat.com to troubleshoot your issue as a user management inquiry. The email creates a ServiceNow ticket with Red Hat. Individual Bugzilla bugs that are migrated will be moved to status "CLOSED", resolution "MIGRATED", and set with "MigratedToJIRA" in "Keywords". The link to the successor Jira issue will be found under "Links", have a little "two-footprint" icon next to it, and direct you to the "Satellite project" in Red Hat Jira (issue links are of type "https://issues.redhat.com/browse/SAT-XXXX", where "X" is a digit). This same link will be available in a blue banner at the top of the page informing you that that bug has been migrated.
Bug 1719636 - Missing(ID: N) for Host_ids column in case of audit records for subscription updates
Summary: Missing(ID: N) for Host_ids column in case of audit records for subscription ...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: Audit Log
Version: 6.6.0
Hardware: x86_64
OS: Linux
unspecified
medium
Target Milestone: 6.7.0
Assignee: Kavita
QA Contact: Vladimír Sedmík
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2019-06-12 08:48 UTC by Vladimír Sedmík
Modified: 2020-04-14 13:25 UTC (History)
7 users (show)

Fixed In Version:
Doc Type: Known Issue
Doc Text:
If you edit the subscription information for hosts in Satellite, the hosts do not display in the audit records of the Satellite web UI. Instead of a list of hosts, the following error is displayed: "Missing(ID: 2)" in "Host ids" line.
Clone Of:
Environment:
Last Closed: 2020-04-14 13:24:36 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)
UI printscreen (116.18 KB, image/png)
2019-06-12 08:48 UTC, Vladimír Sedmík
no flags Details


Links
System ID Private Priority Status Summary Last Updated
Foreman Issue Tracker 27383 0 Normal Closed Missing(ID: N) for Host_ids column in case of audit records for subscription updates 2021-01-28 09:28:02 UTC
Red Hat Product Errata RHSA-2020:1454 0 None None None 2020-04-14 13:24:59 UTC

Description Vladimír Sedmík 2019-06-12 08:48:24 UTC
Created attachment 1579726 [details]
UI printscreen

Description of problem:
When I add or remove a subscription to a host and check the Monitor > Audits in the WebUI, the records are showing "Missing(ID: 2)" in "Host ids" line.

Version-Release number of selected component (if applicable):
satellite-6.6.0-5.beta.el7sat.noarch

How reproducible:
always

Steps to Reproduce:
1. Register a host to the Satellite
2. Go to Hosts > Content hosts > pick the host > tab Subscriptions > Add or Remove some subscription
3. Go to Monitor > Audits > check the latest log

Actual results:
"Missing(ID: 2)" shown in "Host ids" item

Expected results:
Valid value shown in "Host ids" item

Additional info:
See the attachment

Comment 3 Marek Hulan 2019-07-23 06:16:35 UTC
Kavita, does this ring a bell? It feels like we can't find the host object for some reason. I wonder if that could be caused by taxonomies, this audit does not have any location. But the user is apparentely an admin.

Comment 4 Kavita 2019-07-23 08:18:09 UTC
(In reply to Marek Hulan from comment #3)
> Kavita, does this ring a bell? It feels like we can't find the host object
> for some reason. I wonder if that could be caused by taxonomies, this audit
> does not have any location. But the user is apparentely an admin.

Hello Marek,

I had discussion with Vladimír about this BZ previously. This is not due to taxonomies.
There is no direct association between pool and hosts but there is 'hosts' method defined inside Glue::Candlepin::Pool.

To fix this BZ, I would need changes from this PR - https://github.com/theforeman/foreman/pull/6710 
which will allow me to add audit hook on pool side to get host records.

Creating an upstream issue for pool side changes which will get merge after this above PR

Comment 5 Kavita 2019-07-23 08:19:38 UTC
Created redmine issue https://projects.theforeman.org/issues/27383 from this bug

Comment 6 Mike McCune 2019-09-12 17:36:12 UTC
since this is merged upstream, moving to POST

Comment 10 errata-xmlrpc 2020-04-14 13:24:36 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHSA-2020:1454


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