phpPgAdmin always showing login failed

zaher

Active Member
Jul 2, 2014
37
0
6
cPanel Access Level
Root Administrator
Hello Sir,

Suddenly, as I try to access phpPgAdmin i get Login Failed.

I checked phpPgAdmin configuration file (“conf/config.inc.php”) and adjusted:
Code:
$conf['servers'][0]['host'] = ''
To
Code:
$conf['servers'][0]['host'] = 'localhost'
Also I tried with $conf['extra_login_security'] being false and true.

The pg_hba.conf file is as such
Code:
local samerole all        md5   
host samerole all  127.0.0.200   255.255.255.255   pam  pamservice=postgresql_cpses 
host samerole all  127.0.0.1   255.255.255.255   md5   
local all postgres        md5 
host all postgres  127.0.0.1   255.255.255.255   md5   
host all all  ::1/128  md5
I also tried adding the following without success
Code:
local all all trust
Anything I am missing?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,216
463
Hello :)

Please browse to:

"WHM Home » SQL Services » Configure PostgreSQL"

Click on the "Install Config" and "Create Users" options and then restart PostgreSQL. If the issue persists, please open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome.

Thank you.
 

zaher

Active Member
Jul 2, 2014
37
0
6
cPanel Access Level
Root Administrator
Hello :)

Please browse to:

"WHM Home » SQL Services » Configure PostgreSQL"

Click on the "Install Config" and "Create Users" options and then restart PostgreSQL. If the issue persists, please open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome.

Thank you.
I had come accorss this while troubleshooting, but didn't do it because it says
You should not use this unless you are installing Postgres for the first time.
Are you sure I need to apply this?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,216
463
It simply reverts your pg_hba.conf file to default, which is fine if you have made no custom changes (other than the ones you took when attempting to resolve the issue).

Thank you.