Please help me with pg_hba.conf file settings

From: "akacker" <akacker(at)lw1(dot)vsnl(dot)net(dot)in>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Please help me with pg_hba.conf file settings
Date: 2000-11-20 10:15:41
Message-ID: 000801c052da$d7520a00$0e09a8c0@tanya4
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Dear Sir
Hello!
I have a Linux web server on which I am providing name based hosting
services to my clients.
I want that my clients who have their virtual sites on my server should
be able to connect to their databases by using php or any other
server side programs to connect to postgresql database thourgh their
password authentications.

For this I edited the pg_hba.conf file of Postgresql which is at the
location /var/lib/pgsql/pg_hba.conf and I added the following lines
at the bottom of this file using vi editor.

host all 64.65.7.145 255.255.255.255 trust

By adding the above file in pg_hba.conf file my clients are able to
connect to their databases but even if they give any wrong password
in their server side programs which they are using to connect to
their database they are able to access their databse.

I tried adding the following lines to pg_hba.conf file :

host all 64.65.7.145 255.255.255.255 password pgpass

I created pgpass by the command pg_passwd pgpass and added
the user (i.e my client username and password) but it did not
work. though this way it is working fine on my local intranet
which is on Linux.

Please help me solve my problem.
Regards

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mário Jorge Nunes Filipe 2000-11-20 10:33:59 Migrating from 6.3.2 to 6.5
Previous Message Jacopo Silva 2000-11-20 07:17:32 PAM