| Summary: | Searches on on parameters with "!=" does not work as expected. | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Product: | Red Hat Satellite | Reporter: | Tomer Brisker <tbrisker> | ||||||||||
| Component: | Search | Assignee: | Dominik Hlavac Duran <dhlavacd> | ||||||||||
| Status: | CLOSED ERRATA | QA Contact: | Sanket Jagtap <sjagtap> | ||||||||||
| Severity: | high | Docs Contact: | |||||||||||
| Priority: | high | ||||||||||||
| Version: | Nightly | CC: | bbuckingham, bkearney, jcallaha, kelly.brown1, mhulan, mmccune, mtaru, oshtaier, pwaghmar, sabnave, sjagtap, szadok, xdmoon, zhunting | ||||||||||
| Target Milestone: | Unspecified | Keywords: | Triaged | ||||||||||
| Target Release: | Unused | ||||||||||||
| Hardware: | Unspecified | ||||||||||||
| OS: | Unspecified | ||||||||||||
| Whiteboard: | |||||||||||||
| Fixed In Version: | foreman-1.11.0.78-1 | Doc Type: | If docs needed, set a value | ||||||||||
| Doc Text: | Story Points: | --- | |||||||||||
| Clone Of: | |||||||||||||
| : | 1463806 (view as bug list) | Environment: | |||||||||||
| Last Closed: | 2017-08-10 17:02:29 UTC | Type: | Bug | ||||||||||
| Regression: | --- | Mount Type: | --- | ||||||||||
| Documentation: | --- | CRM: | |||||||||||
| Verified Versions: | Category: | --- | |||||||||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||||||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||||||||
| Attachments: |
|
||||||||||||
|
Description
Tomer Brisker
2016-11-07 13:24:42 UTC
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 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 |