RHEL Engineering is moving the tracking of its product development work on RHEL 6 through RHEL 9 to Red Hat Jira (issues.redhat.com). If you're a Red Hat customer, please continue to file support cases via the Red Hat customer portal. If you're not, please head to the "RHEL project" in Red Hat Jira and file new tickets here. Individual Bugzilla bugs in the statuses "NEW", "ASSIGNED", and "POST" are being migrated throughout September 2023. Bugs of Red Hat partners with an assigned Engineering Partner Manager (EPM) are migrated in late September as per pre-agreed dates. Bugs against components "kernel", "kernel-rt", and "kpatch" are only migrated if still in "NEW" or "ASSIGNED". If you cannot log in to RH Jira, please consult article #7032570. That failing, please send an e-mail to the RH Jira admins at rh-issues@redhat.com to troubleshoot your issue as a user management inquiry. The email creates a ServiceNow ticket with Red Hat. Individual Bugzilla bugs that are migrated will be moved to status "CLOSED", resolution "MIGRATED", and set with "MigratedToJIRA" in "Keywords". The link to the successor Jira issue will be found under "Links", have a little "two-footprint" icon next to it, and direct you to the "RHEL project" in Red Hat Jira (issue links are of type "https://issues.redhat.com/browse/RHEL-XXXX", where "X" is a digit). This same link will be available in a blue banner at the top of the page informing you that that bug has been migrated.
Bug 1279032 - mysql/configuration_changes: has set requirements incorectly
Summary: mysql/configuration_changes: has set requirements incorectly
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Enterprise Linux 6
Classification: Red Hat
Component: preupgrade-assistant-el6toel7
Version: 6.7
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: rc
: ---
Assignee: Petr Stodulka
QA Contact: Alois Mahdal
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2015-11-07 10:25 UTC by Alois Mahdal
Modified: 2016-05-11 08:28 UTC (History)
4 users (show)

Fixed In Version: preupgrade-assistant-el6toel7-0.6.44-1.el6
Doc Type: Bug Fix
Doc Text:
Previously, Preupgrade Assistant could incorrectly report upgrade risk based on configuration files even if the relevant package was already uninstalled from the system. After this fix, Preupgrade Assistant will only report risks relevant to installed packages.
Clone Of:
Environment:
Last Closed: 2016-05-11 08:28:04 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHBA-2016:1020 0 normal SHIPPED_LIVE preupgrade-assistant-el6toel7 bug fix and enhancement update 2016-05-11 12:25:34 UTC

Description Alois Mahdal 2015-11-07 10:25:04 UTC
Description of problem
======================

`databases/mysql/configuration_changes` can show false positives as it
will perform its checks even if the relevant package is not installed.


Version-Release number of selected component
============================================

preupgrade-assistant-contents-0.6.41-1.el6


How reproducible
================

Always


Steps to Reproduce
==================

 1. Uninstall mysql-server
 2. Add one or more deprecated options ot /etc/my.cnf
 3. run preupg


Actual results
==============

Risk is reported and content result is `needs_action`


Expected results
================

No risk is be reported and content result is `notapplicable`

Comment 2 Petr Stodulka 2016-02-18 16:38:26 UTC
Rpm mysql-server isn't priority of this content. Configuration files are under rpm mysql-lib. However, content requires installed mysql due to binary:
  /usr/bin/my_print_defaults

But mysql-libs are required by other packages too. So, I recommend set applies_to for mysql-libs and inside check script check if mysql is installed. When mysql isn't installed, we should probably print some info with *_risk, that content can't check configuration files and ask for installation of mysql rpm first.

What do you thinkg Lojzo about that solution?

Comment 3 Alois Mahdal 2016-02-18 22:33:47 UTC
Seems OK to me.

What kinda sucks is that in case mysql-libs are present but the binary isn't, we'll have to blackmail user (into installing the server which we'll be migrating then) ... but I don't see any better solution.

We might want to think about generic solution to such situation (dependency X needed to analyze files of Y) but for this bug the above seems OK.

Comment 4 Petr Stodulka 2016-02-19 09:36:07 UTC
(In reply to Alois Mahdal from comment #3)
....
> We might want to think about generic solution to such situation (dependency
> X needed to analyze files of Y) but for this bug the above seems OK.

I agree. We have now something like that - in INI files we can use "binary_req" or "requires" I don't like the output here. It's too generic:

,,INPLACERISK: HIGH: Binary /usr/bin/my_print_defaults is not installed"

I'll discuss it with Peter, if it is possible change the default message or append specific description for each content.

Comment 5 Petr Stodulka 2016-02-19 15:26:50 UTC
Ok. So we will use more general solution. binary_req in INI file will be set and better message will be provided by preupgrade-assistant.

Comment 6 Petr Stodulka 2016-02-28 21:15:07 UTC
After discussion, there is set requirements on mysql package which provides the binary (above) instead of binary_req.

That's because we want to rather print package which should be installed instead of binary.

Comment 10 Alois Mahdal 2016-04-29 20:22:30 UTC
Tested with preupgrade-assistant-el6toel7-0.6.48-1.el6:

 *  If mysql is missing, followint two risks are logged:

        INPLACERISK: HIGH: Package mysql is not installed.
        INPLACERISK: HIGH: Please, install all required packages (and binaries) and run preupg again to process check properly.

 *  Otherwise, risks along with relevant .cnf file are printed according to
    particular option used.  This is the "lagrest" variant (all problematic
    options in place):

        INPLACERISK: MEDIUM: /etc/my.cnf: option 'plugin-load=innodb=' is not supported
        INPLACERISK: HIGH: /etc/my.cnf: option 'innodb_file_io_threads' is not supported
        INPLACERISK: HIGH: /etc/my.cnf: option 'language' is deprecated
        INPLACERISK: HIGH: /etc/my.cnf: option 'log-bin-trust-routine-creators' was removed in MariaDB 5.5
        INPLACERISK: HIGH: /etc/my.cnf: option 'table_lock_wait_timeout' was removed in MariaDB 5.5

        The files mentioned above are backups of your original configuration files.
        After the upgrade you must manually replace the contents of the default
        MariaDB 5.5 configuration (as is appropriate to your environment), with the
        information provided about replaced or deprecated options listed in the
        backups.  You must restart MariaDB for these changes to take effect.

Comment 11 errata-xmlrpc 2016-05-11 08:28:04 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://rhn.redhat.com/errata/RHBA-2016-1020.html


Note You need to log in before you can comment on or make changes to this bug.