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