From alourie at redhat.com Mon Apr 30 03:40:31 2012 Content-Type: multipart/mixed; boundary="===============4627093751169636767==" MIME-Version: 1.0 From: Alex Lourie To: users at ovirt.org Subject: Re: [Users] Exception: Database creation failed Date: Mon, 30 Apr 2012 10:40:23 +0300 Message-ID: <4F9E41E7.8020607@redhat.com> In-Reply-To: 4F9A2A52.2010402@epochcapital.com.au --===============4627093751169636767== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable This is a multi-part message in MIME format. --------------040209030001080801040408 Content-Type: text/plain; charset=3DISO-8859-1; format=3Dflowed Content-Transfer-Encoding: 7bit On 04/27/2012 08:10 AM, Patrick Roughan wrote: > Hey, > > While running engine-setup i get, > > creating database.... [ERROR] > Database creation failed > > the following is in the log file > > 2012-04-27 14:33:23::ERROR::engine-setup::2453::root:: Traceback (most = > recent call last): > File "/usr/bin/engine-setup", line 2447, in > main(confFile) > File "/usr/bin/engine-setup", line 2269, in main > runMainFunctions(conf) > File "/usr/bin/engine-setup", line 2187, in runMainFunctions > runFunction([_createDB, _updateVDCOptions], = > output_messages.INFO_CREATE_DB) > File "/usr/bin/engine-setup", line 1170, in runFunction > raise Exception(instance) > Exception: Database creation failed > > when i installed from repos which install the dependences including = > postgresql. postgresql failed to start, so i ran > > restorecon -R /var > service postgresql initdb > systemctl start postgresql.service > service postgresql start > > i wasnt able to login to though > so i change /var/lib/pqsql/data/pg_hba.conf values to trust > > now postgresql is run and can login (psql -U postgres) > > Any ideas? > > > _______________________________________________ > Users mailing list > Users(a)ovirt.org > http://lists.ovirt.org/mailman/listinfo/users Hello Patrick This problem could mean many things. Could you please attach the = complete log file? Additionally, please attach the corresponding = 'engine-db-install' log file. Finally, there's another log = */usr/share/ovirt-engine/dbscripts/create_db.sh.log*. Please take a look = in it to see if there are any errors, and if so, paste them too in your = answer. Thank you. -- = Alex Lourie. --------------040209030001080801040408 Content-Type: text/html; charset=3DISO-8859-1 Content-Transfer-Encoding: 7bit On 04/27/2012 08:10 AM, Patrick Roughan wrote:

Hey,

While running engine-setup i get,

creating database....        [ERRO= R]
Database creation failed

the following is in the log file

2012-04-27 14:33:23::ERROR::engine-setup::2453::root:: Traceback (most recent call last):
File "/usr/bin/engine-setup", line 2447, in <module>
    main(confFile)
File "/usr/bin/engine-setup", line 2269, in main
    runMainFunctions(conf)
File "/usr/bin/engine-setup", line 2187, in runMainFunctions
    runFunction([_createDB, _updateVDCOptions], output_messages.INFO_CREATE_DB)
File "/usr/bin/engine-setup", line 1170, in runFunction
    raise Exception(instance)
Exception: Database creation failed

when i installed from repos which install the dependences including postgresql. postgresql failed to start, so i ran

restorecon -R /var
service postgresql initdb
systemctl start postgresql.service
service postgresql start

i wasnt able to login to though
so i change /var/lib/pqsql/data/pg_hba.conf values to trust

now postgresql is run and can login (psql -U postgres)

Any ideas?

_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users

Hello Patrick

This problem could mean many things. Could you please attach the complete log file? Additionally, please attach the corresponding 'engine-db-install' log file.

Finally, there's another log /usr/share/ovirt-engine/dbscripts/creat= e_db.sh.log. Please take a look in it to see if there are any errors, and if so, paste them too in your answer.

