Bug 1365913
| Summary: | Satellite5.6: support more than 13 chars for CVE names | ||
|---|---|---|---|
| Product: | Red Hat Satellite 5 | Reporter: | Tomas Lestach <tlestach> |
| Component: | Server | Assignee: | Tomáš Kašpárek <tkasparek> |
| Status: | CLOSED ERRATA | QA Contact: | Lukáš Hellebrandt <lhellebr> |
| Severity: | unspecified | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 560 | CC: | cperry, ggainey, jdostal, jhutar, lhellebr, tlestach |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | satellite-schema-5.6.0.31 | Doc Type: | If docs needed, set a value |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2016-09-14 12:05:17 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
So, looking at the upstream code, this has been achieved by at least following three commits ... spacewalk.git: 7ebe3a7d542c171af11eb819cd50ca86507a674f dcb0e7fda6f79c2c2affee1c21c2a3244797ded7 e4adb41def454502abcf69e99e49192aab8f766d Moving to MODIFIED as the fix is available in upstream. Verified with both satellite-schema-5.6.0.31 and the pre-erratum satellite-schema-5.6.0.29.
After consulting with jdobes and ggainey, it turns out this was never an issue - the problem was on Hosted. The fix in the last commit added is just formal.
Steps taken to verify:
* Sync erratum with CVE longer than 13 chars, check the whole CVE name is present in the Satellite.
* Migrate the satellite to Managed DB from Embedded DB, do the same check.
* Verify that the constant 13 in /etc/sysconfig/rhn/schema-upgrade/satellite-schema-5.6.0.17-to-satellite-schema-5.6.0.18/001-rhnCVE-update.sql.{postgresql,oracle} is changed to 20.
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, 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://rhn.redhat.com/errata/RHBA-2016-1866.html |
Description of problem: I see Satellite 5.6 still supports only 13 chars for CVE names. [satellite] (SATELLITE-5.7)$ git diff SATELLITE-5.6 schema/spacewalk/common/tables/rhnCVE.sql diff --git a/schema/spacewalk/common/tables/rhnCVE.sql b/schema/spacewalk/common/tables/rhnCVE.sql index 1056841..8a87c30 100644 --- a/schema/spacewalk/common/tables/rhnCVE.sql +++ b/schema/spacewalk/common/tables/rhnCVE.sql @@ -19,7 +19,7 @@ CREATE TABLE rhnCVE id NUMBER NOT NULL CONSTRAINT rhn_cve_id_pk PRIMARY KEY USING INDEX TABLESPACE [[2m_tbs]], - name VARCHAR2(13) NOT NULL + name VARCHAR2(20) NOT NULL ) ENABLE ROW MOVEMENT ; Version-Release number of selected component (if applicable): Sat 5.6 How reproducible: always Steps to Reproduce: 1. Create an erratum with CVE longer than 13 chars