Re: [Users] installing ovirt-engine on fc17 - postgresql service cannot be executed from /etc/init.d/postgresql

From: "Alexey Kardashevskiy" <aik(a)ozlabs.ru&gt; To: "Juan Hernandez" <jhernand(a)redhat.com&gt; Cc: users(a)ovirt.org Sent: Tuesday, November 13, 2012 2:05:27 AM Subject: Re: [Users] installing ovirt-engine on fc17 - postgresql service cannot be executed from /etc/init.d/postgresql On 12/11/12 20:14, Juan Hernandez wrote: > On 11/12/2012 06:45 AM, Alexey Kardashevskiy wrote: >> Hi! >> >> I am trying to configure ovirt-engine and having a problem that it >> cannot >> finish because cannot create database because there is no >> /etc/init.d/postgresql. How do I fix my setup? Some packages >> missing? Below >> is some information. Thanks. >> >> >> The system is Fedora17/_ppc64_ (not x86 if it matters) with my 3.6 >> kernel. >> >> Below is the console output after running "postgresql-setup >> initdb" and >> "engine-setup" and the log produced by the "engine-setup" script. >> >> >> [root@vpl2 aik]# yum info ovirt-engine >> Loaded plugins: downloadonly, versionlock >> Installed Packages >> Name : ovirt-engine >> Arch : noarch >> Version : 3.1.0 >> Release : 2.fc17 >> Size : 1.3 M >> Repo : installed >> From repo : ovirt-stable >> Summary : Management server for Open Virtualization >> URL : http://www.ovirt.org >> License : ASL 2.0 >> Description : oVirt Engine is a feature-rich server virtualization >> management >> : system that provides advanced capabilities for >> managing the Open >> : virtualization infrastructure for Servers and >> Desktops. >> >> [root@vpl2 aik]# ls -la /etc/init.d/postgresql >> ls: cannot access /etc/init.d/postgresql: No such file or >> directory >> >> [root@vpl2 aik]# postgresql-setup initdb >> Initializing database ... OK >> >> [root@vpl2 aik]# engine-setup >> Welcome to oVirt Engine setup utility >> >> WARNING: oVirt Engine setup has already been run on this host. >> To remove all configuration and reset oVirt Engine please run >> engine-cleanup. >> Please be advised that executing engine-setup without cleanup is >> not supported. >> Would you like to proceed? (yes|no): no >> Installation stopped, Goodbye. >> [root@vpl2 aik]# engine-setup >> Welcome to oVirt Engine setup utility >> >> WARNING: oVirt Engine setup has already been run on this host. >> To remove all configuration and reset oVirt Engine please run >> engine-cleanup. >> Please be advised that executing engine-setup without cleanup is >> not supported. >> Would you like to proceed? (yes|no): yes >> HTTP Port [80] : >> HTTPS Port [443] : >> Host fully qualified domain name, note that this name should be >> fully >> resolvable [vpl2.ozlabs.ibm.com] : >> Password for Administrator (admin@internal) : >> Confirm password : >> Organization Name for the Certificate: ozlabs >> The default storage type you will be using ['NFS'| 'FC'| 'ISCSI'] >> [NFS] : >> Enter DB type for installation ['remote'| 'local'] [local] : >> Local database password : >> Confirm password : >> Should the installer configure NFS share on this server to be used >> as an >> ISO Domain? ['yes'| 'no'] [yes] : >> Local ISO domain path: /data/iso >> Display name for the ISO Domain: local-iso-share >> Firewall ports need to be opened. >> You can let the installer configure iptables automatically >> overriding the >> current configuration. The old configuration will be backed up. >> Alternately you can configure the firewall later using an example >> iptables >> file found under /usr/share/ovirt-engine/conf/iptables.example >> Configure iptables ? ['yes'| 'no']: yes >> >> oVirt Engine will be installed using the following configuration: >> ================================================================= >> http-port: 80 >> https-port: 443 >> host-fqdn: vpl2.ozlabs.ibm.com >> auth-pass: ******** >> org-name: ozlabs >> default-dc-type: NFS >> db-remote-install: local >> db-local-pass: ******** >> nfs-mp: /data/iso >> iso-domain-name: local-iso-share >> config-nfs: yes >> override-iptables: yes >> Proceed with the configuration listed above? (yes|no): yes >> >> Installing: >> Configuring oVirt-engine... [ DONE ] >> Creating CA... [ DONE ] >> Editing JBoss Configuration... [ DONE ] >> Setting Database Configuration... [ DONE ] >> Setting Database Security... [ DONE ] >> Creating Database... [ ERROR ] >> Database creation failed >> Please check log file >> /var/log/ovirt-engine/engine-setup_2012_11_12_16_06_23.log for >> more information >> >> [root@vpl2 aik]# ps ax|grep postgresql >> 13655 pts/2 S+ 0:00 grep --color=auto postgresql >> >> >> >> ************************* >> >> Here is a part of the >> /var/log/ovirt-engine/engine-setup_2012_11_12_16_06_23.log , can >> post the >> whole thing but it is quite big and seems to be irrelevant to the >> issue. >> >> >> 2012-11-12 16:07:01::DEBUG::engine-setup::940::root:: engine db >> creation is >> logged at >> /var/log/ovirt-engine//engine-db-install-2012_11_12_16_07_01.log >> 2012-11-12 16:07:01::DEBUG::common_utils::309::root:: Executing >> command --> >> '/usr/share/ovirt-engine/dbscripts/engine-db-install.sh -l >> engine-db-install-2012_11_12_16_07_01.log -w ******** -u postgres >> -s >> localhost -p 5432 -r local' >> 2012-11-12 16:07:01::DEBUG::common_utils::335::root:: output = >> Running >> local installation >> [engine-db-install] postgresql service cannot be executed from >> /etc/init.d/postgresql >> >> 2012-11-12 16:07:01::DEBUG::common_utils::336::root:: stderr = >> 2012-11-12 16:07:01::DEBUG::common_utils::337::root:: retcode = 1 >> 2012-11-12 16:07:01::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 953, in _createDB >> output, rc = utils.execCmd(cmd, None, True, >> output_messages.ERR_DB_CREATE_FAILED, masked_value_set) >> File "/usr/share/ovirt-engine/scripts/common_utils.py", line >> 340, in execCmd >> raise Exception(msg) >> Exception: Database creation failed >> >> 2012-11-12 16:07:01::DEBUG::engine-setup::1742::root:: *** The >> following >> params were used as user input: >> 2012-11-12 16:07:01::DEBUG::engine-setup::1747::root:: >> override-httpd-config: yes >> 2012-11-12 16:07:01::DEBUG::engine-setup::1747::root:: http-port: >> 80 >> 2012-11-12 16:07:01::DEBUG::engine-setup::1747::root:: https-port: >> 443 >> 2012-11-12 16:07:01::DEBUG::engine-setup::1747::root:: mac-range: >> 00:1A:4A:3D:8D:00-00:1A:4A:3D:8D:FF >> 2012-11-12 16:07:01::DEBUG::engine-setup::1747::root:: host-fqdn: >> vpl2.ozlabs.ibm.com >> 2012-11-12 16:07:01::DEBUG::engine-setup::1747::root:: auth-pass: >> ******** >> 2012-11-12 16:07:01::DEBUG::engine-setup::1747::root:: org-name: >> ozlabs >> 2012-11-12 16:07:01::DEBUG::engine-setup::1747::root:: >> default-dc-type: NFS >> 2012-11-12 16:07:01::DEBUG::engine-setup::1747::root:: >> db-remote-install: local >> 2012-11-12 16:07:01::DEBUG::engine-setup::1747::root:: db-host: >> localhost >> 2012-11-12 16:07:01::DEBUG::engine-setup::1747::root:: >> db-local-pass: ******** >> 2012-11-12 16:07:01::DEBUG::engine-setup::1747::root:: nfs-mp: >> /data/iso >> 2012-11-12 16:07:01::DEBUG::engine-setup::1747::root:: >> iso-domain-name: >> local-iso-share >> 2012-11-12 16:07:01::DEBUG::engine-setup::1747::root:: config-nfs: >> yes >> 2012-11-12 16:07:01::DEBUG::engine-setup::1747::root:: >> override-iptables: yes >> 2012-11-12 16:07:01::ERROR::engine-setup::2376::root:: Traceback >> (most >> recent call last): >> File "/bin/engine-setup", line 2370, in <module> >> main(confFile) >> File "/bin/engine-setup", line 2159, in main >> runSequences() >> File "/bin/engine-setup", line 2105, 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 953, in _createDB >> output, rc = utils.execCmd(cmd, None, True, >> output_messages.ERR_DB_CREATE_FAILED, masked_value_set) >> File "/usr/share/ovirt-engine/scripts/common_utils.py", line >> 340, in execCmd >> raise Exception(msg) >> Exception: Database creation failed > > The right way to start/stop services in Fedora 17 is using the > systemctl > tool: > > systemctl start postgresql.service > systemctl stop postgresql.service > > The postgresql service no longer uses SystemV scripts to > start/stop, it > uses systemctl instead, that is why there is no > /etc/init.d/postgresql > script. Yes I noticed that while googling. The question is what do I do to make engine-setup not failing. It is starting services, one-by-one, and it stops in the middle of a sequence as postgresql fails because engine-setup uses old postgresql script. ovirt.org uses FC17 so I wonder if there is some fix/workaround.

> If you still have problems to create the database please check the > database installation log file, should be named as follows: > > /var/log/ovirt-engine/engine-db-install-2012_11_12_16_07_01.log Database is fine... #engine db installer log file on vpl2.ozlabs.ibm.com [engine-db-install] verifying required rpms are installed. postgresql-server-9.1.6-1.fc17.ppc64 postgresql-9.1.6-1.fc17.ppc64 postgresql-libs-9.1.6-1.fc17.ppc64 postgresql-contrib-9.1.6-1.fc17.ppc64 uuid-1.6.2-11.fc17.ppc64 [engine-db-install] verifying postgres service exists. -- Alexey _______________________________________________ Users mailing list Users(a)ovirt.org http://lists.ovirt.org/mailman/listinfo/users