<div dir="ltr"><div>Thank you for reply, </div><div><br></div><div><br></div><div>&quot;BZ 1515635 [RFE] Drop uuid_generate_v1() internal implementation and use the implementation from standard PostgreSQL uuid-ossp extension</div><div>We have added a requirement for uuid-ossp PostgreSQL extension to be present in engine database. For databases managed by engine-setup this is performed automatically, but non-managed databases (usually remote databases) this needs to be done manually by administrators. &quot;</div><div><br></div><div><br></div><div>my database is  managed by engine-setup, so i think that is perfomed automatically. I know that problem in my database , but I instaled it`s whith engine-setup com default options.</div><div><br></div><div>I try an new instalation in new host and restore backup and when I try update I had take the same error.</div><div><br></div><div><br></div><div>Very thanks!!</div><div><div><span style="color:rgb(51,51,51);font-family:&quot;Source Sans Pro&quot;,&quot;Open Sans&quot;,&quot;Helvetica Neue&quot;,Helvetica,Arial,sans-serif;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><br></span></div><div><span style="color:rgb(51,51,51);font-family:&quot;Source Sans Pro&quot;,&quot;Open Sans&quot;,&quot;Helvetica Neue&quot;,Helvetica,Arial,sans-serif;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><br></span></div><div><span style="color:rgb(51,51,51);font-family:&quot;Source Sans Pro&quot;,&quot;Open Sans&quot;,&quot;Helvetica Neue&quot;,Helvetica,Arial,sans-serif;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><br></span></div><div><br></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">2018-04-23 16:47 GMT-03:00 Alexander Wels <span dir="ltr">&lt;<a href="mailto:awels@redhat.com" target="_blank">awels@redhat.com</a>&gt;</span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">On Monday, April 23, 2018 3:23:21 PM EDT Marcelo Leandro wrote:<br>
&gt; Can someone help me?<br>
&gt; <br>
&gt; Thanks,<br>
&gt; <br>
&gt; Marcelo Leandro<br>
&gt; <br>
<br>
</span>You need postgresql 9.5, following the information here should give you <br>
everything you need:<br>
<br>
<a href="https://www.ovirt.org/release/4.2.1/" rel="noreferrer" target="_blank">https://www.ovirt.org/release/<wbr>4.2.1/</a><br>
<br>
Also look at the information below &#39;What&#39;s New in 4.2.1&#39; it has some <br>
information on upgrading the uuid generation which requires some manual steps.<br>
<div class="HOEnZb"><div class="h5"><br>
&gt; 2018-04-23 8:27 GMT-03:00 Robert O&#39;Kane &lt;<a href="mailto:okane@khm.de">okane@khm.de</a>&gt;:<br>
&gt; &gt; Hello,<br>
&gt; &gt; <br>
&gt; &gt; Sorry, I did not have to chance anything else. It simply worked after my<br>
&gt; &gt; SELinux solution.<br>
&gt; &gt; <br>
&gt; &gt; Good Luck.<br>
&gt; &gt; <br>
&gt; &gt; Robert O&#39;Kane<br>
&gt; &gt; <br>
&gt; &gt; On 04/23/2018 01:21 PM, Marcelo Leandro wrote:<br>
&gt; &gt;&gt; Hello, Robert<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; Thank you for reply, I tried this steps but not worked for me , I think<br>
&gt; &gt;&gt; that I need change parameters in my postgresql but I don&#39;t know how do<br>
&gt; &gt;&gt; this.<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; 2018-04-22 7:45 GMT-03:00 Robert O&#39;Kane &lt;<a href="mailto:okane@khm.de">okane@khm.de</a> &lt;mailto:<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; <a href="mailto:okane@khm.de">okane@khm.de</a>&gt;&gt;:<br>
&gt; &gt;&gt;     Hello,<br>
&gt; &gt;&gt;     <br>
&gt; &gt;&gt;     I had a similar problem with the engine update from 4.1.9 to 4.2.2.<br>
&gt; &gt;&gt;     For me it was SELinux in Enforcing mode on the host.  You should<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; check that<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt;     SELinux is in &quot;Enforcing&quot; mode and that the audit daemon is<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; complaining<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt;     about postgres95. &quot;audit2why -a&quot;<br>
&gt; &gt;&gt;     <br>
&gt; &gt;&gt;     <br>
&gt; &gt;&gt;     I set the host to &quot;Permissive&quot;, did the upgrade and it worked for me.<br>
&gt; &gt;&gt;     But you may have to leave it in &quot;Permissive&quot; mode until you can<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; update the<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt;     SELinux rules.<br>
&gt; &gt;&gt;     <br>
&gt; &gt;&gt;     <br>
&gt; &gt;&gt;     *IF* the problem is SELinux I would suggest:<br>
&gt; &gt;&gt;     <br>
&gt; &gt;&gt;     1: Clean up the auditd logs (make sure all old problems are<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; corrected).<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt;         Reset the auditd logs so the following output is &quot;cleaner&quot;.<br>
&gt; &gt;&gt;         The &quot;audit2why -a&quot; command should show nothing. Please RYFM....<br>
&gt; &gt;&gt;     <br>
&gt; &gt;&gt;     2: Set SELinux to &quot;Permissive&quot; mode.<br>
&gt; &gt;&gt;     <br>
&gt; &gt;&gt;     3: Apply the Ovirt-engine updates. Make sure everything works.<br>
&gt; &gt;&gt;     <br>
&gt; &gt;&gt;     4: run &quot;audit2why -a&quot; and see what the warnings are<br>
&gt; &gt;&gt;     <br>
&gt; &gt;&gt;       or go directly to 5<br>
&gt; &gt;&gt;     <br>
&gt; &gt;&gt;     5: generate the new rules with:<br>
&gt; &gt;&gt;            audit2allow -a -M postgres95-selinux-ovirt<br>
&gt; &gt;&gt;     <br>
&gt; &gt;&gt;     6: add the rules to the system:<br>
&gt; &gt;&gt;            semodule -i  postgres95-selinux-ovirt.pp<br>
&gt; &gt;&gt;     <br>
&gt; &gt;&gt;     7: It should now be possible to set SELinux back to &quot;Enforcing&quot;<br>
&gt; &gt;&gt;     <br>
&gt; &gt;&gt;     <br>
&gt; &gt;&gt;     Good Luck,<br>
&gt; &gt;&gt;     <br>
&gt; &gt;&gt;     Robert O&#39;Kane<br>
&gt; &gt;&gt;     <br>
&gt; &gt;&gt;     Am 21.04.2018 um 10:26 schrieb Marcelo Leandro:<br>
&gt; &gt;&gt;         Hello,<br>
&gt; &gt;&gt;         I have problem when i try upgrade the ovirt to 4.2,  my version<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; is 4.1.9, I<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt;         have problem when engine-setup try update the postgresql.<br>
&gt; &gt;&gt;         Postgres version 9.2<br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;         I had this message:<br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;         Log install:<br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;         ERROR: pg_upgrade tool failed<br>
&gt; &gt;&gt;         ERROR: Upgrade failed.<br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;            * See /var/lib/pgsql/upgrade_rh-<wbr>postgresql95-postgresql.log<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; for details.<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt;         2018-04-21 04:53:10,766-0300 DEBUG otopi.transaction<br>
&gt; &gt;&gt;         transaction._prepare:66 exception during prepare phase<br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;         Traceback (most recent call last):<br>
&gt; &gt;&gt;             File &quot;/usr/lib/python2.7/site-<wbr>packages/otopi/transaction.py&quot;<wbr>,<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; line<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt;         62, in<br>
&gt; &gt;&gt;         _prepare<br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;               element.prepare()<br>
&gt; &gt;&gt;             <br>
&gt; &gt;&gt;             File<br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;         &quot;/usr/share/ovirt-engine/<wbr>setup/ovirt_engine_setup/<wbr>engine_<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; common/postgres.py&quot;,<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt;         line 777, in prepare<br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;               raiseOnError=True,<br>
&gt; &gt;&gt;             <br>
&gt; &gt;&gt;             File &quot;/usr/lib/python2.7/site-<wbr>packages/otopi/plugin.py&quot;,<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; line 931, in<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt;         execute<br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;               command=args[0],<br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;         RuntimeError: Command<br>
&gt; &gt;&gt;         &#39;/opt/rh/rh-postgresql95/root/<wbr>usr/bin/postgresql-setup&#39; failed<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; to execute<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt;         2018-04-21 04:53:10,768-0300 DEBUG otopi.context<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; context._executeMethod:143<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt;         method exception<br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;         Traceback (most recent call last):<br>
&gt; &gt;&gt;             File &quot;/usr/lib/python2.7/site-<wbr>packages/otopi/context.py&quot;,<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; line 133, in<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt;         _executeMethod<br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;               method[&#39;method&#39;]()<br>
&gt; &gt;&gt;             <br>
&gt; &gt;&gt;             File<br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;         &quot;/usr/share/ovirt-engine/<wbr>setup/bin/../plugins/ovirt-<wbr>engine-<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; setup/ovirt-engine/db/<wbr>dbmsupgrade.py&quot;,<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt;         line 89, in _updateDBMS<br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;               oengcommcons.ProvisioningEnv.<wbr>OLD_POSTGRES_SERVICE<br>
&gt; &gt;&gt;             <br>
&gt; &gt;&gt;             File &quot;/usr/lib/python2.7/site-<wbr>packages/otopi/transaction.py&quot;<wbr>,<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; line 106,<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt;         in append<br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;               self._prepare(element=element)<br>
&gt; &gt;&gt;             <br>
&gt; &gt;&gt;             File &quot;/usr/lib/python2.7/site-<wbr>packages/otopi/transaction.py&quot;<wbr>,<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; line<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt;         62, in<br>
&gt; &gt;&gt;         _prepare<br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;               element.prepare()<br>
&gt; &gt;&gt;             <br>
&gt; &gt;&gt;             File<br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;         &quot;/usr/share/ovirt-engine/<wbr>setup/ovirt_engine_setup/<wbr>engine_<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; common/postgres.py&quot;,<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt;         line 777, in prepare<br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;               raiseOnError=True,<br>
&gt; &gt;&gt;             <br>
&gt; &gt;&gt;             File &quot;/usr/lib/python2.7/site-<wbr>packages/otopi/plugin.py&quot;,<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; line 931, in<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt;         execute<br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;               command=args[0],<br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;         RuntimeError: Command<br>
&gt; &gt;&gt;         &#39;/opt/rh/rh-postgresql95/root/<wbr>usr/bin/postgresql-setup&#39; failed<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; to execute<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt;         2018-04-21 04:53:10,770-0300 ERROR otopi.context<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; context._executeMethod:152<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt;         Failed to execute stage &#39;Misc configuration&#39;: Command<br>
&gt; &gt;&gt;         &#39;/opt/rh/rh-postgresql95/root/<wbr>usr/bin/postgresql-setup&#39; failed<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; to execute<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt;         Log postgres:<br>
&gt; &gt;&gt;         Performing Consistency Checks<br>
&gt; &gt;&gt;         -----------------------------<br>
&gt; &gt;&gt;         Checking cluster versions                                   ok<br>
&gt; &gt;&gt;         Checking database user is the install user                  ok<br>
&gt; &gt;&gt;         Checking database connection settings                       ok<br>
&gt; &gt;&gt;         Checking for prepared transactions                          ok<br>
&gt; &gt;&gt;         Checking for reg* system OID user data types                ok<br>
&gt; &gt;&gt;         Checking for contrib/isn with bigint-passing mismatch       ok<br>
&gt; &gt;&gt;         Checking for invalid &quot;line&quot; user columns                    ok<br>
&gt; &gt;&gt;         Creating dump of global objects                             ok<br>
&gt; &gt;&gt;         Creating dump of database schemas<br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;             engine<br>
&gt; &gt;&gt;             ovirt_engine_history<br>
&gt; &gt;&gt;             postgres<br>
&gt; &gt;&gt;             template1<br>
&gt; &gt;&gt;             <br>
&gt; &gt;&gt;                                                                       ok<br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;         encodings for database &quot;postgres&quot; do not match:  old &quot;SQL_ASCII&quot;,<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt; new &quot;UTF8&quot;<br>
&gt; &gt;&gt; <br>
&gt; &gt;&gt;         Failure, exiting<br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;         I know that problem not is in oVirt , but anyone help me ?<br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;         Thank you!<br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;         <br>
&gt; &gt;&gt;         ______________________________<wbr>_________________<br>
&gt; &gt;&gt;         Users mailing list<br>
&gt; &gt;&gt;         <a href="mailto:Users@ovirt.org">Users@ovirt.org</a> &lt;mailto:<a href="mailto:Users@ovirt.org">Users@ovirt.org</a>&gt;<br>
&gt; &gt;&gt;         <a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br>
&gt; &gt;&gt;         &lt;<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a>&gt;<br>
&gt; &gt;&gt;     <br>
&gt; &gt;&gt;     --     Systems Administrator<br>
&gt; &gt;&gt;     Kunsthochschule für Medien Köln<br>
&gt; &gt;&gt;     Peter-Welter-Platz 2<br>
&gt; &gt;&gt;     50676 Köln<br>
&gt; &gt;&gt;     ______________________________<wbr>_________________<br>
&gt; &gt;&gt;     Users mailing list<br>
&gt; &gt;&gt;     <a href="mailto:Users@ovirt.org">Users@ovirt.org</a> &lt;mailto:<a href="mailto:Users@ovirt.org">Users@ovirt.org</a>&gt;<br>
&gt; &gt;&gt;     <a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br>
&gt; &gt;&gt;     &lt;<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a>&gt;<br>
&gt; &gt; <br>
&gt; &gt; --<br>
&gt; &gt; Robert O&#39;Kane<br>
&gt; &gt; Systems Administrator<br>
&gt; &gt; Kunsthochschule für Medien Köln<br>
&gt; &gt; Peter-Welter-Platz 2<br>
&gt; &gt; 50676 Köln<br>
&gt; &gt; <br>
&gt; &gt; fon: +49(221)20189-223<br>
&gt; &gt; fax: +49(221)20189-49223<br>
<br>
<br>
<br>
<br>
</div></div></blockquote></div><br></div>