Trying to add the pgsql module to my PHP build and am getting the following:
I tried installing the DB server using the provided scripts and this error surfaces:
The service is running, however according to the logs (/usr/local/cpanel/logs/error_log) it can't find the configuration:
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.
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.
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
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
Last edited: