How to Fix PHPPgAdmin cPanel Login Issues

Introduction

Privileges are set up when a user first accesses the PostgreSQL databases page in their cPanel. If the user doesn't visit it, phppgadmin is not going to work. Also, ensure the user does not have a space in their cPanel password, causing issues logging into psql/phpPGadmin.

Sometimes, when getting a Login Failed error in PhpPgAdmin, the reason for this is the server preserving a cached user and password for the account in question.

Procedure

The solution for this is moving the pw.cache file to the side and then running upcp --force.

Renaming the Current pw.cache files:

mv /var/cpanel/pw.cache /var/cpanel/"pw.cache-"`date +"%Y-%m-%d"`

Forcing the update to UPCP, which will rebuild the pw.cache to the current cPanel user infomration.

/scripts/upcp --force