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