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@khm.de <mailto:okane@khm.de>>:

    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@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@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