Thank you.

-- =

Alex Lourie.

--------------040209030001080801040408-- --===============4627093751169636767== Content-Type: multipart/alternative MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.bin" VGhpcyBpcyBhIG11bHRpLXBhcnQgbWVzc2FnZSBpbiBNSU1FIGZvcm1hdC4KLS0tLS0tLS0tLS0t LS0wNDAyMDkwMzAwMDEwODA4MDEwNDA0MDgKQ29udGVudC1UeXBlOiB0ZXh0L3BsYWluOyBjaGFy c2V0PUlTTy04ODU5LTE7IGZvcm1hdD1mbG93ZWQKQ29udGVudC1UcmFuc2Zlci1FbmNvZGluZzog N2JpdAoKT24gMDQvMjcvMjAxMiAwODoxMCBBTSwgUGF0cmljayBSb3VnaGFuIHdyb3RlOgo+IEhl eSwKPgo+IFdoaWxlIHJ1bm5pbmcgZW5naW5lLXNldHVwIGkgZ2V0LAo+Cj4gY3JlYXRpbmcgZGF0 YWJhc2UuLi4uICAgICAgICBbRVJST1JdCj4gRGF0YWJhc2UgY3JlYXRpb24gZmFpbGVkCj4KPiB0 aGUgZm9sbG93aW5nIGlzIGluIHRoZSBsb2cgZmlsZQo+Cj4gMjAxMi0wNC0yNyAxNDozMzoyMzo6 RVJST1I6OmVuZ2luZS1zZXR1cDo6MjQ1Mzo6cm9vdDo6IFRyYWNlYmFjayAobW9zdCAKPiByZWNl bnQgY2FsbCBsYXN0KToKPiAgIEZpbGUgIi91c3IvYmluL2VuZ2luZS1zZXR1cCIsIGxpbmUgMjQ0 NywgaW4gPG1vZHVsZT4KPiAgICAgbWFpbihjb25mRmlsZSkKPiAgIEZpbGUgIi91c3IvYmluL2Vu Z2luZS1zZXR1cCIsIGxpbmUgMjI2OSwgaW4gbWFpbgo+ICAgICBydW5NYWluRnVuY3Rpb25zKGNv bmYpCj4gICBGaWxlICIvdXNyL2Jpbi9lbmdpbmUtc2V0dXAiLCBsaW5lIDIxODcsIGluIHJ1bk1h aW5GdW5jdGlvbnMKPiAgICAgcnVuRnVuY3Rpb24oW19jcmVhdGVEQiwgIF91cGRhdGVWRENPcHRp b25zXSwgCj4gb3V0cHV0X21lc3NhZ2VzLklORk9fQ1JFQVRFX0RCKQo+ICAgRmlsZSAiL3Vzci9i aW4vZW5naW5lLXNldHVwIiwgbGluZSAxMTcwLCBpbiBydW5GdW5jdGlvbgo+ICAgICByYWlzZSBF eGNlcHRpb24oaW5zdGFuY2UpCj4gRXhjZXB0aW9uOiBEYXRhYmFzZSBjcmVhdGlvbiBmYWlsZWQK Pgo+IHdoZW4gaSBpbnN0YWxsZWQgZnJvbSByZXBvcyB3aGljaCBpbnN0YWxsIHRoZSBkZXBlbmRl bmNlcyBpbmNsdWRpbmcgCj4gcG9zdGdyZXNxbC4gcG9zdGdyZXNxbCBmYWlsZWQgdG8gc3RhcnQs IHNvIGkgcmFuCj4KPiByZXN0b3JlY29uIC1SIC92YXIKPiBzZXJ2aWNlIHBvc3RncmVzcWwgaW5p dGRiCj4gc3lzdGVtY3RsIHN0YXJ0IHBvc3RncmVzcWwuc2VydmljZQo+IHNlcnZpY2UgcG9zdGdy ZXNxbCBzdGFydAo+Cj4gaSB3YXNudCBhYmxlIHRvIGxvZ2luIHRvIHRob3VnaAo+IHNvIGkgY2hh bmdlIC92YXIvbGliL3Bxc3FsL2RhdGEvcGdfaGJhLmNvbmYgdmFsdWVzIHRvIHRydXN0Cj4KPiBu b3cgcG9zdGdyZXNxbCBpcyBydW4gYW5kIGNhbiBsb2dpbiAocHNxbCAtVSBwb3N0Z3JlcykKPgo+ IEFueSBpZGVhcz8KPgo+Cj4gX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX18KPiBVc2VycyBtYWlsaW5nIGxpc3QKPiBVc2Vyc0BvdmlydC5vcmcKPiBodHRwOi8v bGlzdHMub3ZpcnQub3JnL21haWxtYW4vbGlzdGluZm8vdXNlcnMKCkhlbGxvIFBhdHJpY2sKClRo aXMgcHJvYmxlbSBjb3VsZCBtZWFuIG1hbnkgdGhpbmdzLiBDb3VsZCB5b3UgcGxlYXNlIGF0dGFj aCB0aGUgCmNvbXBsZXRlIGxvZyBmaWxlPyBBZGRpdGlvbmFsbHksIHBsZWFzZSBhdHRhY2ggdGhl IGNvcnJlc3BvbmRpbmcgCidlbmdpbmUtZGItaW5zdGFsbCcgbG9nIGZpbGUuCgpGaW5hbGx5LCB0 aGVyZSdzIGFub3RoZXIgbG9nIAoqL3Vzci9zaGFyZS9vdmlydC1lbmdpbmUvZGJzY3JpcHRzL2Ny ZWF0ZV9kYi5zaC5sb2cqLiBQbGVhc2UgdGFrZSBhIGxvb2sgCmluIGl0IHRvIHNlZSBpZiB0aGVy ZSBhcmUgYW55IGVycm9ycywgYW5kIGlmIHNvLCBwYXN0ZSB0aGVtIHRvbyBpbiB5b3VyIAphbnN3 ZXIuCgpUaGFuayB5b3UuCgotLSAKQWxleCBMb3VyaWUuCgoKLS0tLS0tLS0tLS0tLS0wNDAyMDkw MzAwMDEwODA4MDEwNDA0MDgKQ29udGVudC1UeXBlOiB0ZXh0L2h0bWw7IGNoYXJzZXQ9SVNPLTg4 NTktMQpDb250ZW50LVRyYW5zZmVyLUVuY29kaW5nOiA3Yml0Cgo8aHRtbD4KICA8aGVhZD4KICAg IDxtZXRhIGNvbnRlbnQ9InRleHQvaHRtbDsgY2hhcnNldD1JU08tODg1OS0xIgogICAgICBodHRw LWVxdWl2PSJDb250ZW50LVR5cGUiPgogIDwvaGVhZD4KICA8Ym9keSBiZ2NvbG9yPSIjRkZGRkZG IiB0ZXh0PSIjMDAwMDAwIj4KICAgIE9uIDA0LzI3LzIwMTIgMDg6MTAgQU0sIFBhdHJpY2sgUm91 Z2hhbiB3cm90ZToKICAgIDxibG9ja3F1b3RlIGNpdGU9Im1pZDo0RjlBMkE1Mi4yMDEwNDAyQGVw b2NoY2FwaXRhbC5jb20uYXUiCiAgICAgIHR5cGU9ImNpdGUiPkhleSwKICAgICAgPGJyPgogICAg ICA8YnI+CiAgICAgIFdoaWxlIHJ1bm5pbmcgZW5naW5lLXNldHVwIGkgZ2V0LAogICAgICA8YnI+ CiAgICAgIDxicj4KICAgICAgY3JlYXRpbmcgZGF0YWJhc2UuLi4uJm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IFtFUlJPUl0KICAgICAgPGJyPgogICAgICBEYXRhYmFz ZSBjcmVhdGlvbiBmYWlsZWQKICAgICAgPGJyPgogICAgICA8YnI+CiAgICAgIHRoZSBmb2xsb3dp bmcgaXMgaW4gdGhlIGxvZyBmaWxlCiAgICAgIDxicj4KICAgICAgPGJyPgogICAgICAyMDEyLTA0 LTI3IDE0OjMzOjIzOjpFUlJPUjo6ZW5naW5lLXNldHVwOjoyNDUzOjpyb290OjogVHJhY2ViYWNr CiAgICAgIChtb3N0IHJlY2VudCBjYWxsIGxhc3QpOgogICAgICA8YnI+CiAgICAgICZuYnNwOyBG aWxlICIvdXNyL2Jpbi9lbmdpbmUtc2V0dXAiLCBsaW5lIDI0NDcsIGluICZsdDttb2R1bGUmZ3Q7 CiAgICAgIDxicj4KICAgICAgJm5ic3A7Jm5ic3A7Jm5ic3A7IG1haW4oY29uZkZpbGUpCiAgICAg IDxicj4KICAgICAgJm5ic3A7IEZpbGUgIi91c3IvYmluL2VuZ2luZS1zZXR1cCIsIGxpbmUgMjI2 OSwgaW4gbWFpbgogICAgICA8YnI+CiAgICAgICZuYnNwOyZuYnNwOyZuYnNwOyBydW5NYWluRnVu Y3Rpb25zKGNvbmYpCiAgICAgIDxicj4KICAgICAgJm5ic3A7IEZpbGUgIi91c3IvYmluL2VuZ2lu ZS1zZXR1cCIsIGxpbmUgMjE4NywgaW4gcnVuTWFpbkZ1bmN0aW9ucwogICAgICA8YnI+CiAgICAg ICZuYnNwOyZuYnNwOyZuYnNwOyBydW5GdW5jdGlvbihbX2NyZWF0ZURCLCZuYnNwOyBfdXBkYXRl VkRDT3B0aW9uc10sCiAgICAgIG91dHB1dF9tZXNzYWdlcy5JTkZPX0NSRUFURV9EQikKICAgICAg PGJyPgogICAgICAmbmJzcDsgRmlsZSAiL3Vzci9iaW4vZW5naW5lLXNldHVwIiwgbGluZSAxMTcw LCBpbiBydW5GdW5jdGlvbgogICAgICA8YnI+CiAgICAgICZuYnNwOyZuYnNwOyZuYnNwOyByYWlz ZSBFeGNlcHRpb24oaW5zdGFuY2UpCiAgICAgIDxicj4KICAgICAgRXhjZXB0aW9uOiBEYXRhYmFz ZSBjcmVhdGlvbiBmYWlsZWQKICAgICAgPGJyPgogICAgICA8YnI+CiAgICAgIHdoZW4gaSBpbnN0 YWxsZWQgZnJvbSByZXBvcyB3aGljaCBpbnN0YWxsIHRoZSBkZXBlbmRlbmNlcwogICAgICBpbmNs dWRpbmcgcG9zdGdyZXNxbC4gcG9zdGdyZXNxbCBmYWlsZWQgdG8gc3RhcnQsIHNvIGkgcmFuCiAg ICAgIDxicj4KICAgICAgPGJyPgogICAgICByZXN0b3JlY29uIC1SIC92YXIKICAgICAgPGJyPgog ICAgICBzZXJ2aWNlIHBvc3RncmVzcWwgaW5pdGRiCiAgICAgIDxicj4KICAgICAgc3lzdGVtY3Rs IHN0YXJ0IHBvc3RncmVzcWwuc2VydmljZQogICAgICA8YnI+CiAgICAgIHNlcnZpY2UgcG9zdGdy ZXNxbCBzdGFydAogICAgICA8YnI+CiAgICAgIDxicj4KICAgICAgaSB3YXNudCBhYmxlIHRvIGxv Z2luIHRvIHRob3VnaAogICAgICA8YnI+CiAgICAgIHNvIGkgY2hhbmdlIC92YXIvbGliL3Bxc3Fs L2RhdGEvcGdfaGJhLmNvbmYgdmFsdWVzIHRvIHRydXN0CiAgICAgIDxicj4KICAgICAgPGJyPgog ICAgICBub3cgcG9zdGdyZXNxbCBpcyBydW4gYW5kIGNhbiBsb2dpbiAocHNxbCAtVSBwb3N0Z3Jl cykKICAgICAgPGJyPgogICAgICA8YnI+CiAgICAgIEFueSBpZGVhcz8KICAgICAgPGJyPgogICAg ICA8YnI+CiAgICAgIDxicj4KICAgICAgX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX18KICAgICAgPGJyPgogICAgICBVc2VycyBtYWlsaW5nIGxpc3QKICAgICAg PGJyPgogICAgICA8YSBjbGFzcz0ibW96LXR4dC1saW5rLWFiYnJldmlhdGVkIiBocmVmPSJtYWls dG86VXNlcnNAb3ZpcnQub3JnIj5Vc2Vyc0BvdmlydC5vcmc8L2E+CiAgICAgIDxicj4KICAgICAg PGEgY2xhc3M9Im1vei10eHQtbGluay1mcmVldGV4dCIgaHJlZj0iaHR0cDovL2xpc3RzLm92aXJ0 Lm9yZy9tYWlsbWFuL2xpc3RpbmZvL3VzZXJzIj5odHRwOi8vbGlzdHMub3ZpcnQub3JnL21haWxt YW4vbGlzdGluZm8vdXNlcnM8L2E+CiAgICAgIDxicj4KICAgIDwvYmxvY2txdW90ZT4KICAgIDxi cj4KICAgIEhlbGxvIFBhdHJpY2s8YnI+CiAgICA8YnI+CiAgICBUaGlzIHByb2JsZW0gY291bGQg bWVhbiBtYW55IHRoaW5ncy4gQ291bGQgeW91IHBsZWFzZSBhdHRhY2ggdGhlCiAgICBjb21wbGV0 ZSBsb2cgZmlsZT8gQWRkaXRpb25hbGx5LCBwbGVhc2UgYXR0YWNoIHRoZSBjb3JyZXNwb25kaW5n CiAgICAnZW5naW5lLWRiLWluc3RhbGwnIGxvZyBmaWxlLiA8YnI+CiAgICA8YnI+CiAgICBGaW5h bGx5LCB0aGVyZSdzIGFub3RoZXIgbG9nIDxiPi91c3Ivc2hhcmUvb3ZpcnQtZW5naW5lL2Ric2Ny aXB0cy9jcmVhdGVfZGIuc2gubG9nPC9iPi4KICAgIFBsZWFzZSB0YWtlIGEgbG9vayBpbiBpdCB0 byBzZWUgaWYgdGhlcmUgYXJlIGFueSBlcnJvcnMsIGFuZCBpZiBzbywKICAgIHBhc3RlIHRoZW0g dG9vIGluIHlvdXIgYW5zd2VyLjxicj4KICAgIDxicj4KICAgIFRoYW5rIHlvdS48YnI+CiAgICA8 YnI+CiAgICA8cHJlIGNsYXNzPSJtb3otc2lnbmF0dXJlIiBjb2xzPSI3MiI+LS0gCkFsZXggTG91 cmllLjwvcHJlPgogIDwvYm9keT4KPC9odG1sPgoKLS0tLS0tLS0tLS0tLS0wNDAyMDkwMzAwMDEw ODA4MDEwNDA0MDgtLQo= --===============4627093751169636767==--