From fabrice.bacchella at orange.fr Thu Dec 10 06:50:37 2015 Content-Type: multipart/mixed; boundary="===============7755883059229841705==" MIME-Version: 1.0 From: Fabrice Bacchella To: users at ovirt.org Subject: [ovirt-users] engine-setup failed because of postgres 9.4 Date: Thu, 10 Dec 2015 12:43:02 +0100 Message-ID: --===============7755883059229841705== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable --Apple-Mail=3D_ED6F23F2-EAD4-4794-9104-AE8484B6590A Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=3Dus-ascii I'm on a RHEL 7, trying to install a ovirt 3.6.0.3. The database used is on a remote server, using a postgres 9.4. The backup of the previous database fails with : 2015-12-10 12:04:13 DEBUG =3D otopi.**FILTERED**_engine_setup.engine_common.database =3D database.backup:661 db backup res {'result': [{'stderr': 'pg_dump: =3D server version: 9.4.5; pg_dump version: 9.2.14\npg_dump: aborting =3D because of server version mismatch\n', 'rc': 1}], 'stdout': ''} But the good pg_dump is in the path: ~# type pg_dump pg_dump is /usr/pgsql-9.4/bin/pg_dump Although in the log file: 2015-12-10 12:40:19 DEBUG otopi.context context.dumpEnvironment:510 ENV =3D COMMAND/pg_dump=3D3Dstr:'/bin/pg_dump' Why ? How can I enforce the use of the latest pg_dump without rewrinting = =3D the '/bin/pg_dump' which is owned by the official postgres package ? --Apple-Mail=3D_ED6F23F2-EAD4-4794-9104-AE8484B6590A Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=3Dus-ascii I'm on a RHEL 7, trying to install a ovirt 3.6.0.3.

The database used is = on =3D a remote server, using a postgres 9.4.

The backup of the previous database = =3D fails with :
2015-12-10 12:04:13 DEBUG =3D otopi.**FILTERED**_engine_setup.engine_common.database =3D database.backup:661 db backup res {'result': [{'stderr': 'pg_dump: =3D server version: 9.4.5; pg_dump version: 9.2.14\npg_dump: aborting =3D because of server version mismatch\n', 'rc': 1}], 'stdout': =3D ''}

B= ut =3D the good pg_dump is in the path:

~# type pg_dump
pg_dump is /usr/pgsql-9.4/bin/pg_dump

Although in the log = =3D file:

2015-12-10 12:40:19 DEBUG otopi.context =3D context.dumpEnvironment:510 ENV COMMAND/pg_dump=3D3Dstr:'/bin/pg_dump'

Why ? How can I enfor= ce =3D the use of the latest pg_dump without rewrinting the '/bin/pg_dump' which is owned by the official postgres = =3D package ?

