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

Bug 913361

Summary:	RHEL 5 Could not populate database on install.
Product:	[Community] Spacewalk	Reporter:	ismitley
Component:	Installation	Assignee:	Jan Pazdziora (Red Hat) <jpazdziora>
Status:	CLOSED WONTFIX	QA Contact:	Red Hat Satellite QA List <satqe-list>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	1.8	CC:	jpazdziora
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2013-02-22 08:52:18 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:	1484117

Description ismitley 2013-02-21 04:37:17 UTC

Description of problem:
Running RHEL 5.  Postgresql 9.2.  When I tried to do:

spacewalk-setup --disconnected --external-db

I would constantly get this:
** Database: Populating database.
*** Progress: #
Could not populate database.

I looked at /var/log/rhn/populate_db.log and it was telling me this:
psql:/etc/sysconfig/rhn/postgres/deploy.sql:4 /usr/share/pgsql/contrib/dblink.sql: No such file or directory.

To fix it, I did this:

mkdir -p /usr/share/pgsql/contrib
cp /usr/pgsql-9.2/share/extension/dblink--1.0.sql /usr/share/pgsql/contrib/dblink.sql

This fixed the issue.

How reproducible:
I could reproduce it every time.

Steps to Reproduce:
1. Be on RHEL 5.
2. Install Postgresql 9.2
3. Try to install Spacewalk

Comment 1 Jan Pazdziora (Red Hat) 2013-02-21 09:29:16 UTC

Did you have postgresql-contrib installed? If you did, I suggest you file a bug against whoever packaged that 9.2 for RHEL 5 because they did not follow what the typical RHEL 5 package provided by Red Hat looks like.

Comment 2 Jan Pazdziora (Red Hat) 2013-02-21 09:40:07 UTC

*** Bug 913360 has been marked as a duplicate of this bug. ***

Comment 3 ismitley 2013-02-21 19:29:26 UTC

Hey Jan.

Yes I did have it installed.  I'll file a bug against the Postgres guys, then, for their packaging.

Thanks!

- Isaac

Comment 4 Jan Pazdziora (Red Hat) 2013-02-22 08:52:18 UTC

Thanks for the information. I'm going to WONTFIX this bugzilla since we have no immediate plans to support the postgresql.org rpms.

Comment 5 Eric Herget 2017-09-28 17:56:57 UTC

This BZ closed some time during 2.5, 2.6 or 2.7.  Adding to 2.7 tracking bug.