Bug 2131781

Summary:	'candlepin-validate-db' pre-upgrade check fails with "Could not open SSL root certificate file /root/.postgresql/root.crt" error for external DB setup with SSL
Product:	Red Hat Satellite	Reporter:	Odilon Sousa <osousa>
Component:	Satellite Maintain	Assignee:	Amit Upadhye <aupadhye>
Status:	CLOSED ERRATA	QA Contact:	Gaurav Talreja <gtalreja>
Severity:	high	Docs Contact:
Priority:	unspecified
Version:	6.12.0	CC:	apatel, aupadhye, egolov, ehelms, kgaikwad, pcreech
Target Milestone:	6.11.4	Keywords:	Regression, Triaged, UpgradeBlocker
Target Release:	Unused
Hardware:	All
OS:	All
Whiteboard:
Fixed In Version:	rubygem-foreman_maintain-1.0.18	Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:	2124568	Environment:
Last Closed:	2022-10-27 13:08:46 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Comment 2 Gaurav Talreja 2022-10-10 17:06:17 UTC

Verified.

Tested on Satellite 6.11.4 Snap 1.0
Version: rubygem-foreman_maintain-1.0.18-1.el8sat.noarch

Steps:
1. Setup Satellite 6.11.3 with External DB with SSL along with 6.11.4 repos required for upgrade.
2. # foreman-maintain upgrade check --target-version 6.11.z
OR
2. # foreman-maintain health check --label candlepin-validate-db

Observation:
candlepin-validate-db check passes without any errors.

Comment 7 errata-xmlrpc 2022-10-27 13:08:46 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 (Important: Satellite 6.11.4 Async Security Update), 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-2022:7242