SOLVED CPANEL-40049 - PhpPgAdmin login fails after cPanel update

Operating System & Version
CentOS v7.9.2009
cPanel & WHM Version
11.100.0

TA

Member
Dec 2, 2020
8
1
3
South Africa
cPanel Access Level
Root Administrator
When logging into phpPgAdmin through cPanel I'm repeatedly getting 'Login failed'. This error only started today (after upgrading cPanel to v100.0.10). Previously I have had no problems accessing phpPgAdmin.

However I have tried to trouble-shoot, doing the following:

- WHM >> SQL Services >> Configure PostgreSQL >> Install Config & Create Users
- set listen_addresses = '*' in /var/lib/pgsql/data/postgresql.conf
- added 'local all all trust' and 'host all all 127.0.0.1/32 trust' in /var/lib/pgsql/data/pg_hba.conf

(all the above followed by postgresql service restarts)

I am not sure where to proceed from here - can someone provide suggestions?

(phpPgAdmin 5.6, PostgreSQL 9.2, PHP 7.3)
 

TA

Member
Dec 2, 2020
8
1
3
South Africa
cPanel Access Level
Root Administrator
Thanks for the quick response. The article states " If you access the cPanel account using a root generated session, you will not encounter this problem. " - how do I do this? I need a work-around in the short term.
 

TomKu

Member
Oct 10, 2011
20
1
53
Chicago
cPanel Access Level
Root Administrator
The workaround in case CPANEL-40049 suggests using root account. Well, root does not need phppgadmin to access postgres. Regular users prefer phppgadmin and they are still complaining. Its 2 days already. Please start fixing it.