Description of problem: child shared channels of private parent channels are not available for activation key child channels. Version-Release number of selected component (if applicable): Satellite-5.3.0-RHEL5-re20090323.0-i386-embedded-oracle.iso How reproducible: Steps to Reproduce: 1.create 2 orgs org1 & org2 with trust. 2.create a shared child channel as the child of Rhel channel (rhel4 or rhel5) in org1 3.in org2 create an activation key. 4.naviagate to the child channel tab for the activation key. 5. browse to see the shares child channel from above. Actual results: the shared channels that are child channel of private parent channels are not available for selection in child channel list. Expected results: should be able to child shared channels of redhat channels from activation keys. Additional info:
*** This bug has been marked as a duplicate of bug 480674 ***
I am reopening this one, as this is still an issue with Satellite-5.3.0-RHEL5-re20090420.0-i386-embedded-oracle.iso
looks like the java stack was fixed but perl stack was not
modified perl query to use rhnSharedChannelView vs rhnChannel. keep in mind you will need to make sure you choose a base channel that has the shared channel in it.
i need to look at this again, moving back to assigned.
when verifying this bugzilla, we need to ensure that the following scenario is still functioning properly: 1. clone an x86_64 base channel 2. clone an i386 channel as a child of the channel in 1 3. create an activation key that uses the channel in 1 as the base channel 4. update the activation key to include the child channel included in 2 with the initial fix, for step 4 the child channel wasn't listed as a channel for selection; however, it should be and it should be selectable.
query needed an left outer join between rhnChannel and rhnSharedChannelView
mass move to onqa
fails_qa Satellite-5.3.0-RHEL5-re20090529.0-i386-embedded-oracle.iso Steps to Reproduce: 1.create 2 orgs org1 & org2 with trust. 2.create a shared child channel as the child of Rhel channel (rhel4 or rhel5) in org1 3.in org2 create an activation key. 4.naviagate to the child channel tab for the activation key. 5. browse to see the shares child channel from above.
rlx-3-24 satellite. I have a channel named child-channel-rhel-pub as a public channel and is a child of the rhel-4 channel in pt-org1. Now login as pt-org2 if you navigate to channel-> My shared channel the you expand the no access to parent channel entry you can see that child-channel-rhel-pub is a shred channel from org pt-org1. Now navigate to systems->activation key. click on key-492588 that is created with the redhat rhel4 channel as the base channel. Navigate to the child channel tab. see that only the rhel4 tools channel is available for selection. child-channel-rhel-pub is not available.
The problem is in the rhnSharedChannelTreeView. This view only shows the tree of shared channels. In this case, the parent channel is a non-shared Red Hat channel so It was omitted from the tree. The fix is to change the join in the 2nd part of the union so that the parent channel information comes from the rhnChannel table instead of joining rhnSharedChannelView to itself. f91358408ef1528f8298544188eabf3bff649509
(In reply to comment #12) > The problem is in the rhnSharedChannelTreeView. This view only shows the tree > of shared channels. In this case, the parent channel is a non-shared Red Hat > channel so It was omitted from the tree. The fix is to change the join in the > 2nd part of the union so that the parent channel information comes from the > rhnChannel table instead of joining rhnSharedChannelView to itself. > > f91358408ef1528f8298544188eabf3bff649509 Schema upgrade script 190-rhnSharedChannelTreeView.sql from the commit above should have gone into spacewalk-schema-0.5-to-spacewalk-schema-0.6 directory, not spacewalk-0.4-spacewalk-0.5.
(In reply to comment #13) > (In reply to comment #12) > > The problem is in the rhnSharedChannelTreeView. This view only shows the tree > > of shared channels. In this case, the parent channel is a non-shared Red Hat > > channel so It was omitted from the tree. The fix is to change the join in the > > 2nd part of the union so that the parent channel information comes from the > > rhnChannel table instead of joining rhnSharedChannelView to itself. > > > > f91358408ef1528f8298544188eabf3bff649509 > > Schema upgrade script 190-rhnSharedChannelTreeView.sql from the commit above > should have gone into spacewalk-schema-0.5-to-spacewalk-schema-0.6 > directory, not spacewalk-0.4-spacewalk-0.5. Moved upgrade script to spacewalk-schema-0.5-to-spacewalk-schema-0.6/. 15ef0361b300e8b8e30aa54ce03caa67cfe5271d Milan, good catch! Thanks!
verified 6/12.1
verified in stage.
An advisory has been issued which should help the problem described in this bug report. This report is therefore being closed with a resolution of ERRATA. For more information on therefore solution and/or where to find the updated files, please follow the link below. You may reopen this bug report if the solution does not work for you. http://rhn.redhat.com/errata/RHEA-2009-1434.html