Bug 636458

Summary:	install.pl doesn't offer select version of remote database, or doesn't make checks which version remote db is
Product:	Red Hat Satellite 5	Reporter:	Jiri Kastner <jkastner>
Component:	Installer	Assignee:	Jan Pazdziora (Red Hat) <jpazdziora>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Ondrej Cienciala <ociencia>
Severity:	medium	Docs Contact:
Priority:	low
Version:	540	CC:	cperry, jpazdziora, mkoci, mmraka, ociencia
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:	spacewalk-setup-1.3.9-1	Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2012-09-21 09:34:46 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:	819081

Description Jiri Kastner 2010-09-22 09:48:37 UTC

Description of problem:
install.pl doesn't offer select version of remote database, or doesn't make checks which version remote db is, so when installing against oracle 9g, installation fails in the middle.

Version-Release number of selected component (if applicable):
Satellite-5.4.0-RHEL5-re20100921.0-x86_64

How reproducible:


Steps to Reproduce:
1. run install.pl
2. enter credentials, sid and hostname of oracle 9g
3. installation starts and fails later
  
Actual results:

DB User? xxxxx
DB Password? 
DB SID? xxxxx   
DB hostname? xxxxx.com
DB port [1521]? 
DB protocol [TCP]? 



Expected results:

DB User? xxxxx
DB Password? 
DB SID? xxxxx   
DB hostname? xxxxx.com
DB port [1521]? 
DB protocol [TCP]? 
DB version [10g]? 11g

or

prints message that remote database is not supported and ask again for new id, sid and hostname.

Additional info:

Comment 2 Jan Pazdziora (Red Hat) 2010-12-14 12:35:00 UTC

Fixed in Spacewalk master, 8256bfe12bdb2be41dd4e6c0f71eb9d07826eae8.

We now check that the database we've test-connected to is version 10 or 11.

Comment 3 Jan Pazdziora (Red Hat) 2010-12-14 12:35:15 UTC

Taking, BTW.

Comment 4 Jan Pazdziora (Red Hat) 2010-12-14 13:06:18 UTC

Michael pointed out that we already have check for the Oracle version. What exactly does the "fails in the middle" mean?

Comment 5 Jiri Kastner 2010-12-14 13:45:20 UTC

when you are trying to installl sat 5.4.0 to oracle 9, db installation starts without warning and then stops somewhere in the middle with oracle error in log

Comment 6 Jan Pazdziora (Red Hat) 2010-12-14 13:56:04 UTC

(In reply to comment #5)
> when you are trying to installl sat 5.4.0 to oracle 9, db installation starts
> without warning and then stops somewhere in the middle with oracle error in log

Can you post / attach the error?

Comment 7 Jiri Kastner 2010-12-14 14:07:48 UTC

(In reply to comment #6)
> Can you post / attach the error?

no, as machine had lost in abyss of time

Comment 8 Jan Pazdziora (Red Hat) 2010-12-14 15:05:16 UTC

(In reply to comment #7)
> 
> no, as machine had lost in abyss of time

We will use this experience to remember to put the exact error message in the future directly to the bug report, shall we?

Comment 9 Jiri Kastner 2010-12-14 16:11:26 UTC

(In reply to comment #8)
> (In reply to comment #7)
> We will use this experience to remember to put the exact error message in the
> future directly to the bug report, shall we?

sure.... if i will not forget :)

Comment 10 Michael Mráka 2011-01-25 10:10:47 UTC

One more fix in spacewalk
commit d08ad13d1e746aa5b40b9c64755030254665cc68
    636458 - reuse db version check via dbms_utility.db_version()
        v$instance in not granted by default (on external dbs)

Comment 13 Clifford Perry 2012-09-21 09:34:46 UTC

This issue is resolved with the release of RHN Satellite 5.5. 

As of September 20th 2012, RHN Satellite 5.5 has been generally available. 

Release Notes and other 5.5 documentation can be found here:

 https://access.redhat.com/knowledge/docs/Red_Hat_Network_Satellite/

The associated Errata for the 5.5 release are:

5.5 Satellite GA Errata
 - http://rhn.redhat.com/errata/RHEA-2012-1296.html

5.5 Upgrade Errata
 - http://rhn.redhat.com/errata/RHEA-2012-1298.html

5.5 RHN Proxy GA Errata
 - http://rhn.redhat.com/errata/RHEA-2012-1297.html

5.5 RHN Tools GA Errata
 - http://rhn.redhat.com/errata/RHEA-2012-1299.html

Regards,
Clifford
- Engineering Manager, Satellite