Bug 535555 (RHQ-2238)

Summary: Database "test" in installer is not clean and can thus lead to confusion..
Product: [Other] RHQ Project Reporter: Corey Welton <cwelton>
Component: InstallerAssignee: RHQ Project Maintainer <rhq-maint>
Status: CLOSED CURRENTRELEASE QA Contact: Mike Foley <mfoley>
Severity: medium Docs Contact:
Priority: high    
Version: 1.3preCC: jshaughn
Target Milestone: ---Keywords: SubBug
Target Release: ---   
Hardware: All   
OS: All   
URL: http://jira.rhq-project.org/browse/RHQ-2238
Fixed In Version: 1.4 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-05-02 13:51:15 EDT Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---
Bug Depends On:    
Bug Blocks: 565628    

Description Corey Welton 2009-07-14 12:07:00 EDT
If user omits port # in database connection string, the test still "goes green" - but the install will fail with a particularly terse error message.  It appears that the test is assuming a port of 5432, but the install itself does not.  If user enters an otherwise invalid port #, such as "999", test will appropriately fail.  It only seems to assume a port of 5432 if none is specified.

Repro steps:
1. begin installation of server with the assumption that you'll be using an external postgres db., i.e., a db that is not on this box.
2. Replace the default Database Connection URL ("jdbc:postgresql://") with a string akin to "jdbc:postgresql://foobar.example.com/rhq".  Note that you have "forgotten" to replace the port #
3. Click the "Test Connection" button.
4. Noting that the test returns green, Choose to install (and/or overwrite/keep data, if applicable)
5. Submit.

Current results:
* Test goes green
* Install fails with a cryptic message:
 Could not save the settings for some reason.
Could not save the settings for some reason.

Expected results:
* Test should fail - test should use exact data as entered in the fields from install.  
* Error message should be useful.

Comment 1 John Mazzitelli 2009-07-14 12:15:53 EDT
what's the server log say? probably has more specific error messages.

Not putting a port in the URL is probably OK from the JDBC driver point of view - the JDBC driver itself will assume a default (in the postgres driver, it probably defaults to 5432) - in the similar manner that "http://host" will force browsers to default to port 80.
Comment 2 Red Hat Bugzilla 2009-11-10 16:00:34 EST
This bug was previously known as http://jira.rhq-project.org/browse/RHQ-2238
Comment 3 wes hayutin 2010-02-16 11:57:08 EST
Temporarily adding the keyword "SubBug" so we can be sure we have accounted for all the bugs.

new = Tracking + FutureFeature + SubBug
Comment 4 wes hayutin 2010-02-16 12:02:10 EST
making sure we're not missing any bugs in rhq_triage