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

Bug 1149004

Summary:	Spacewalk Setup Fails on Fedora 20 with cannot find pltclu.control
Product:	[Community] Spacewalk	Reporter:	nathan
Component:	Installation	Assignee:	Tomas Lestach <tlestach>
Status:	CLOSED NOTABUG	QA Contact:	Red Hat Satellite QA List <satqe-list>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	2.2	CC:	tlestach
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2014-10-31 15:33:22 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 nathan 2014-10-02 21:49:10 UTC

Description of problem:
When following the instructions exactly according to https://fedorahosted.org/spacewalk/wiki/HowToInstall
when you reach the stage where you enter 'spacewalk-setup --disconnected'
The response is 'Could not install database.' and the file /var/log/rhn/install_db.log indicates that it could not open the control file pltclu.control


Version-Release number of selected component (if applicable):
spacewalk-postgresql 2.2.2
postgresql 9.3


How reproducible:
always reproducible when following the guide listed above

Steps to Reproduce:
1.on a fresh fedora install run 'yum install spacewalk-setup-postgresql'
2.run 'yum intstall spacewalk-postgresql'
3.run spacewalk-setup --disconnected

Actual results:
[root@spacewalk data]# spacewalk-setup --disconnected
* Setting up SELinux..
** Database: Setting up database connection for PostgreSQL backend.
Database "rhnschema" does not exist
** Database: Installing the database:
** Database: This is a long process that is logged in:
** Database:   /var/log/rhn/install_db.log
*** Progress: #
Could not install database.

Expected results:
success


Additional info:
This appears to be happening because spacewalk is installing 2 different versions of postgresql in different spots.  I'm not sure how to make the setup script look for the correct file in /usr/pgsql-9.3.

[root@spacewalk data]# cat /var/log/rhn/install_db.log
createlang: language installation failed: ERROR:  could not open extension control file "/usr/share/pgsql/extension/pltclu.control": No such file or directory

[root@spacewalk /]# find / -name pltclu.control
/usr/pgsql-9.3/share/extension/pltclu.control

[root@spacewalk /]# find / -name plpgsql.control
/usr/pgsql-9.3/share/extension/plpgsql.control
/usr/share/pgsql/extension/plpgsql.control

[root@spacewalk /]# yum list installed "postgresql*"
Loaded plugins: langpacks, refresh-packagekit
Installed Packages
postgresql.x86_64                                              9.3.1-2.fc20   
postgresql-jdbc.noarch                                         8.3.604-1.jpp5 
postgresql-libs.x86_64                                         9.3.1-2.fc20   
postgresql-server.x86_64                                       9.3.1-2.fc20   
postgresql93.x86_64                                            9.3.5-1PGDG.f20
postgresql93-contrib.x86_64                                    9.3.5-1PGDG.f20
postgresql93-libs.x86_64                                       9.3.5-1PGDG.f20
postgresql93-pltcl.x86_64                                      9.3.5-1PGDG.f20
postgresql93-server.x86_64                                     9.3.5-1PGDG.f20

Comment 1 Tomas Lestach 2014-10-31 15:33:22 UTC

I just took a freshly installed x86_64 Fedora20 machine and following steps led to a successful Spacewalk 2.2 installation:

========================================================================
yum update -y
rpm -Uvh http://yum.spacewalkproject.org/2.2/Fedora/20/x86_64/spacewalk-repo-2.2-1.fc20.noarch.rpm
cat > /etc/yum.repos.d/jpackage-generic.repo << EOF
[jpackage-generic]
name=JPackage generic
mirrorlist=http://www.jpackage.org/mirrorlist.php?dist=generic&type=free&release=5.0
enabled=1
gpgcheck=1
gpgkey=http://www.jpackage.org/jpackage.asc
EOF

yum install spacewalk-setup-postgresql
yum install spacewalk-postgresql
spacewalk-setup --disconnected
========================================================================

Database was correctly populated and only one PG server was installed:
# rpm -qa 'postgres*'
postgresql-server-9.3.5-2.fc20.x86_64
postgresql-9.3.5-2.fc20.x86_64
postgresql-jdbc-9.2.1002-4.fc20.noarch
postgresql-libs-9.3.5-2.fc20.x86_64
postgresql-pltcl-9.3.5-2.fc20.x86_64
postgresql-contrib-9.3.5-2.fc20.x86_64


I do not see postgresql93* packages to be a part of Feroda20. See http://download.englab.brq.redhat.com/pub/fedora/linux/releases/20/Everything/x86_64/os/Packages/p/
or:
# yum install postgresql93
No package postgresql93 available.


Closing as NOTABUG.

Comment 2 Eric Herget 2017-09-28 18:10:44 UTC

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