Login disallowed for security reasons postgresql centos server

1). Open -> /etc/phppgadmin -> config.inc.php

2). change $conf['extra_login_security'] = true; to $conf['extra_login_security'] = false;

// If extra login security is true, then logins via phpPgAdmin with no // password or certain usernames (pgsql, postgres, root, administrator) // will be denied. Only set this false once you have read the FAQ and // understand how to change PostgreSQL's pg_hba.conf to enable // passworded local connections.

I had this exact same problem - also on CentOS - and also had no luck changing that security setting to false.

It turned out that it's not using the config file we expected.

It's using:/usr/share/phpPgAdmin/conf/config.inc.php

and not:/etc/phpPgAdmin/config.inc.php

even though the RPM (phpPgAdmin-5.1-1.rhel6.noarch) installs both of them...

I really don't see why it has two unless there is an override defined somewhere... but I don't really have time to look into it. I'm sure there is no reason why you can't replace the one in /etc with a symlink (or hardlink) to the other, although it could cause problems if you try to uninstall the RPM. But I wouldn't unless you were dead keen to have it in /etc - just in case. I'm sure they didn't include two of these just for fun ;)

I know this is probably too late to help you but the fact I came across this today means it's likely to be of use to someone :)

You need to restart the postgresql

systemctl restart postgresql

systemctl restart apache2