Bug 810281

Summary: engine-setup stops in case remote db connection fails instead of asking db details again
Product: [Retired] oVirt Reporter: Rami Vaknin <rvaknin>
Component: ovirt-engine-installerAssignee: Alex Lourie <alourie>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: medium Docs Contact:
Priority: unspecified    
Version: unspecifiedCC: acathrow, dyasny, iheim, mgoldboi, oschreib, yeylon, ykaul
Target Milestone: ---   
Target Release: 3.1   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2012-08-09 07:56:26 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:

Description Rami Vaknin 2012-04-05 14:13:58 UTC
Scenario:
I gave a wrong user name and the engine-setup wizard failed and got out instead of asking the user for the remote db details again.

2012-04-05 20:04:02::DEBUG::common_utils::420::root:: Found IP Address: 10.35.97.68
2012-04-05 20:04:02::INFO::engine_validators::384::root:: Trying to connect to the remote database with provided credentials.
2012-04-05 20:04:02::DEBUG::common_utils::337::root:: running sql query 'select 1' on db server: 'rami-fed16-db.qa.lab.tlv.redhat.com'.
2012-04-05 20:04:02::DEBUG::common_utils::273::root:: cmd = /usr/bin/psql -h rami-fed16-db.qa.lab.tlv.redhat.com -p 65432 -U ramivb -d postgres -c "select 1"
2012-04-05 20:04:02::DEBUG::common_utils::278::root:: output = 
2012-04-05 20:04:02::DEBUG::common_utils::279::root:: stderr = psql: FATAL:  role "ramivb" does not exist

2012-04-05 20:04:02::DEBUG::common_utils::280::root:: retcode = 2
2012-04-05 20:04:02::ERROR::engine_validators::390::root:: Could not connect to host rami-fed16-db.qa.lab.tlv.redhat.com with provided credentials. Check that your settings are correct.
2012-04-05 20:04:02::DEBUG::common_utils::337::root:: running sql query 'DROP DATABASE IF EXISTS ovirt_engine_test;' on db server: 'rami-fed16-db.qa.lab.tlv.redhat.com'.
2012-04-05 20:04:02::DEBUG::common_utils::273::root:: cmd = /usr/bin/psql -h rami-fed16-db.qa.lab.tlv.redhat.com -p 65432 -U ramivb -d postgres -c "DROP DATABASE IF EXISTS ovirt_engine_test;"
2012-04-05 20:04:02::DEBUG::common_utils::278::root:: output = 
2012-04-05 20:04:02::DEBUG::common_utils::279::root:: stderr = psql: FATAL:  role "ramivb" does not exist

2012-04-05 20:04:02::DEBUG::common_utils::280::root:: retcode = 2
2012-04-05 20:04:02::ERROR::engine-setup::1632::root:: Traceback (most recent call last):
  File "/usr/bin/engine-setup", line 1610, in _handleInteractiveParams
    postConditionValue = _getConditionValue(group.getKey("POST_CONDITION"))
  File "/usr/bin/engine-setup", line 1649, in _getConditionValue
    returnValue = matchMember(controller.CONF)
  File "/usr/share/ovirt-engine/scripts/engine_validators.py", line 269, in validateRemoteDB
    basedefs.DB_POSTGRES, sqlQuery, True)
  File "/usr/share/ovirt-engine/scripts/common_utils.py", line 339, in execRemoteSqlCommand
    return execExternalCmd(cmd, failOnError, errMsg)
  File "/usr/share/ovirt-engine/scripts/common_utils.py", line 283, in execExternalCmd
    raise Exception(msg)
Exception: Failed running sql query

Comment 2 Itamar Heim 2012-08-09 07:56:26 UTC
closing ON_QA bugs as oVirt 3.1 was released:
http://www.ovirt.org/get-ovirt/