Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1506597

Summary: In doc Installation guide there are missing information about pltclu
Product: Red Hat Satellite 5 Reporter: Martin Korbel <mkorbel>
Component: DocumentationAssignee: satellite-doc-list
Status: CLOSED EOL QA Contact: satellite-doc-list
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 570CC: mawerner, tlestach
Target Milestone: ---   
Target Release: ---   
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: 2020-02-28 19:28:16 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 Martin Korbel 2017-10-26 11:51:12 UTC
This is copy bz1410345 for Sat5.7  (& Sat5.6)
In doc Installation guide there are missing information about pltclu.

https://<fqdn>/rhn/help/satellite/en-US/sect-Scenario_3_Installing_Satellite_with_External_Database.jsp

Version:
rhn-i18n-guides-5.7.0.1-6


Reproducer:
1. prepare external PG server for satellite (https://access.redhat.com/documentation/en-us/red_hat_satellite/5.7/html/installation_guide/sect-scenario_3_installing_satellite_with_external_database#sect-External_Database_Requirements)

2. install satellite
> ./install.pl --disconnected --external-postgresql
* Starting Red Hat Satellite installer.
* Performing pre-install checks.
* Pre-install checks complete.  Beginning installation.
* RHN Registration.
** Registration: Disconnected mode.  Not registering with RHN.
* Checking for uninstalled prerequisites.
.....
* Setting up SELinux..
** Database: Setting up database connection for PostgreSQL backend.
** Database: Installing the database:
** Database: This is a long process that is logged in:
** Database:   /var/log/rhn/install_db.log
*** Progress: #
psql:/etc/sysconfig/rhn/postgres/deploy.sql:15914: ERROR:  language "pltclu" does not exist
Use CREATE LANGUAGE to load the language into the database.




Fix is pretty simple:

postgres=# \connect spaceschema
You are now connected to database "spaceschema" as user "postgres".

spaceschema=# \dL
                      List of languages
  Name   |  Owner   | Trusted |         Description          
---------+----------+---------+------------------------------
 plpgsql | postgres | t       | PL/pgSQL procedural language
(1 row)

spaceschema=# CREATE EXTENSION pltclu;
CREATE EXTENSION
spaceschema=# \dL
                          List of languages
  Name   |  Owner   | Trusted |              Description              
---------+----------+---------+---------------------------------------
 plpgsql | postgres | t       | PL/pgSQL procedural language
 pltclu  | postgres | f       | PL/TclU untrusted procedural language
(2 rows)

Comment 1 Matt Werner 2020-02-28 19:28:16 UTC
Closing this bug because Satellite 5 is going end-of-life and will not be receiving further updates.