Bug 1562705

Summary: syntax error while checking database configurations
Product: Red Hat Satellite Reporter: Nikhil Kathole <nkathole>
Component: Satellite MaintainAssignee: Anurag Patel <apatel>
Status: CLOSED WONTFIX QA Contact: Nikhil Kathole <nkathole>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 6.3.1CC: apatel, inecas, kgaikwad
Target Milestone: UnspecifiedKeywords: Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2019-06-03 12:05: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:
Embargoed:
Bug Depends On:    
Bug Blocks: 1496794    

Description Nikhil Kathole 2018-04-02 07:40:27 UTC 
Description of problem: 

https://github.com/theforeman/foreman_maintain/blob/master/lib/foreman_maintain/concerns/base_database.rb#L25


Version-Release number of selected component (if applicable):

# rpm -qa | grep maintain
rubygem-foreman_maintain-0.1.5-1.el7sat.noarch


How reproducible: always


Steps to Reproduce:
1. foreman-maintain health check


Actual results: foreman-maintain.log shows syntax error

D, [2018-04-02 03:33:38-0400 #18491] DEBUG -- : Running command PGPASSWORD='fJd5jieiW75sscbysdL2GjrkCkgaJk6X' psql -d foreman -h localhost  -p 5432 -U foreman with stdin {:stdin=>"SELECT 1 as ping"}
D, [2018-04-02 03:33:38-0400 #18491] DEBUG -- : output of the command:
 ERROR:  syntax error at or near "{"
LINE 1: {:stdin=>"SELECT 1 as ping"}


Expected results: No error in foreman-maintain.log.


Additional info: It wont affect anything in output but still need fix for safer side.

 # foreman-maintain health check
Running ForemanMaintain::Scenario::FilteredScenario
================================================================================
Check for verifying syntax for ISP DHCP configurations:               [OK]
--------------------------------------------------------------------------------
Check for paused tasks:                                               [OK]
--------------------------------------------------------------------------------
Check whether all services are running using hammer ping:             [OK]
--------------------------------------------------------------------------------
Comment 2 Bryan Kearney 2019-05-02 19:06:48 UTC 
The Satellite Team is attempting to provide an accurate backlog of bugzilla requests which we feel will be resolved in the next few releases. We do not believe this bugzilla will meet that criteria, and have plans to close it out in 1 month. This is not a reflection on the validity of the request, but a reflection of the many priorities for the product. If you have any concerns about this, feel free to contact Red Hat Technical Support or your account team. If we do not hear from you, we will close this bug out. Thank you.
Comment 3 Bryan Kearney 2019-06-03 12:05:29 UTC 
Thank you for your interest in Satellite 6. We have evaluated this request, and while we recognize that it is a valid request, we do not expect this to be implemented in the product in the foreseeable future. This is due to other priorities for the product, and not a reflection on the request itself. We are therefore closing this out as WONTFIX. If you have any concerns about this, please do not reopen. Instead, feel free to contact Red Hat Technical Support. Thank you.