Bug 636090
| Summary: | Add Satellite and Proxy in rhnChannelProduct table | |||
|---|---|---|---|---|
| Product: | Red Hat Satellite 5 | Reporter: | Shannon Hughes <shughes> | |
| Component: | Release | Assignee: | Jan Blazek <jblazek> | |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Miroslav Suchý <msuchy> | |
| Severity: | medium | Docs Contact: | ||
| Priority: | low | |||
| Version: | 540 | CC: | cperry, jhutar, msuchy, slukasik | |
| Target Milestone: | --- | |||
| Target Release: | --- | |||
| Hardware: | All | |||
| OS: | Linux | |||
| Whiteboard: | Fixed in the 5.4.0 Release - GA'd 2010-10-27 | |||
| Fixed In Version: | Doc Type: | Bug Fix | ||
| Doc Text: | Story Points: | --- | ||
| Clone Of: | ||||
| : | 640269 (view as bug list) | Environment: | ||
| Last Closed: | 2010-10-28 15:02:30 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: | ||||
| Bug Depends On: | ||||
| Bug Blocks: | 487678, 636840, 640269 | |||
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 |
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.