<div dir="ltr"><div>Hello, Robert</div><div><br></div><div>Thank you for reply, I tried this steps but not worked for me , I think that I need change parameters in my postgresql but I don't know how do this.</div><div><br></div><div class="gmail_extra"><br><div class="gmail_quote">2018-04-22 7:45 GMT-03:00 Robert O'Kane <span dir="ltr"><<a href="mailto:okane@khm.de" target="_blank">okane@khm.de</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hello,<br>
<br>
I had a similar problem with the engine update from 4.1.9 to 4.2.2.<br>
For me it was SELinux in Enforcing mode on the host. You should check that SELinux is in "Enforcing" mode and that the audit daemon is complaining about postgres95. "audit2why -a"<br>
<br>
<br>
I set the host to "Permissive", did the upgrade and it worked for me.<br>
But you may have to leave it in "Permissive" mode until you can update the SELinux rules.<br>
<br>
<br>
*IF* the problem is SELinux I would suggest:<br>
<br>
1: Clean up the auditd logs (make sure all old problems are corrected).<br>
Reset the auditd logs so the following output is "cleaner".<br>
The "audit2why -a" command should show nothing. Please RYFM....<br>
<br>
2: Set SELinux to "Permissive" mode.<br>
<br>
3: Apply the Ovirt-engine updates. Make sure everything works.<br>
<br>
4: run "audit2why -a" and see what the warnings are<br>
or go directly to 5<br>
<br>
5: generate the new rules with:<br>
audit2allow -a -M postgres95-selinux-ovirt<br>
<br>
6: add the rules to the system:<br>
semodule -i postgres95-selinux-ovirt.pp<br>
<br>
7: It should now be possible to set SELinux back to "Enforcing"<br>
<br>
<br>
Good Luck,<br>
<br>
Robert O'Kane<div><div class="gmail-h5"><br>
<br>
<br>
Am 21.04.2018 um 10:26 schrieb Marcelo Leandro:<br>
</div></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div class="gmail-h5">
Hello,<br>
I have problem when i try upgrade the ovirt to 4.2, my version is 4.1.9, I<br>
have problem when engine-setup try update the postgresql.<br>
Postgres version 9.2<br>
<br>
I had this message:<br>
<br>
Log install:<br>
<br>
ERROR: pg_upgrade tool failed<br>
ERROR: Upgrade failed.<br>
* See /var/lib/pgsql/upgrade_rh-post<wbr>gresql95-postgresql.log for details.<br>
<br>
2018-04-21 04:53:10,766-0300 DEBUG otopi.transaction<br>
transaction._prepare:66 exception during prepare phase<br>
Traceback (most recent call last):<br>
File "/usr/lib/python2.7/site-packa<wbr>ges/otopi/transaction.py", line 62, in<br>
_prepare<br>
element.prepare()<br>
File<br>
"/usr/share/ovirt-engine/setup<wbr>/ovirt_engine_setup/engine_<wbr>common/postgres.py",<br>
line 777, in prepare<br>
raiseOnError=True,<br>
File "/usr/lib/python2.7/site-packa<wbr>ges/otopi/plugin.py", line 931, in<br>
execute<br>
command=args[0],<br>
RuntimeError: Command<br>
'/opt/rh/rh-postgresql95/root/<wbr>usr/bin/postgresql-setup' failed to execute<br>
2018-04-21 04:53:10,768-0300 DEBUG otopi.context context._executeMethod:143<br>
method exception<br>
Traceback (most recent call last):<br>
File "/usr/lib/python2.7/site-packa<wbr>ges/otopi/context.py", line 133, in<br>
_executeMethod<br>
method['method']()<br>
File<br>
"/usr/share/ovirt-engine/setup<wbr>/bin/../plugins/ovirt-engine-<wbr>setup/ovirt-engine/db/dbmsupgr<wbr>ade.py",<br>
line 89, in _updateDBMS<br>
oengcommcons.ProvisioningEnv.<wbr>OLD_POSTGRES_SERVICE<br>
File "/usr/lib/python2.7/site-packa<wbr>ges/otopi/transaction.py", line 106,<br>
in append<br>
self._prepare(element=<wbr>element)<br>
File "/usr/lib/python2.7/site-packa<wbr>ges/otopi/transaction.py", line 62, in<br>
_prepare<br>
element.prepare()<br>
File<br>
"/usr/share/ovirt-engine/setup<wbr>/ovirt_engine_setup/engine_<wbr>common/postgres.py",<br>
line 777, in prepare<br>
raiseOnError=True,<br>
File "/usr/lib/python2.7/site-packa<wbr>ges/otopi/plugin.py", line 931, in<br>
execute<br>
command=args[0],<br>
RuntimeError: Command<br>
'/opt/rh/rh-postgresql95/root/<wbr>usr/bin/postgresql-setup' failed to execute<br>
2018-04-21 04:53:10,770-0300 ERROR otopi.context context._executeMethod:152<br>
Failed to execute stage 'Misc configuration': Command<br>
'/opt/rh/rh-postgresql95/root/<wbr>usr/bin/postgresql-setup' failed to execute<br>
<br>
Log postgres:<br>
Performing Consistency Checks<br>
-----------------------------<br>
Checking cluster versions ok<br>
Checking database user is the install user ok<br>
Checking database connection settings ok<br>
Checking for prepared transactions ok<br>
Checking for reg* system OID user data types ok<br>
Checking for contrib/isn with bigint-passing mismatch ok<br>
Checking for invalid "line" user columns ok<br>
Creating dump of global objects ok<br>
Creating dump of database schemas<br>
engine<br>
ovirt_engine_history<br>
postgres<br>
template1<br>
ok<br>
<br>
encodings for database "postgres" do not match: old "SQL_ASCII", new "UTF8"<br>
Failure, exiting<br>
<br>
<br>
I know that problem not is in oVirt , but anyone help me ?<br>
<br>
<br>
Thank you!<br>
<br>
<br>
<br></div></div>
______________________________<wbr>_________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman<wbr>/listinfo/users</a><br>
<br><span class="gmail-HOEnZb"><font color="#888888">
</font></span></blockquote><span class="gmail-HOEnZb"><font color="#888888">
<br>
-- <br>
Systems Administrator<br>
Kunsthochschule für Medien Köln<br>
Peter-Welter-Platz 2<br>
50676 Köln<br>
______________________________<wbr>_________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman<wbr>/listinfo/users</a><br>
</font></span></blockquote></div><br></div></div>