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

mrjavascript

Registered
Jan 15, 2013
3
0
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.
 
Last edited: