Thread: 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
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