| From: | JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | UNABLE TO CONNECT TO A DATABASE IN A WEB SERVER. |
| Date: | 2010-05-26 16:47:03 |
| Message-ID: | AANLkTikCEeGjmrvcOwpsZp0_IYz9_qlg5Af_tRjt_u5E@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
I am writing a web app which should connect to a database in a server within
my personal network but I am having trouble. I get the following error
message:
There is no record on pg_hba.conf for 192.168.1.77, user postgres, database
restaurant, SSL inactive.
I have checked the configuration files on the server machine as follows:
* The listen_addresses parameter in postgresql.conf equals *.
* The pg_hba.conf has an entry of type=host, database=all, user=all,
IP-Address=192.168.1.77/32, Password=md5.
I have tried changing the IP-Address to 192.168.1.0/24 and 192.168.0.0/16;
also I tried Password=Trust and Password=Password.
What else can I check?
Respectfully,
Jorge Maldonado
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tony Day | 2010-05-27 00:00:29 | Re: UNABLE TO CONNECT TO A DATABASE IN A WEB SERVER. |
| Previous Message | Sean Davis | 2010-05-26 10:39:16 | Re: Adding of indexes, best practises |