Bug 1729843
Summary: | Insights Remediation playbook fails with error "Failed to create job. Ensure your systems are registered in Foreman" when system hostname has uppercase characters | |||
---|---|---|---|---|
Product: | Red Hat Satellite | Reporter: | roarora | |
Component: | Ansible - Configuration Management | Assignee: | Rex White <rexwhite> | |
Status: | CLOSED ERRATA | QA Contact: | Peter Ondrejka <pondrejk> | |
Severity: | medium | Docs Contact: | ||
Priority: | unspecified | |||
Version: | 6.4 | CC: | ahumbe, dmatoule, jjeffers, ktordeur, mmccune, osousa, rexwhite, susalvi, tbrisker, zhunting | |
Target Milestone: | 6.10.0 | Keywords: | Triaged | |
Target Release: | Unused | |||
Hardware: | All | |||
OS: | All | |||
Whiteboard: | ||||
Fixed In Version: | tfm-rubygem-redhat_access-2.9.1 | Doc Type: | If docs needed, set a value | |
Doc Text: | Story Points: | --- | ||
Clone Of: | ||||
: | 1962876 (view as bug list) | Environment: | ||
Last Closed: | 2021-11-16 14:08:51 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: | ||
Embargoed: |
Description
roarora
2019-07-15 06:03:24 UTC
This is fixed in redhat_access-2.2.15.gem. This gem is valid for satellite 6.5, 6.6, 6.7 and 6.8 Still reproducible in Satellite 6.9 snap 17 tfm-rubygem-redhat_access-2.2.19 Steps: - on host, modify hostname so that it contains uppercase characters - register host to satellite using global registration dialog with insights setting enabled - after successful registration, observe the hostname appears upcased in the insights overview, but downcased in the hosts list - create a remediation playbook and plan for the host When clicking Run Playbook in the Plans detail view, a popup appears: Failed to create job. Ensure your systems are registered in Foreman If using Customized Playbook run, and submitting the rex job, the result is red screen with: Oops, we're sorry but something went wrong PG::SyntaxError: ERROR: syntax error at or near "vms" LINE 1: ...location_id" = $3 AND (( hosts.name IN(<hostname>... ^ Prodlog excrept in attachment. Confiming the changes from associated github pr landed with tfm-rubygem-redhat_access-2.2.19 Going to move this out of 6.9 to 6.10 where we are fully removing the old legacy access plugin and will have this solved when remediations are handled by the new cloud plugin. The error in comment #11 was fixed by https://github.com/redhataccess/foreman-plugin/pull/59 which is in version 2.2.20 of the gem. Moving to MODIFIED. Verified on Satellite 6.10 snap 23 using steps from the comment 11, registered host now appears with downcased hostname in the remediation list, remediation job is executed successfully 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 (Moderate: Satellite 6.10 Release), 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/RHSA-2021:4702 |