Re: PHPpgadmin and user privileges

On 6/29/06, Alain Roger <raf(dot)news(at)gmail(dot)com> wrote:
> Hi,
>
> I would like to provide access to PostgreSQL via PHPpgadmin.
>
> basically when user will enter login + password, he will connect directly to
> his database.
> what i've done till now, it does not work.
>
> when user enter login and password, phppgadmin returns "Login failed".
> my user hasfor profile "kmt_admin" which belong to "kmt_ad" group role" and
> which is owner of "kmt" database.
>
> Could you tell where to check to avoid such error ?

check your pg_hba.conf
http://www.postgresql.org/docs/7.3/static/client-authentication.html#AUTH-PG-HBA-CONF

most probably that you've forgotten to allow connections from that
host where phppgadmin is installed

--
Best regards,
Nikolay