INSERT INTO rhnChannelProduct (id, product, version, beta) VALUES (rhn_channelprod_id_seq.NEXTVAL, 'RHN Satellite', '5.4', 'N'); INSERT INTO rhnChannelProduct (id, product, version, beta) VALUES (rhn_channelprod_id_seq.NEXTVAL, 'RHN Proxy', '5.4', 'N'); UPDATE rhnChannel SET channel_product_id = (SELECT id FROM rhnChannelProduct WHERE product = 'RHN Satellite' AND version = '5.4') WHERE label like 'redhat-rhn-satellite-5.4-%-%-%' and label not like 'redhat-rhn-satellite-5.4-beta-%-%-%'; UPDATE rhnChannel SET channel_product_id = (SELECT id FROM rhnChannelProduct WHERE product = 'RHN Proxy' AND version = '5.4') WHERE label like 'redhat-rhn-proxy-5.4-%-%-%' and label not like 'redhat-rhn-proxy-5.4-beta-%-%-%'; Test Plan: Run the following two SQL queries: 1. SELECT * FROM rhnChannelProduct where product = 'RHN Satellite' and version = '5.4'; SELECT * FROM rhnChannelProduct where product = 'RHN Proxy' and version = '5.4'; each should have 1 row selected with a valid ID and BETA equal to 'N' 2. SELECT ID,LABEL,CHANNEL_PRODUCT_ID from rhnChannel WHERE label like 'redhat-rhn-satellite-5.4-%-%-%' and label not like 'redhat-rhn-satellite-5.4-beta-%-%-%'; SELECT ID,LABEL,CHANNEL_PRODUCT_ID from rhnChannel WHERE label like 'redhat-rhn-proxy-5.4-%-%-%' and label not like 'redhat-rhn-proxy-5.4-beta-%-%-%'; each should have 6 rows selected with a valid ID and CHANNEL_PRODUCT_ID equal to the ID value of the first test query.
This was blocking testing of BZ 636126 so I ran the INSERT and UPDATE statements in dev0. FYI.
Clean satellite: SQL> select * from rhnChannelProduct where version='5.4'; no rows selected # satellite-sync -c redhat-rhn-proxy-5.4-server-i386-5 --no-errata --no-packages --no-rpms --no-kickstarts 08:08:14 Red Hat Network Satellite - live synchronization .... Import complete: Begin time: Wed Oct 6 08:08:14 2010 End time: Wed Oct 6 08:08:57 2010 Elapsed: 0 hours, 0 minutes, 43 seconds [root@ibm-x3650-01 ~]# sqlplus rhnsat/rhnsat@rhnsat SQL> select * from rhnChannelProduct where version='5.4'; ID ---------- PRODUCT -------------------------------------------------------------------------------- VERSION B CREATED ---------------------------------------------------------------- - --------- MODIFIED --------- 2 proxy 5.4 N 06-OCT-10 06-OCT-10 SQL> SELECT ID,LABEL,CHANNEL_PRODUCT_ID from rhnChannel WHERE label like '%5.4%'; ID ---------- LABEL -------------------------------------------------------------------------------- CHANNEL_PRODUCT_ID ------------------ 103 redhat-rhn-proxy-5.4-server-i386-5 Satellite channels should not appear on satellite, so this can be tested only by activating satellite, which works.
The 5.4.0 RHN Satellite and RHN Proxy release has occurred. This issue has been resolved with this release. RHEA-2010:0801 - RHN Satellite Server 5.4.0 Upgrade https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10332 RHEA-2010:0803 - RHN Tools enhancement update https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10333 RHEA-2010:0802 - RHN Proxy Server 5.4.0 bug fix update https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10334 RHEA-2010:0800 - RHN Satellite Server 5.4.0 https://rhn.redhat.com/rhn/errata/details/Details.do?eid=10335 Docs are available: http://docs.redhat.com/docs/en-US/Red_Hat_Network_Satellite/index.html Regards, Clifford