Re: [ovirt-users] Problem to upgrade ovirt

Can someone help me? Thanks, Marcelo Leandro

2018-04-23 8:27 GMT-03:00 Robert O'Kane <okane(a)khm.de&gt;: > Hello, > > Sorry, I did not have to chance anything else. It simply worked after my > SELinux solution. > > Good Luck. > > Robert O'Kane > > On 04/23/2018 01:21 PM, Marcelo Leandro wrote: >> Hello, Robert >> >> 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. >> >> >> 2018-04-22 7:45 GMT-03:00 Robert O'Kane <okane(a)khm.de <mailto: >> >> okane(a)khm.de&gt;&gt;: >> Hello, >> >> I had a similar problem with the engine update from 4.1.9 to 4.2.2. >> 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" >> >> >> I set the host to "Permissive", did the upgrade and it worked for me. >> But you may have to leave it in "Permissive" mode until you can >> >> update the >> >> SELinux rules. >> >> >> *IF* the problem is SELinux I would suggest: >> >> 1: Clean up the auditd logs (make sure all old problems are >> >> corrected). >> >> Reset the auditd logs so the following output is "cleaner". >> The "audit2why -a" command should show nothing. Please RYFM.... >> >> 2: Set SELinux to "Permissive" mode. >> >> 3: Apply the Ovirt-engine updates. Make sure everything works. >> >> 4: run "audit2why -a" and see what the warnings are >> >> or go directly to 5 >> >> 5: generate the new rules with: >> audit2allow -a -M postgres95-selinux-ovirt >> >> 6: add the rules to the system: >> semodule -i postgres95-selinux-ovirt.pp >> >> 7: It should now be possible to set SELinux back to "Enforcing" >> >> >> Good Luck, >> >> Robert O'Kane >> >> Am 21.04.2018 um 10:26 schrieb Marcelo Leandro: >> Hello, >> I have problem when i try upgrade the ovirt to 4.2, my version >> >> is 4.1.9, I >> >> have problem when engine-setup try update the postgresql. >> Postgres version 9.2 >> >> I had this message: >> >> Log install: >> >> ERROR: pg_upgrade tool failed >> ERROR: Upgrade failed. >> >> * See /var/lib/pgsql/upgrade_rh-postgresql95-postgresql.log >> >> for details. >> >> 2018-04-21 04:53:10,766-0300 DEBUG otopi.transaction >> transaction._prepare:66 exception during prepare phase >> >> Traceback (most recent call last): >> File "/usr/lib/python2.7/site-packages/otopi/transaction.py", >> >> line >> >> 62, in >> _prepare >> >> element.prepare() >> >> File >> >> "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_ >> >> common/postgres.py", >> >> line 777, in prepare >> >> raiseOnError=True, >> >> File "/usr/lib/python2.7/site-packages/otopi/plugin.py", >> >> line 931, in >> >> execute >> >> command=args[0], >> >> RuntimeError: Command >> '/opt/rh/rh-postgresql95/root/usr/bin/postgresql-setup' failed >> >> to execute >> >> 2018-04-21 04:53:10,768-0300 DEBUG otopi.context >> >> context._executeMethod:143 >> >> method exception >> >> Traceback (most recent call last): >> File "/usr/lib/python2.7/site-packages/otopi/context.py", >> >> line 133, in >> >> _executeMethod >> >> method['method']() >> >> File >> >> "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine- >> >> setup/ovirt-engine/db/dbmsupgrade.py", >> >> line 89, in _updateDBMS >> >> oengcommcons.ProvisioningEnv.OLD_POSTGRES_SERVICE >> >> File "/usr/lib/python2.7/site-packages/otopi/transaction.py", >> >> line 106, >> >> in append >> >> self._prepare(element=element) >> >> File "/usr/lib/python2.7/site-packages/otopi/transaction.py", >> >> line >> >> 62, in >> _prepare >> >> element.prepare() >> >> File >> >> "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_ >> >> common/postgres.py", >> >> line 777, in prepare >> >> raiseOnError=True, >> >> File "/usr/lib/python2.7/site-packages/otopi/plugin.py", >> >> line 931, in >> >> execute >> >> command=args[0], >> >> RuntimeError: Command >> '/opt/rh/rh-postgresql95/root/usr/bin/postgresql-setup' failed >> >> to execute >> >> 2018-04-21 04:53:10,770-0300 ERROR otopi.context >> >> context._executeMethod:152 >> >> Failed to execute stage 'Misc configuration': Command >> '/opt/rh/rh-postgresql95/root/usr/bin/postgresql-setup' failed >> >> to execute >> >> Log postgres: >> Performing Consistency Checks >> ----------------------------- >> Checking cluster versions ok >> Checking database user is the install user ok >> Checking database connection settings ok >> Checking for prepared transactions ok >> Checking for reg* system OID user data types ok >> Checking for contrib/isn with bigint-passing mismatch ok >> Checking for invalid "line" user columns ok >> Creating dump of global objects ok >> Creating dump of database schemas >> >> engine >> ovirt_engine_history >> postgres >> template1 >> >> ok >> >> encodings for database "postgres" do not match: old "SQL_ASCII", >> >> new "UTF8" >> >> Failure, exiting >> >> >> I know that problem not is in oVirt , but anyone help me ? >> >> >> Thank you! >> >> >> >> _______________________________________________ >> Users mailing list >> Users(a)ovirt.org <mailto:Users@ovirt.org> >> http://lists.ovirt.org/mailman/listinfo/users >> <http://lists.ovirt.org/mailman/listinfo/users> >> >> -- Systems Administrator >> Kunsthochschule für Medien Köln >> Peter-Welter-Platz 2 >> 50676 Köln >> _______________________________________________ >> Users mailing list >> Users(a)ovirt.org <mailto:Users@ovirt.org> >> http://lists.ovirt.org/mailman/listinfo/users >> <http://lists.ovirt.org/mailman/listinfo/users> > > -- > Robert O'Kane > Systems Administrator > Kunsthochschule für Medien Köln > Peter-Welter-Platz 2 > 50676 Köln > > fon: +49(221)20189-223 > fax: +49(221)20189-49223