Bug 1954043

Summary: Subscriptions and Pools can be associated across organizations
Product: Red Hat Satellite Reporter: Jonathon Turel <jturel>
Component: Subscription ManagementAssignee: Jonathon Turel <jturel>
Status: CLOSED ERRATA QA Contact: Cole Higgins <chiggins>
Severity: high Docs Contact:
Priority: unspecified    
Version: 6.9.0CC: egolov, ehelms, mmccune
Target Milestone: 6.10.0Keywords: Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: tfm-rubygem-katello-4.1.0-0.1.rc2 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2021-11-16 14:10:44 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
tfm-rubygem-katello-3.14.0.32-2.HFRHBZ1954043.el7sat.noarch.rpm none

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-3.14.0.32-2.HFRHBZ1954043.el7sat.noarch.rpm from this bugzilla to your Satellite

2) stop services:

satellite-maintain service stop

3) Install:

rpm -Uvh tfm-rubygem-katello-3.14.0.32-2.HFRHBZ1954043.el7sat.noarch.rpm

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]
tfm-rubygem-katello-3.14.0.32-2.HFRHBZ1954043.el7sat.noarch.rpm

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.

https://access.redhat.com/errata/RHSA-2021:4702