Bug 463446

Summary: rhn-schema-version returns nothing.
Product: Red Hat Satellite 5 Reporter: Justin Sherrill <jsherril>
Component: OtherAssignee: Milan Zázrivec <mzazrivec>
Status: CLOSED CURRENTRELEASE QA Contact: Sayli Karmarkar <skarmark>
Severity: medium Docs Contact:
Priority: medium    
Version: 530CC: cperry, jbrownin, mzazrivec
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: sat530 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2009-09-10 18:53:08 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: 463876    

Description Justin Sherrill 2008-09-23 14:53:55 UTC
After installing satellite 5.3, running rhn-schema-version returns nothing:

[root@dhcp231-174 ~]# rhn-schema-version 
[root@dhcp231-174 ~]# 


from iso Satellite-5.3.0-RHEL5-re20080919.1-i386-embedded-oracle.iso

Comment 1 Milan Zázrivec 2008-09-23 15:22:59 UTC
This should do it:

--- ./rhn-schema-version
+++ ./rhn-schema-version
@@ -95,7 +95,7 @@
                 SELECT PE.evr.as_vre_simple()
                   FROM rhnPackageEVR PE, rhnVersionInfo RVI
                  WHERE RVI.label = 'schema'
-                   AND RVI.name_id = lookup_package_name('rhn-satellite-schema')
+                   AND RVI.name_id = lookup_package_name('spacewalk-schema')
                    AND RVI.evr_id = PE.id
                 """)
         h.execute()

Comment 2 Milan Zázrivec 2009-01-21 10:02:55 UTC
Fixed in spacewalk.git 1df3c73cc20bc5b410420d151a14a0ac2855f665

Comment 3 Sayli Karmarkar 2009-02-05 18:18:03 UTC
Verified with Satellite-5.3.0-RHEL5-re20090203.0-i386-embedded-oracle.iso.

[root@rlx-2-08 network]# rhn-schema-version 
5.3.0.9-3.el5sat

~SayliK

Comment 4 Jeff Browning 2009-08-09 18:02:01 UTC
[root@dhcp77-153 ~]# rhn-schema-version
5.3.0.23-1.el5sat

Comment 5 Brandon Perkins 2009-09-10 18:53:08 UTC
An advisory has been issued which should help the problem
described in this bug report. This report is therefore being
closed with a resolution of ERRATA. For more information
on therefore solution and/or where to find the updated files,
please follow the link below. You may reopen this bug report
if the solution does not work for you.

http://rhn.redhat.com/errata/RHEA-2009-1434.html