Bug 1954043 - Subscriptions and Pools can be associated across organizations
Summary: Subscriptions and Pools can be associated across organizations
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: Subscription Management
Version: 6.9.0
Hardware: Unspecified
OS: Unspecified
high vote
Target Milestone: 6.10.0
Assignee: Jonathon Turel
QA Contact: Cole Higgins
Depends On:
TreeView+ depends on / blocked
Reported: 2021-04-27 13:53 UTC by Jonathon Turel
Modified: 2021-11-16 14:10 UTC (History)
3 users (show)

Fixed In Version: tfm-rubygem-katello-4.1.0-0.1.rc2
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Last Closed: 2021-11-16 14:10:44 UTC
Target Upstream Version:

Attachments (Terms of Use)
tfm-rubygem-katello- (10.87 MB, application/x-rpm)
2021-05-04 21:25 UTC, Mike McCune
no flags Details

System ID Private Priority Status Summary Last Updated
Foreman Issue Tracker 32334 0 Normal Closed Subscriptions and Pools can be associated across organizations 2021-04-27 13:53:45 UTC
Red Hat Product Errata RHSA-2021:4702 0 None None None 2021-11-16 14:10:50 UTC

Description Jonathon Turel 2021-04-27 13:53:44 UTC
There is no validation between the organizations assigned to Pools and Subscriptions which can lead to data integrity problems.

Comment 1 Jonathon Turel 2021-04-27 13:53:48 UTC
Created from redmine issue https://projects.theforeman.org/issues/32334

Comment 2 Jonathon Turel 2021-04-27 13:53:50 UTC
Upstream bug assigned to jturel

Comment 4 Mike McCune 2021-05-04 21:24:41 UTC
*** Satellite 6.7.5 Hotfix Available ***

1) Download tfm-rubygem-katello- from this bugzilla to your Satellite

2) stop services:

satellite-maintain service stop

3) Install:

rpm -Uvh tfm-rubygem-katello-

4) restart and enable maintenance mode:

satellite-maintain service start
satellite-maintain maintenance-mode start

5) migrate the database:

foreman-rake db:migrate

6) run the rake task to correct invalid pools
# foreman-rake katello:upgrades:4.1:fix_invalid_pools
I, [2021-05-04T17:24:04.518830 #1405]  INFO -- : Corrected 0 invalid pools
I, [2021-05-04T17:24:04.518872 #1405]  INFO -- : Removed 0 orphaned pools

7) Disable maintenance mode and resume operations

satellite-maintain maintenance-mode stop

Comment 5 Mike McCune 2021-05-04 21:25:15 UTC
Created attachment 1779569 [details]

Comment 10 errata-xmlrpc 2021-11-16 14:10:44 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 (Moderate: Satellite 6.10 Release), and where to find the updated
files, follow the link below.

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


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