Bug 2029793

Summary: Installer fails to configure satellite with external postgresql, when no psql utility installed
Product: Red Hat Satellite Reporter: Gaurav Talreja <gtalreja>
Component: InstallationAssignee: satellite6-bugs <satellite6-bugs>
Status: CLOSED NOTABUG QA Contact: Omkar Khatavkar <okhatavk>
Severity: high Docs Contact:
Priority: unspecified    
Version: 6.10.1CC: egolov, ekohlvan, janarula, lvrtelov, swadeley
Target Milestone: 6.11.0Keywords: Regression, Triaged
Target Release: Unused   
Hardware: All   
OS: All   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2022-02-08 08:15:43 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 Gaurav Talreja 2021-12-07 10:26:35 UTC
Description of problem:
Installer fails to configure satellite with external database PostgreSQL when no psql utility installed

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

How reproducible:
Always

Steps to Reproduce:
1. Configure repos for satellite, and install satellite package.
2. Install and configure postgres on rhel7 box as per documentation[1]
3. Run installer to configure satellite with external db
# satellite-installer --scenario satellite \
--foreman-initial-admin-password <admin-passwd> \
--foreman-db-manage false \
--foreman-db-host $DATABASE \
--foreman-db-database foreman1db \
--foreman-db-username foreman1! \
--foreman-db-password <db-passwd> \
--foreman-db-port 5432 \
--katello-candlepin-manage-db false \
--katello-candlepin-db-host $DATABASE \
--katello-candlepin-db-name candlepin1db \
--katello-candlepin-db-user candlepin1! \
--katello-candlepin-db-password <db-passwd> \
--katello-candlepin-db-port 5432 \
--foreman-proxy-content-pulpcore-manage-postgresql false \
--foreman-proxy-content-pulpcore-postgresql-host $DATABASE \
--foreman-proxy-content-pulpcore-postgresql-db-name pulpcore1db \
--foreman-proxy-content-pulpcore-postgresql-user pulpcore1! \
--foreman-proxy-content-pulpcore-postgresql-password <db-passwd> \
--foreman-proxy-content-pulpcore-postgresql-port 5432


Actual results:
Installer fails in step 3, for missing psql utility

Expected results:
The installer should pass, and should install dependency for psql utility


Additional info:
1. WORKAROUND:
Install package "rh-postgresql12-postgresql-syspaths" on satellite before running the installer and installer pass in step 3.

2. Also tested the same scenario on 6.9.7, it just worked fine, after completion I check `rh-postgresql12-postgresql-syspaths` package was installed after the installer, so looks like a regression to me in 6.10

3. This BZ[2] just provided a fail-safe option for backup/restore for a similar issue.


[1] https://access.redhat.com/documentation/en-us/red_hat_satellite/6.10/html/installing_satellite_server_from_a_connected_network/performing-additional-configuration#using-external-databases_satellite
[2] https://bugzilla.redhat.com/show_bug.cgi?id=1921295

Comment 1 Evgeni Golov 2021-12-17 08:35:29 UTC
Is there a sosreport/foreman_debug available of the failed setup?

Or a reproducer?

Comment 4 Evgeni Golov 2022-01-27 11:32:11 UTC
I tried reproducing this, and couldn't.

Voting closing NOTABUG.

Comment 8 Evgeni Golov 2022-02-08 08:15:43 UTC
Closing this as NOTABUG after a week of inactivity.

Feel free to reopen if you have a reproducer that does not error out on the PostgreSQL server refusing more connections.