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 ~
This happens after running a cleanup utility due to a bug#782176. That bug is being fixed by http://gerrit.ovirt.org/#/c/10389/.