Re: problems logging in through phpPgAdmin

Sorry, when I said we had no trouble getting in from the command line, I meant that I could do the following to get
intodatabase named srn_mst (after su-ing to postgres user): 

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
eitherway (never does).  This is how I always access the database from the command line.  When I tried the way you
suggested:

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).
If set to md5, this command asks me for password, but when I put it in, gives me this error:
psql: FATAL:  password authentication failed for user "postgres"
(same as what is happening through the application).

Yes, PHP and phpPgAdmin and postgresql are all running on the same linux server (where this database srn_mst resides).


This is the enry in my phppgadmin conf file config.inc.php for this server:
// 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...

Thanks....


Julie



-----Original Message-----
From: John DeSoi [mailto:desoi@pgedit.com]
Sent: Monday, September 26, 2011 1:58 PM
To: Davenport, Julie
Cc: pgsql-admin@postgresql.org; Hussey, Latasha
Subject: Re: [ADMIN] problems logging in through phpPgAdmin


On Sep 26, 2011, at 2:19 PM, Davenport, Julie wrote:

> If I use this combination:
> local   all         all                               trust
> host    all     all     127.0.0.1/32    md5
> or this:
> 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
justsee " 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
explicitIP address in your pg_hba.conf. 

Best,



John DeSoi, Ph.D.