[ADMIN] problems logging in through phpPgAdmin

[John DeSoi]

$conf['extra_login_security'] = false;
We are not having any problems logging into the databases from the command line.

Is the pg_hba.conf line where you changed "trust" to "md5" host or local? I think phpPgAdmin uses only host connections.


John DeSoi, Ph.D.

[John DeSoi]

local all all trust
host all all 127.0.0.1/32 md5
local all all md5
host all all 127.0.0.1/32 md5
then we cannot login at all -- even if we put in the correct password, we get "Login Failed" on the screen, and we just see " FATAL: password authentication failed for user "postgres"" in the log under pg_log.

And you say you tested psql from the command line like this

psql -U postgres -h 127.0.0.1

and it prompts you for the password and accepts the one you are entering with phpPgAdmin?

And PHP is running on the same server as Postgres?

What is the IP address used in your phpPgAdmin configuration? If it is not 127.0.0.1, you might need to use the explicit IP address in your pg_hba.conf.

Best,



John DeSoi, Ph.D.

[John DeSoi]

psql srn_mst
and it will get me into the database whether I have the line set to trust or md5. And does not ask for a password either way (never does). This is how I always access the database from the command line.

Right, because you are trusting local connections and that is what is used because there is no -h option provided.

psql -U postgres -h 127.0.0.1 -d srn_mst
if set to trust, this logs me in (does not ask for password of course).
psql: FATAL: password authentication failed for user "postgres"
(same as what is happening through the application).

Which means that you don't really know the postgres password :). If you can't access postgres this way, it is not going to work with phpPgAdmin either. You can login using the local connection and then change the postgres password.

Yes, PHP and phpPgAdmin and postgresql are all running on the same linux server (where this database srn_mst resides).
// Soarapp
$conf['servers'][3]['desc'] = 'Soarapp';
$conf['servers'][3]['host'] = 'localhost';
$conf['servers'][3]['port'] = 5432;
$conf['servers'][3]['defaultdb'] = 'template1';
$conf['servers'][3]['pg_dump_path'] = '/usr/bin/pg_dump';
$conf['servers'][3]['pg_dumpall_path'] = '/usr/bin/pg_dumpall';
Not sure if that is what your question refers to...

I was referring to the "host" setting. If you get the password fixed where it works with psql and it still does not work with phpPgAdmin, try changing the host setting to 127.0.0.1.



John DeSoi, Ph.D.