Re: PHPpgadmin and user privileges - Mailing list pgsql-general

From Nikolay Samokhvalov
Subject Re: PHPpgadmin and user privileges
Date
Msg-id e431ff4c0606290603i66da3080l1a9ecb6ac70cbf49@mail.gmail.com
Whole thread Raw
In response to PHPpgadmin and user privileges  ("Alain Roger" <raf.news@gmail.com>)
List pgsql-general
On 6/29/06, Alain Roger <raf.news@gmail.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

pgsql-general by date:

Previous
From: "Alain Roger"
Date:
Subject: phppgadmin
Next
From: Mehdi Aboulkassim
Date:
Subject: Script for reading flat file without delimiters