Bug 888027

Description of problem:

Attempting to do an install of ovirt-engine 3.2 alpha I encountered an error "failed dropping user engine" in engine-setup.

Running engine-cleanup to try again results in "Error: Couldn't connect to the database server.Check that connection is working and rerun the cleanup utility". When I try to connect using "psql -h localhost -p 5432 -U engine" I receive the message "psql: FATAL: database "engine" is not currently accepting connections".

It's not really clear to me what is going on here, I haven't manually interfered with the database at all (though previous engine-setup runs may have created it, but cleanup doesn't work either...) and this is a clean F18 Beta installation.

Version-Release number of selected component (if applicable):

ovirt-engine-setup-3.2.0-1.20121212.git01e08b2.fc18
Additional info:

engine-install-*.log
====================

2012-12-17 15:33:49::DEBUG::common_utils::390::root:: Executing command --> '/usr/share/ovirt-engine/dbscripts/engine-db-install.sh -l engine-db-install-2012_12_17_15_33_49.log -w ******** -u postgres -s localhost -p 5432 -r local'
2012-12-17 15:33:51::DEBUG::common_utils::428::root:: output = Running local installation
failed dropping user engine

2012-12-17 15:33:51::DEBUG::common_utils::429::root:: stderr = 
2012-12-17 15:33:51::DEBUG::common_utils::430::root:: retcode = 1
2012-12-17 15:33:51::DEBUG::setup_sequences::62::root:: Traceback (most recent call last):
  File "/usr/share/ovirt-engine/scripts/setup_sequences.py", line 60, in run
    function()
  File "/bin/engine-setup", line 969, in _createDB
    output, rc = utils.execCmd(cmdList=cmd, failOnError=True, msg=output_messages.ERR_DB_CREATE_FAILED, maskList=masked_value_set)
  File "/usr/share/ovirt-engine/scripts/common_utils.py", line 433, in execCmd
    raise Exception(msg)
Exception: Database creation failed

2012-12-17 15:33:51::DEBUG::engine-setup::1785::root:: *** The following params were used as user input:
2012-12-17 15:33:51::DEBUG::engine-setup::1790::root:: override-httpd-config: yes
2012-12-17 15:33:51::DEBUG::engine-setup::1790::root:: http-port: 80
2012-12-17 15:33:51::DEBUG::engine-setup::1790::root:: https-port: 443
2012-12-17 15:33:51::DEBUG::engine-setup::1790::root:: mac-range: 00:1A:4A:0F:18:00-00:1A:4A:0F:18:FF
2012-12-17 15:33:51::DEBUG::engine-setup::1790::root:: host-fqdn: sgordon-ovirt-engine.usersys.redhat.com
2012-12-17 15:33:51::DEBUG::engine-setup::1790::root:: auth-pass: ********
2012-12-17 15:33:51::DEBUG::engine-setup::1790::root:: org-name: YYZ
2012-12-17 15:33:51::DEBUG::engine-setup::1790::root:: default-dc-type: NFS
2012-12-17 15:33:51::DEBUG::engine-setup::1790::root:: db-remote-install: local
2012-12-17 15:33:51::DEBUG::engine-setup::1790::root:: db-host: localhost
2012-12-17 15:33:51::DEBUG::engine-setup::1790::root:: db-local-pass: ********
2012-12-17 15:33:51::DEBUG::engine-setup::1790::root:: config-nfs: no
2012-12-17 15:33:51::DEBUG::engine-setup::1790::root:: override-iptables: yes
2012-12-17 15:33:51::ERROR::engine-setup::2194::root:: Traceback (most recent call last):
  File "/bin/engine-setup", line 2188, in <module>
    main(confFile)
  File "/bin/engine-setup", line 1971, in main 
    runSequences()
  File "/bin/engine-setup", line 1905, in runSequences
    controller.runAllSequences()
  File "/usr/share/ovirt-engine/scripts/setup_controller.py", line 54, in runAllSequences
    sequence.run()
  File "/usr/share/ovirt-engine/scripts/setup_sequences.py", line 154, in run
    step.run()
  File "/usr/share/ovirt-engine/scripts/setup_sequences.py", line 60, in run
    function()
  File "/bin/engine-setup", line 969, in _createDB
    output, rc = utils.execCmd(cmdList=cmd, failOnError=True, msg=output_messages.ERR_DB_CREATE_FAILED, maskList=masked_value_set)
  File "/usr/share/ovirt-engine/scripts/common_utils.py", line 433, in execCmd
    raise Exception(msg)
Exception: Database creation failed

engine-db-install-*.log
=======================

#engine db installer log file on sgordon-ovirt-engineusersysredhatcom                                                                                                                                                                        
[engine-db-install] verifying required rpms are installed.
postgresql-server-9.2.2-1.fc18.x86_64
postgresql-9.2.2-1.fc18.x86_64
postgresql-libs-9.2.2-1.fc18.x86_64
[engine-db-install] verifying postgres service exists.
[engine-db-install] init postgres db. 
[engine-db-install] psgql db already been initialized.
[engine-db-install] changing authentication scheme from peer to ident.
[engine-db-install] changing authentication scheme from ident to trust.
Note: Forwarding request to 'systemctl enable postgresql.service'.
[engine-db-install] stop postgres service.
[engine-db-install] starting postgres service.
[engine-db-install] validating that postgres service is running...retry 1
 ?column? 
----------
        1
(1 row)

[engine-db-install] checking if engine db exists already..
psql: FATAL:  database "engine" is not currently accepting connections
[engine-db-install] engine not installed.
[engine-db-install] updating db admin credentials
ERROR:  role "engine" cannot be dropped because some objects depend on it
DETAIL:  owner of database engine
792 objects in database engine
~