Re: problems logging in through phpPgAdmin

On Sep 26, 2011, at 10:16 AM, Davenport, Julie wrote:

> We are using phpPgAdmin 4.2.3 on Redhat Linux 5 to access local postgres 8.4 databases and some remote postgres 8.0
and7.4 databases.  If I set the pg_hba.conf settings to “trust” I can login to phpPgAdmin with any password at all or
withno password at all.  If I change the “trust” to “md5” I get “Login Failed” errors on every login (we always login
aspostgres), even though the password is correct.  When this happens I check the log in pg_log folder, and all it says
is“FATAL:  password authentication failed for user "postgres"”.  In the phpPgAdmin config.inc.php file, we have this
setting:
> $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.