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.

PHP - can't install the PGsql driver using Easy Apache

Discussion in 'Database Discussions' started by mrjavascript, Jan 15, 2013.

  1. mrjavascript

    mrjavascript Registered

    Joined:
    Jan 15, 2013
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Trying to add the pgsql module to my PHP build and am getting the following:

    Code:
    PGsql [More Info ↑]  click here for details
    
    The last time Cpanel::Easy::PHP5::Pgsql was run; step returned 0.
    
    That just caused Cpanel::Easy::PHP5::Pgsql to be skipped.
    
    The message it gave was:
    Unable to find postgresql path
    
    You might want to take that into consideration when choosing options and troubleshooting.
    I tried installing the DB server using the provided scripts and this error surfaces:

    Code:
    warn [restartsrv_postgresql] PostgreSQL service is not installed
    Installing DBD::Pg
            .........
            .........
    
    The PostgreSQL packages have been installed successfully. To configure,
    navigate to WHM's Postgres Config feature where you can set your password
    and enable PostgreSQL functionality for existing user accounts.
    
    Setting random password for postgres database user
    The service is running, however according to the logs (/usr/local/cpanel/logs/error_log) it can't find the configuration:

    Code:
    [2013-01-16 05:28:56 +0000] info [updatephppgadmin] Applied patch '0013-remove-prefix-from-username.patch'
    patching file classes/database/Postgres80.php
    patching file classes/database/Postgres81.php
    patching file classes/database/Postgres83.php
    [2013-01-16 05:28:56 +0000] info [updatephppgadmin] Applied patch '0014-remove-extra-action-from-database.php.patch'
    patching file database.php
    [2013-01-16 05:28:56 +0000] info [updatephppgadmin] Successfully applied 14 patches
    [2013-01-16 05:28:56 +0000] warn [restartsrv_postgresql] PostgreSQL service is not installed at /usr/local/cpanel/scripts/restartsrv_postgresql line 44
    [2013-01-16 05:28:58 +0000] info [checkperlmodules] /root/.cpanel/datastore/Cpanel::Sys::Compiler::test_compile_cc
    [2013-01-16 05:29:02 +0000] warn [postgrescheck] PostgreSQL not installed at /usr/local/cpanel/Cpanel/AdvConfig/postgres.pm line 25
            Cpanel::AdvConfig::postgres::get_config(HASH(0x3165ba8)) called at /usr/local/cpanel/Cpanel/AdvConfig.pm line 50
            eval {...} called at /usr/local/cpanel/Cpanel/AdvConfig.pm line 50
            Cpanel::AdvConfig::generate_config_file(HASH(0x31659e8)) called at /usr/local/cpanel/Cpanel/PostgresUtils.pm line 179
            Cpanel::PostgresUtils::passwd('vC8vXTVaYCnwHVE4', '/root/.pgpass') called at /usr/local/cpanel/bin/postgrescheck line 87
    [2013-01-16 05:29:02 +0000] warn [postgrescheck] Failed to get postgres configuration: No such file or directory at /usr/local/cpanel/Cpanel/AdvConfig.pm line 60
            Cpanel::AdvConfig::generate_config_file(HASH(0x31659e8)) called at /usr/local/cpanel/Cpanel/PostgresUtils.pm line 179
            Cpanel::PostgresUtils::passwd('vC8vXTVaYCnwHVE4', '/root/.pgpass') called at /usr/local/cpanel/bin/postgrescheck line 87
    How can I resolve this? Is there a symlink I can place as a stop gap to get cPanel to recognize the 9.2 install? Originally it was erring due to DBD::Pg missing, but I was able to install that module via CPAN.
     
    #1 mrjavascript, Jan 15, 2013
    Last edited: Jan 15, 2013
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,449
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Are you running EDGE tier? If yes, try this:
    scripts/check_cpanel_rpms --fix

    That's from a post sent to the EDGE list yesterday having to do with an update overnight. Not sure if its helpful here or not.
     
  3. mrjavascript

    mrjavascript Registered

    Joined:
    Jan 15, 2013
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    We're not running the EDGE tier (version 11.34.1 of cPanel.) I also tried looking for the RPM check script and it's not in the scripts/ directory.
     
  4. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,449
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
  5. mrjavascript

    mrjavascript Registered

    Joined:
    Jan 15, 2013
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Followed the steps in the link. Getting the following error when clicking on "install config" in WHM:

     
  6. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,449
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
Loading...

Share This Page