Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 665775

Summary: The data in rhnpackagefile.verifyflags are signed
Product: Red Hat Satellite 5 Reporter: Jan Pazdziora (Red Hat) <jpazdziora>
Component: ServerAssignee: Michael Mráka <mmraka>
Status: CLOSED DEFERRED QA Contact: Red Hat Satellite QA List <satqe-list>
Severity: medium Docs Contact:
Priority: high    
Version: 540CC: cperry, jpazdziora, psklenar
Target Milestone: ---Keywords: Reopened
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: 619083 Environment:
Last Closed: 2014-07-04 13:29:25 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: 462714    

Description Jan Pazdziora (Red Hat) 2010-12-26 22:20:07 UTC 
While investigating bug 619083, I've come across rhnpackagefile.verifyflags. On my Satellite 5.4.0 (upgraded from at least 5.3), the values are:

--- Additional comment from jpazdziora on 2010-12-26 17:00:53 EST ---

By the way, on my Satellite 5.4 (RHEL 5 obviously), the following select returns mostly negative values:

SQL> select VERIFYFLAGS, count(*) from rhnpackagefile group by VERIFYFLAGS ;

VERIFYFLAGS   COUNT(*)
----------- ----------
	-40	 93987
       -116	 55068
       -100	    84
	-36	 66689
	-60	    13
	 -1   17756599
	  3	   186
       -256	    34
	  0	995705
	-33   10644826
       -104	   134
	 -5	   600

12 rows selected.

SQL> 

That probably is not correct, is it?

I believe the data should be positive, as this is what we will get with python 2.6 on Fedora 13 (and likely on RHEL 6). Of course, we need to figure out if we actually use the data for something.

If we do, we might want to fix our importing/pushing/syncing code to properly store unsigned values, add tests for this situation, and upgrade existing data to be unsigned.
Comment 1 Jan Pazdziora (Red Hat) 2010-12-26 22:21:30 UTC 
Assigning to Michael for investigation / opinion.