The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

DBD/Pg/Pg.so problem -- keeps coming back

Discussion in 'General Discussion' started by erick_paper, Jul 8, 2011.

  1. erick_paper

    erick_paper Well-Known Member

    Joined:
    Apr 19, 2005
    Messages:
    245
    Likes Received:
    0
    Trophy Points:
    16
    I keep getting these messages. All Perl modules are installed. What am I missing?

    I need Postgesql, but I do not need Perl with it. We use PHP to access it.

    What is this message and how to get rid of it?!!!


     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Could you confirm the method you used to install PostgreSQL?

    It's generally advised that you use the method documented at:

    Installing PostgreSQL

    If you have used the reccomended method to install PostgreSQL and continue to receive this error message, please feel free to open a support ticket for this issue so we can investigate further for you:

    Submit A Ticket

    Thank you.
     
  3. erick_paper

    erick_paper Well-Known Member

    Joined:
    Apr 19, 2005
    Messages:
    245
    Likes Received:
    0
    Trophy Points:
    16
    This "recommended method" is a joke because it installs a highly insecure, highly unstable ANCIENT version of postgresql which is utterly useless for any serious production environment.

    When cpanel comes up with a modern and adult way of installing the latest stable version of this massively important open source database (more important these days than the inconsistent mysql) then perhaps I'll use the recommended way.

    I installed Postgresql 9.0.4 (64 bit) from RPMs as described on the postgresql website.

    Any ideas?
     
  4. gbromios

    gbromios Registered

    Joined:
    Jul 11, 2011
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Just chiming in here with my findings here; one of the boxes on our network is sending the same message, and when I try to install DBD::Pg through CPAN, it errors out with the following:

    ****************
    WARNING! DBD::Pg no longer supports versions less than 7.4.
    You must upgrade PostgreSQL to a newer version.
    ****************

    Indeed, the current postgres on the server is 7.3. I'm not sure if updating it's going to be viable, since it's on CentOS 3.9, so we might just end up migrating it.
     
  5. gkgcpanel

    gkgcpanel Well-Known Member

    Joined:
    Jun 6, 2007
    Messages:
    217
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    DataCenter Provider

    We just got this too, while upgrading to 11.30 STABLE on one of our servers. (others have been upgraded without problems).
    The strange thing is, that we don't have PostGreSQL on this particular server. Never had it there. We only have PG on one server and it was already successfully upgraded.

    So why would Pg.pm be failing if PostGreSQL is not even installed???
     
  6. gkgcpanel

    gkgcpanel Well-Known Member

    Joined:
    Jun 6, 2007
    Messages:
    217
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    DataCenter Provider

    UPDATE: The upgrade did finish (took a lot longer than it usually does), and everything seems to be working just fine.

    However, this morning, I still got another notice:

    This module is required by cPanel, and the system may not function correctly until it is installed, and functional. Below is the results of the auto-install attempt:

    Test Run
    ==============
    Can't locate DBD/Pg.pm in @INC (@INC contains: /usr/lib/perl5/5.8.8/i686-linux /usr/lib/perl5/5.8.8 /usr/lib/perl5/site_perl/5.8.8/i686-linux /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl .) at - line 1.
    BEGIN failed--compilation aborted at - line 1.


    Installer Run
    ==============

    Why??? and what must be done to stop these notices (other than the obvious of installing PostGreSQL, which I don't want to do...
     
  7. gkgcpanel

    gkgcpanel Well-Known Member

    Joined:
    Jun 6, 2007
    Messages:
    217
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    DataCenter Provider


    Still getting regular emails like this...

    Subject: [checkperlmodules] The perl module DBD::Pg could not be installed.

    This module is required by cPanel, and the system may not function correctly until it is installed, and functional. Below is the results of the auto-install attempt:

    Test Run
    ==============
    Can't locate DBD/Pg.pm in @INC (@INC contains: /usr/lib/perl5/5.8.8/i686-linux /usr/lib/perl5/5.8.8 /usr/lib/perl5/site_perl/5.8.8/i686-linux /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl .) at - line 1.
    BEGIN failed--compilation aborted at - line 1.


    Installer Run
    ==============


    What needs to be done to fix this problem???
     
  8. gkgcpanel

    gkgcpanel Well-Known Member

    Joined:
    Jun 6, 2007
    Messages:
    217
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    DataCenter Provider
    Did another upgrade yesterday thinking *MAYBE* it might fix this.

    It didn't and I'm still getting these emails daily...

    PostGreSQL is installed on this server, (just not running because it's not needed). I even tried starting it and running the upgrade again (with --force) and it still gives the same error message that Pg.pm could not be installed...

    So just tried running /scripts/installpostgres...

    # ./installpostgres
    This script will install PostgreSQL 7.3.x or later
    If you have an older version installed you wil need to
    Dump your databases to a file and then restore them
    after the install as 7.3.x is not backwards compatible.
    If you do not have any databases, you can just run:
    mv /var/lib/pgsql /var/lib/pgsql.old
    /sbin/service postgresql stop
    /sbin/service postgresql start
    to force creating a 7.3.x style setup. Do not do this if
    you have databases that you wish to keep!

    Are you sure you wish to proceed? y
    Loaded plugins: fastestmirror
    Loading mirror speeds from cached hostfile
    Excluding Packages in global exclude list
    Finished
    Setting up Install Process
    No package rh-postgresql available.
    No package rh-postgresql-devel available.
    No package rh-postgresql-libs available.
    No package rh-postgresql-server available.
    Package postgresql-8.1.23-1.el5_6.1.i386 already installed and latest version
    Package postgresql-libs-8.1.23-1.el5_6.1.i386 already installed and latest version
    Package postgresql-server-8.1.23-1.el5_6.1.i386 already installed and latest version
    Resolving Dependencies
    --> Running transaction check
    ---> Package postgresql-devel.i386 0:8.1.23-1.el5_6.1 set to be updated
    --> Finished Dependency Resolution

    Dependencies Resolved

    ================================================================================
    Package Arch Version Repository Size
    ================================================================================
    Installing:
    postgresql-devel i386 8.1.23-1.el5_6.1 base 1.2 M

    Transaction Summary
    ================================================================================
    Install 1 Package(s)
    Upgrade 0 Package(s)

    Total download size: 1.2 M
    Downloading Packages:
    Running rpm_check_debug
    Running Transaction Test
    Finished Transaction Test
    Transaction Test Succeeded
    Running Transaction
    Installing : postgresql-devel 1/1

    Installed:
    postgresql-devel.i386 0:8.1.23-1.el5_6.1

    Complete!
    Installing Bundle::DBD::Pg
    .........
    .........
    .........
    .........
    .........
    .........
    .........
    .........
    .........
    .........
    You should now configure PostgreSQL from WHM!


    Of course, we don't want to configure PostgreSQL from WHM because this server does not need it nor do we want our customers to have it.
     
  9. 000

    000 Well-Known Member

    Joined:
    Jun 3, 2008
    Messages:
    150
    Likes Received:
    0
    Trophy Points:
    16
    How is possible install this?

    Just I have same problem:

    Can't locate DBD/Pg.pm...

    How I can install this ?
    Is possible manually ?
     
  10. storminternet

    storminternet Well-Known Member

    Joined:
    Nov 2, 2011
    Messages:
    462
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Run
    and it will open up cpan command prompt. It's possible that you may get list of questions if you use this command for the first time.

    To install DBD::Pg you just need to type
     
  11. 000

    000 Well-Known Member

    Joined:
    Jun 3, 2008
    Messages:
    150
    Likes Received:
    0
    Trophy Points:
    16
    THANKS!

    Some command to check if perl module DBD::Pg is installed?
    Some command to check if perl module DBD::Pg is running?
    Some command to check VERSION of perl module DBD::Pg ?
     
  12. gkgcpanel

    gkgcpanel Well-Known Member

    Joined:
    Jun 6, 2007
    Messages:
    217
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    DataCenter Provider
    Ok, so this is happening again. On 4 cPanel servers that don't have PostGreSQL installed on them, and I'm getting the same message each day:

    Code:
    
    This module is required by cPanel, and the system may not function correctly until it is installed, and functional.  Below is the results of the auto-install attempt:
    
    Test Run
    ==============
    Can't locate DBD/Pg.pm in @INC (@INC contains: /usr/lib/perl5/5.8.8/i686-linux /usr/lib/perl5/5.8.8 /usr/lib/perl5/site_perl/5.8.8/i686-linux /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl/5.8.7 /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl .) at - line 1.
    BEGIN failed--compilation aborted at - line 1.
    
    
    Installer Run
    ==============
    
    
    I already tried running the above:

    Code:
    cpan> install DBD::Pg
    
    It installed just fine (no errors), but I still get the same email every single day.

    Out of the 14 cPanel servers we have, these 4 are the only ones reporting this problem. The rest are working fine.
     
  13. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,478
    Likes Received:
    203
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    gkgcpanel, have you opened a ticket on this, and if yes could you post the ticket id here please?

    Thanks!
     
  14. gkgcpanel

    gkgcpanel Well-Known Member

    Joined:
    Jun 6, 2007
    Messages:
    217
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    DataCenter Provider
    Yes, I did open a ticket and the issue was addressed. This is what they said they did:

    Code:
    cd /var/lib/
    /sbin/service postgresql stop
    tar -cvf pgsql-2012-11-20-01-3424021.tar pgsql
    gzip pgsql-2012-11-20-01-3424021.tar
    /usr/local/cpanel/scripts/installpostgres
    /sbin/service postgresql start
    
    WHM >> Home >SQL Services >Configure Postgres >> Install Config
    WHM >> Home >SQL Services >Configure Postgres >> Create Users
    
    In our case, PostGreSQL was not running on the servers in question so all I did was the /usr/local/cpanel/scripts/installpostgres line and that did seem to solve the problem.

    Although, I don't understand why because I tried that initially before submitting a ticket and it did NOT work. But as of this morning, no emails stating that this failed, so assuming it is now fixed.
     
Loading...

Share This Page