Обсуждение: PHPpgadmin and user privileges

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 ?

thanks a lot,

Alain

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