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.