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

Bug 1392574

Summary: Missing Perl module when using Postgresql
Product: [Community] Spacewalk Reporter: Phil Porada <philporada>
Component: InstallationAssignee: Jan Dobes <jdobes>
Status: CLOSED NOTABUG QA Contact: Red Hat Satellite QA List <satqe-list>
Severity: high Docs Contact:
Priority: unspecified    
Version: 2.5   
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2017-10-27 14:59:32 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: 1564160    
Attachments:
Description Flags
Troubleshooting and installing the missing Perl module. none

Description Phil Porada 2016-11-07 19:37:29 UTC 
Created attachment 1218199 [details]
Troubleshooting and installing the missing Perl module.

Description of problem:


Version-Release number of selected component (if applicable):
Linux gldetxen01 4.8.4-200.fc24.x86_64 #1 SMP Tue Oct 25 13:06:04 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux
[root@gldetxen01 yum.repos.d]# rpm -qa | grep spacewalk
spacewalk-backend-app-2.6.69-1.fc24.noarch
spacewalk-backend-tools-2.6.69-1.fc24.noarch
spacewalk-base-minimal-2.6.5-1.fc24.noarch
spacewalk-backend-sql-2.6.69-1.fc24.noarch
spacewalk-backend-usix-2.6.69-1.fc24.noarch
spacewalk-backend-sql-postgresql-2.6.69-1.fc24.noarch
spacewalk-branding-2.5.3-1.fc24.noarch
spacewalk-backend-server-2.6.69-1.fc24.noarch
spacewalk-base-2.6.5-1.fc24.noarch
spacewalk-setup-jabberd-2.3.2-1.fc24.noarch
spacewalk-backend-xmlrpc-2.6.69-1.fc24.noarch
spacewalk-client-repo-2.5-3.fc24.noarch
spacewalk-schema-2.6.12-1.fc24.noarch
spacewalk-config-2.6.2-1.fc24.noarch
spacewalk-base-minimal-config-2.6.5-1.fc24.noarch
spacewalk-certs-tools-2.5.3-1.fc24.noarch
spacewalk-backend-2.6.69-1.fc24.noarch
spacewalk-repo-2.5-3.fc24.noarch
spacewalk-setup-2.6.2-1.fc24.noarch
spacewalk-setup-postgresql-2.6.2-1.fc24.noarch
spacewalk-backend-xml-export-libs-2.6.69-1.fc24.noarch
spacewalk-backend-libs-2.6.69-1.fc24.noarch
spacewalk-admin-2.6.1-1.fc24.noarch

How reproducible:
Every time when the perl-DBD-Pg package is not installed

Steps to Reproduce:
1. sudo dnf install -y http://spacewalk.redhat.com/yum/nightly/Fedora/24/x86_64/spacewalk-repo-2.5-3.fc24.noarch.rpm
2. sudo dnf install -y http://spacewalk.redhat.com/yum/nightly/Fedora/24/x86_64/spacewalk-client-repo-2.5-3.fc24.noarch.rpm
3. sudo dnf config-manager --set-enabled spacewalk-nightly spacewalk-client-nightly
4. sudo dnf config-manager --set-disabled spacewalk spacewalk-client
5. sudo dnf install -y spacewalk-setup spacewalk-setup-postgresql 
6. sudo spacewalk-setup

Actual results:
[root@gldetxen01 yum.repos.d]# spacewalk-setup
Choose your database backend (oracle, postgresql)? postgresql
** 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: ####
** Database: Installation complete.
Could not connect to the database.  Your connection information may be incorrect.  Error: install_driver(Pg) failed: Can't locate DBD/Pg.pm in @INC (you may need to install the DBD::Pg module) (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at (eval 17) line 3.
Perhaps the DBD::Pg perl module hasn't been fully installed,
or perhaps the capitalisation of 'Pg' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Sponge.
 at /usr/share/perl5/vendor_perl/Spacewalk/Setup.pm line 1688.


Expected results:
To not have a Postgresql related error.


Additional info:
Comment 1 Phil Porada 2016-11-07 19:44:47 UTC 
My solution was to run
sudo dnf install -y perl-DBD-Pg
sudo /usr/bin/spacewalk-setup-postgresql remove --db rhnschema --user rhnuser
sudo spacewalk-setup
Comment 2 Jan Dobes 2017-10-27 14:59:32 UTC 
This seems as not valid installation.

5. sudo dnf install -y spacewalk-setup spacewalk-setup-postgresql 

* spacewalk-setup-postgresql - this package pulls PostgreSQL database packages
* spacewalk-setup - not correct, it should be spacewalk-postgresql package instead, then the perl PG module will be installed

See https://github.com/spacewalkproject/spacewalk/wiki/HowToInstall