Red Hat Bugzilla – Bug 1392422
Searches on on parameters with "!=" does not work as expected.
Last modified: 2017-08-11 12:42:33 EDT
Description of problem: Host parameters search does not return expected results when using the "!=" operator. Version-Release number of selected component (if applicable): nightly How reproducible: always Steps to Reproduce: 1. Create a global parameter 'myparam' with value "1". 2. Override the parameter on one host with value "2". 3. Search for hosts matching "params.myparam != 0" Actual results: Only the overriden host is displayed. Expected results: All hosts are displayed. Additional info:
Is https://bugzilla.redhat.com/show_bug.cgi?id=1269021 a duplicate of this issue?
@shlomi - I don't think so, this one has to do with the custom method used to search on parameters, I don't think the same one is used for package names.
Note for anyone hitting this issue - this could be worked around by using 'not' in the search which works correctly, i.e. in the example above, "not params.myparam = 0" will return the correct result.
Upstream bug assigned to dhlavacd@redhat.com
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/17272 has been resolved.
HOTFIX INSTRUCTIONS - Specifically for: SATELLITE 6.2.9 Install instructions: 1) Download the attached tar for your appropriate version. 2) Extract files xvf Foreman_Hotfix_BZ1392422_el*.tar.bz2 3) Stop services with katello-service stop 4) CD into the unzipped folder and yum localinstall * 5) Start services with katello-service start I have attached a text file with the MD5 sums of all the contents of the tar files to check against.
Created attachment 1282068 [details] EL6 Hotfix
Created attachment 1282069 [details] EL7 Hotfix
Created attachment 1282070 [details] MD5 Sums for EL6
Created attachment 1282071 [details] MD5 Sums for EL7
Build: Satellite 6.2.11 snap1 hammer> host list --search "params.myparam = 1" ---|-----------------------------------------------------|------------------|------------|------------|------------------ ID | NAME | OPERATING SYSTEM | HOST GROUP | IP | MAC ---|-----------------------------------------------------|------------------|------------|------------|------------------ 2 | apple.satellite.com | RedHat 7.3 | | 0.0.0.2 | 00:1a:4a:3e:a6:2f 3 | mango.satellite.com | RedHat 7.3 | | 0.0.0.4 | 00:1a:4a:3e:a6:3f 4 | pineapple.satellite.com | RedHat 7.3 | | 0.0.0.6 | 00:1a:4a:3e:a6:33 1 | qe-sat6-feature-rhel7.satellite.com | RedHat 7.3 | | 0.0.0.1 | 52:54:00:32:9e:c6 ---|-----------------------------------------------------|------------------|------------|------------|------------------ hammer> host set-parameter --host-id 2 --name myparam --value=2 New host parameter created hammer> host set-parameter --host-id 4 --name myparam --value=2 New host parameter created hammer> host list --search "params.myparam = 1" ---|-----------------------------------------------------|------------------|------------|------------|------------------ ID | NAME | OPERATING SYSTEM | HOST GROUP | IP | MAC ---|-----------------------------------------------------|------------------|------------|------------|------------------ 3 | mango.satellite.com | RedHat 7.3 | | 0.0.0.4 | 00:1a:4a:3e:a6:3f 1 | qe-sat6-feature-rhel7.satellite.com | RedHat 7.3 | | 0.0.0.1 | 52:54:00:32:9e:c6 ---|-----------------------------------------------------|------------------|------------|------------|------------------ hammer> host list --search "params.myparam != 0" ---|-----------------------------------------------------|------------------|------------|------------|------------------ ID | NAME | OPERATING SYSTEM | HOST GROUP | IP | MAC ---|-----------------------------------------------------|------------------|------------|------------|------------------ 2 | apple.satellite.com | RedHat 7.3 | | 0.0.0.2 | 00:1a:4a:3e:a6:2f 3 | mango.satellite.com | RedHat 7.3 | | 0.0.0.4 | 00:1a:4a:3e:a6:3f 4 | pineapple.satellite.com | RedHat 7.3 | | 0.0.0.6 | 00:1a:4a:3e:a6:33 1 | qe-sat6-feature-rhel7.satellite.com | RedHat 7.3 | | 0.0.0.1 | 52:54:00:32:9e:c6 ---|-----------------------------------------------------|------------------|------------|------------|------------------
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://access.redhat.com/errata/RHBA-2017:2466