Bug 231866

New Certificate System 7.3 channels have been added to revision # 113299 of
rhel-rhis-channels.csv.

Please push to QA for testing.

Any update on this bug? Matt commited the updated spreadsheet a week ago
and we cannot see the channels on QA yet.

Channels should now be on webqa.

Is this bug referring to " RHN Internal Support Tools"?  Please provide details
on where to look for the Certificate system.

We just checked on webqa and do not see the channels under
RHEL 4 ES i386 32bit
RHEL 4 AS i386 32bit

Both child channels do exist in the webqa db:

SQL> select id from rhnchannel where label = 'rhel-i386-as-4-rhcmsys-7.3';

        ID
----------
      7112

SQL> select label from rhnchannel where id = (select parent_channel from
rhnchannel where label = 'rhel-i386-as-4-rhcmsys-7.3');

LABEL
--------------------------------------------------------------------------------
rhel-i386-as-4

SQL> select id from rhnchannel where label = 'rhel-i386-es-4-rhcmsys-7.3';

        ID
----------
      7113

SQL> select label from rhnchannel where id = (select parent_channel from
rhnchannel where label = 'rhel-i386-es-4-rhcmsys-7.3');

LABEL
--------------------------------------------------------------------------------
rhel-i386-es-4

SQL> 


Furthermore, both channels live in the 'rhel-rhcmsys' channel family, so any sku
that provides that channel family should provide access to those channels.

What username are you using for rhn.webqa.redhat.com to test this with?

I used 'qa' to verify this. 

Created attachment 151782 [details]
screenshot shows that the channels are not visible to qa

webqa got refreshed yesterday, i may have to re-run the mappings.

Created attachment 152159 [details]
using qa against webqa as of 1:29pm April 10th

I suspect the channel got blown away by the webqa db refresh.  Channel has been
re-created, and I can see it with the qa account.

I'm able to see the following channels on webqa. Please make these channels
available in rhn production also.

Channel Name  	Packages  	Systems
Parent Channel Button Red Hat Enterprise Linux (v. 5 for 32-bit x86) 	2254 	13
Child Channel Red Hat Certificate System 7.3 (for RHEL 5 for x86) 	0 	0
Parent Channel Button Red Hat Enterprise Linux (v. 5 for 64-bit x86_64) 	2968 	5
Child Channel Red Hat Certificate System 7.3 (for RHEL 5 for 64-bit x86_64) 	0 	0
Parent Channel Button Red Hat Enterprise Linux AS (v. 4 for 32-bit x86) 	3654 	135
Child Channel Red Hat Certificate System 7.3 (for AS v. 4 for x86) 	0 	0
Parent Channel Button Red Hat Enterprise Linux AS (v. 4 for 64-bit AMD64/Intel
EM64T) 	4147 	51
Child Channel Red Hat Certificate System 7.3 (for AS v. 4 for AMD64/EM64T) 	0 	0
Parent Channel Button Red Hat Enterprise Linux ES (v. 4 for 32-bit x86) 	3654 	6
Child Channel Red Hat Certificate System 7.3 (for ES v. 4 for x86) 	0 	0
Parent Channel Button Red Hat Enterprise Linux ES (v. 4 for AMD64/Intel EM64T) 
4147 	3
Child Channel Red Hat Certificate System 7.3 (for ES v. 4 for AMD64/EM64T) 	0 	0
Parent Channel Button Solaris 9 	0 	0
Child Channel Red Hat Certificate System 7.3 (for Solaris 9) 	0 	0

Is this channel list available in rhn.production yet ?. We are planning to go
live next
week. Any help appreciated . thanks.

Please push to Production.

RT filed:  https://rt.corp.redhat.com/rt3/Ticket/Display.html?id=366273

Channels should now there in production:

SQL> select id from rhnchannel where label = 'rhel-i386-as-4-rhcmsys-7.3';

        ID
----------
      7088