Bug 1392574 - Missing Perl module when using Postgresql
Summary: Missing Perl module when using Postgresql
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: Spacewalk
Classification: Community
Component: Installation
Version: 2.5
Hardware: x86_64
OS: Linux
unspecified
high
Target Milestone: ---
Assignee: Jan Dobes
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: space28
TreeView+ depends on / blocked
 
Reported: 2016-11-07 19:37 UTC by Phil Porada
Modified: 2018-04-20 12:21 UTC (History)
0 users

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2017-10-27 14:59:32 UTC
Embargoed:


Attachments (Terms of Use)
Troubleshooting and installing the missing Perl module. (5.73 KB, text/plain)
2016-11-07 19:37 UTC, Phil Porada
no flags Details

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


Note You need to log in before you can comment on or make changes to this bug.