=3D --Apple-Mail=3D_ED6F23F2-EAD4-4794-9104-AE8484B6590A-- --===============7755883059229841705== Content-Type: multipart/alternative MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.bin" Ci0tQXBwbGUtTWFpbD1fRUQ2RjIzRjItRUFENC00Nzk0LTkxMDQtQUU4NDg0QjY1OTBBCkNvbnRl bnQtVHJhbnNmZXItRW5jb2Rpbmc6IHF1b3RlZC1wcmludGFibGUKQ29udGVudC1UeXBlOiB0ZXh0 L3BsYWluOwoJY2hhcnNldD11cy1hc2NpaQoKSSdtIG9uIGEgUkhFTCA3LCB0cnlpbmcgdG8gaW5z dGFsbCBhIG92aXJ0IDMuNi4wLjMuCgpUaGUgZGF0YWJhc2UgdXNlZCBpcyBvbiBhIHJlbW90ZSBz ZXJ2ZXIsIHVzaW5nIGEgcG9zdGdyZXMgOS40LgoKVGhlIGJhY2t1cCBvZiB0aGUgcHJldmlvdXMg ZGF0YWJhc2UgZmFpbHMgd2l0aCA6CjIwMTUtMTItMTAgMTI6MDQ6MTMgREVCVUcgPQpvdG9waS4q KkZJTFRFUkVEKipfZW5naW5lX3NldHVwLmVuZ2luZV9jb21tb24uZGF0YWJhc2UgPQpkYXRhYmFz ZS5iYWNrdXA6NjYxIGRiIGJhY2t1cCByZXMgeydyZXN1bHQnOiBbeydzdGRlcnInOiAncGdfZHVt cDogPQpzZXJ2ZXIgdmVyc2lvbjogOS40LjU7IHBnX2R1bXAgdmVyc2lvbjogOS4yLjE0XG5wZ19k dW1wOiBhYm9ydGluZyA9CmJlY2F1c2Ugb2Ygc2VydmVyIHZlcnNpb24gbWlzbWF0Y2hcbicsICdy Yyc6IDF9XSwgJ3N0ZG91dCc6ICcnfQoKQnV0IHRoZSBnb29kIHBnX2R1bXAgaXMgaW4gdGhlIHBh dGg6Cgp+IyB0eXBlIHBnX2R1bXAKcGdfZHVtcCBpcyAvdXNyL3Bnc3FsLTkuNC9iaW4vcGdfZHVt cAoKQWx0aG91Z2ggaW4gdGhlIGxvZyBmaWxlOgoKMjAxNS0xMi0xMCAxMjo0MDoxOSBERUJVRyBv dG9waS5jb250ZXh0IGNvbnRleHQuZHVtcEVudmlyb25tZW50OjUxMCBFTlYgPQpDT01NQU5EL3Bn X2R1bXA9M0RzdHI6Jy9iaW4vcGdfZHVtcCcKCldoeSA/IEhvdyBjYW4gSSBlbmZvcmNlIHRoZSB1 c2Ugb2YgdGhlIGxhdGVzdCBwZ19kdW1wIHdpdGhvdXQgcmV3cmludGluZyA9CnRoZSAnL2Jpbi9w Z19kdW1wJyB3aGljaCBpcyBvd25lZCBieSB0aGUgb2ZmaWNpYWwgcG9zdGdyZXMgcGFja2FnZSA/ CgoKLS1BcHBsZS1NYWlsPV9FRDZGMjNGMi1FQUQ0LTQ3OTQtOTEwNC1BRTg0ODRCNjU5MEEKQ29u dGVudC1UcmFuc2Zlci1FbmNvZGluZzogcXVvdGVkLXByaW50YWJsZQpDb250ZW50LVR5cGU6IHRl eHQvaHRtbDsKCWNoYXJzZXQ9dXMtYXNjaWkKCjxodG1sPjxoZWFkPjxtZXRhIGh0dHAtZXF1aXY9 M0QiQ29udGVudC1UeXBlIiBjb250ZW50PTNEInRleHQvaHRtbCA9CmNoYXJzZXQ9M0R1cy1hc2Np aSI+PC9oZWFkPjxib2R5IHN0eWxlPTNEIndvcmQtd3JhcDogYnJlYWstd29yZDsgPQotd2Via2l0 LW5ic3AtbW9kZTogc3BhY2U7IC13ZWJraXQtbGluZS1icmVhazogYWZ0ZXItd2hpdGUtc3BhY2U7 IiA9CmNsYXNzPTNEIiI+SSdtIG9uIGEgUkhFTCA3LCB0cnlpbmcgdG8gaW5zdGFsbCBhIG92aXJ0 Jm5ic3A7My42LjAuMy48ZGl2ID0KY2xhc3M9M0QiIj48YnIgY2xhc3M9M0QiIj48L2Rpdj48ZGl2 IGNsYXNzPTNEIiI+VGhlIGRhdGFiYXNlIHVzZWQgaXMgb24gPQphIHJlbW90ZSBzZXJ2ZXIsIHVz aW5nIGEgcG9zdGdyZXMgOS40LjwvZGl2PjxkaXYgY2xhc3M9M0QiIj48YnIgPQpjbGFzcz0zRCIi PjwvZGl2PjxkaXYgY2xhc3M9M0QiIj5UaGUgYmFja3VwIG9mIHRoZSBwcmV2aW91cyBkYXRhYmFz ZSA9CmZhaWxzIHdpdGggOjwvZGl2PjxkaXYgY2xhc3M9M0QiIj48ZGl2IHN0eWxlPTNEIm1hcmdp bjogMHB4OyBmb250LXNpemU6ID0KMTFweDsgZm9udC1mYW1pbHk6IE1lbmxvOyIgY2xhc3M9M0Qi Ij4yMDE1LTEyLTEwIDEyOjA0OjEzIERFQlVHID0Kb3RvcGkuKipGSUxURVJFRCoqX2VuZ2luZV9z ZXR1cC5lbmdpbmVfY29tbW9uLmRhdGFiYXNlID0KZGF0YWJhc2UuYmFja3VwOjY2MSBkYiBiYWNr dXAgcmVzIHsncmVzdWx0JzogW3snc3RkZXJyJzogJ3BnX2R1bXA6ID0Kc2VydmVyIHZlcnNpb246 IDkuNC41OyBwZ19kdW1wIHZlcnNpb246IDkuMi4xNFxucGdfZHVtcDogYWJvcnRpbmcgPQpiZWNh dXNlIG9mIHNlcnZlciB2ZXJzaW9uIG1pc21hdGNoXG4nLCAncmMnOiAxfV0sICdzdGRvdXQnOiA9 CicnfTwvZGl2PjwvZGl2PjxkaXYgY2xhc3M9M0QiIj48YnIgY2xhc3M9M0QiIj48L2Rpdj48ZGl2 IGNsYXNzPTNEIiI+QnV0ID0KdGhlIGdvb2QgcGdfZHVtcCBpcyBpbiB0aGUgcGF0aDo8L2Rpdj48 ZGl2IGNsYXNzPTNEIiI+PGJyID0KY2xhc3M9M0QiIj48L2Rpdj48ZGl2IGNsYXNzPTNEIiI+PGRp diBzdHlsZT0zRCJtYXJnaW46IDBweDsgZm9udC1zaXplOiA9CjExcHg7IGZvbnQtZmFtaWx5OiBN ZW5sbzsiIGNsYXNzPTNEIiI+fiMgdHlwZSBwZ19kdW1wPC9kaXY+PGRpdiA9CnN0eWxlPTNEIm1h cmdpbjogMHB4OyBmb250LXNpemU6IDExcHg7IGZvbnQtZmFtaWx5OiBNZW5sbzsiID0KY2xhc3M9 M0QiIj5wZ19kdW1wIGlzIC91c3IvcGdzcWwtOS40L2Jpbi9wZ19kdW1wPC9kaXY+PC9kaXY+PGRp diA9CmNsYXNzPTNEIiI+PGJyIGNsYXNzPTNEIiI+PC9kaXY+PGRpdiBjbGFzcz0zRCIiPkFsdGhv dWdoIGluIHRoZSBsb2cgPQpmaWxlOjwvZGl2PjxkaXYgY2xhc3M9M0QiIj48YnIgY2xhc3M9M0Qi Ij48L2Rpdj48ZGl2IGNsYXNzPTNEIiI+PGRpdiA9CnN0eWxlPTNEIm1hcmdpbjogMHB4OyBmb250 LXNpemU6IDExcHg7IGZvbnQtZmFtaWx5OiBNZW5sbzsiID0KY2xhc3M9M0QiIj4yMDE1LTEyLTEw IDEyOjQwOjE5IERFQlVHIG90b3BpLmNvbnRleHQgPQpjb250ZXh0LmR1bXBFbnZpcm9ubWVudDo1 MTAgRU5WIENPTU1BTkQvPHNwYW4gPQpzdHlsZT0zRCJmb250LXZhcmlhbnQtbGlnYXR1cmVzOiBu by1jb21tb24tbGlnYXR1cmVzOyBjb2xvcjogI2ZmZmZmZjsgPQpiYWNrZ3JvdW5kLWNvbG9yOiAj MDAwMDAwIiBjbGFzcz0zRCIiPnBnX2R1bXA8L3NwYW4+PTNEc3RyOicvYmluLzxzcGFuID0Kc3R5 bGU9M0QiZm9udC12YXJpYW50LWxpZ2F0dXJlczogbm8tY29tbW9uLWxpZ2F0dXJlczsgY29sb3I6 ICNmZmZmZmY7ID0KYmFja2dyb3VuZC1jb2xvcjogIzAwMDAwMCIgY2xhc3M9M0QiIj5wZ19kdW1w PC9zcGFuPic8L2Rpdj48L2Rpdj48ZGl2ID0KY2xhc3M9M0QiIj48YnIgY2xhc3M9M0QiIj48L2Rp dj48ZGl2IGNsYXNzPTNEIiI+V2h5ID8gSG93IGNhbiBJIGVuZm9yY2UgPQp0aGUgdXNlIG9mIHRo ZSBsYXRlc3QgcGdfZHVtcCB3aXRob3V0IHJld3JpbnRpbmcgdGhlJm5ic3A7PHNwYW4gPQpzdHls ZT0zRCJmb250LWZhbWlseTogTWVubG87IGZvbnQtc2l6ZTogMTFweDsiID0KY2xhc3M9M0QiIj4n L2Jpbi88L3NwYW4+PHNwYW4gc3R5bGU9M0QiZm9udC1mYW1pbHk6IE1lbmxvOyBmb250LXNpemU6 ID0KMTFweDsgY29sb3I6IHJnYigyNTUsIDI1NSwgMjU1KTsgYmFja2dyb3VuZC1jb2xvcjogcmdi KDAsIDAsIDApOyIgPQpjbGFzcz0zRCIiPnBnX2R1bXA8L3NwYW4+PHNwYW4gc3R5bGU9M0QiZm9u dC1mYW1pbHk6IE1lbmxvOyBmb250LXNpemU6ID0KMTFweDsiIGNsYXNzPTNEIiI+Jzwvc3Bhbj4m bmJzcDt3aGljaCBpcyBvd25lZCBieSB0aGUgb2ZmaWNpYWwgcG9zdGdyZXMgPQpwYWNrYWdlID88 L2Rpdj48ZGl2IGNsYXNzPTNEIiI+PGJyIGNsYXNzPTNEIiI+PC9kaXY+PC9ib2R5PjwvaHRtbD49 CgotLUFwcGxlLU1haWw9X0VENkYyM0YyLUVBRDQtNDc5NC05MTA0LUFFODQ4NEI2NTkwQS0tCg== --===============7755883059229841705==-- From didi at redhat.com Thu Dec 10 07:51:05 2015 Content-Type: multipart/mixed; boundary="===============4990773871644504583==" MIME-Version: 1.0 From: Yedidyah Bar David To: users at ovirt.org Subject: Re: [ovirt-users] engine-setup failed because of postgres 9.4 Date: Thu, 10 Dec 2015 14:51:04 +0200 Message-ID: In-Reply-To: ABAB1D8F-48F2-4E2A-B763-0D58C7D951A3@orange.fr --===============4990773871644504583== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable On Thu, Dec 10, 2015 at 1:43 PM, Fabrice Bacchella wrote: > I'm on a RHEL 7, trying to install a ovirt 3.6.0.3. > > The database used is on a remote server, using a postgres 9.4. > > The backup of the previous database fails with : > 2015-12-10 12:04:13 DEBUG > otopi.**FILTERED**_engine_setup.engine_common.database database.backup:661 > db backup res {'result': [{'stderr': 'pg_dump: server version: 9.4.5; > pg_dump version: 9.2.14\npg_dump: aborting because of server version > mismatch\n', 'rc': 1}], 'stdout': ''} > > But the good pg_dump is in the path: > > ~# type pg_dump > pg_dump is /usr/pgsql-9.4/bin/pg_dump > > Although in the log file: > > 2015-12-10 12:40:19 DEBUG otopi.context context.dumpEnvironment:510 ENV > COMMAND/pg_dump=3Dstr:'/bin/pg_dump' > > Why ? How can I enforce the use of the latest pg_dump without rewrinting = the > '/bin/pg_dump' which is owned by the official postgres package ? otopi ignores the PATH in env. It defaults to: /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin You can change that by something like: cat << __EOF__ > /etc/ovirt-engine-setup.conf.d/99-my-path.conf [environment:default] SYSTEM/commandPath=3Dstr:/usr/pgsql-9.4/bin:/usr/local/sbin:/usr/local/bin:= /usr/sbin:/usr/bin:/sbin:/bin __EOF__ Or just pass on the command line: engine-setup --otopi-environment=3D'SYSTEM/commandPath=3Dstr:/usr/pgsql-9.4= /bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin' grep for commandPath in the log file to see that it worked. Never tried this myself, though. You might face problems also with pg libra= ries, including making psycopg2 use your own libs. Please report about success/failure/problems. Thanks. Good luck, -- = Didi --===============4990773871644504583==-- From fabrice.bacchella at orange.fr Thu Dec 10 08:41:26 2015 Content-Type: multipart/mixed; boundary="===============2560368956281220149==" MIME-Version: 1.0 From: Fabrice Bacchella To: users at ovirt.org Subject: Re: [ovirt-users] engine-setup failed because of postgres 9.4 Date: Thu, 10 Dec 2015 14:41:22 +0100 Message-ID: <9AAE1509-FC7A-4602-9B3E-2D004D01863D@orange.fr> In-Reply-To: CAHRwYXuw7b-p_s0sFuBOkFTjoDLuaVS-q7hX-p1kh+jNt9bfUw@mail.gmail.com --===============2560368956281220149== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable > Le 10 d=C3=A9c. 2015 =C3=A0 13:51, Yedidyah Bar David = a =C3=A9crit : > = > engine-setup --otopi-environment=3D'SYSTEM/commandPath=3Dstr:/usr/pgsql-9= .4/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin' I got better results with --otopi-environment=3D"COMMAND/pg_dump=3Dstr:'/us= r/pgsql-9.4/bin/pg_dump'" But anyway: ~$ ls -l /bin/pg_dump lrwxrwxrwx 1 root root 31 Dec 10 13:13 /bin/pg_dump -> /etc/alternatives/pg= sql-pg_dump So it should not be needed to specify it at command line. Once the latest v= ersion of postgres is installed : ~# alternatives --list | grep pg_dump pgsql-pg_dump auto /usr/pgsql-9.4/bin/pg_dump I don't know why my first try failed. This time I installed pg-9.4 before a= nd everything was fine. --===============2560368956281220149==--