Re: UNABLE TO CONNECT TO A DATABASE IN A WEB SERVER. - Mailing list pgsql-novice

From Tony Day
Subject Re: UNABLE TO CONNECT TO A DATABASE IN A WEB SERVER.
Date
Msg-id AANLkTikE9-sBrWlP_LG7TrLv4gsrhEk7qAcRJnNb4PGt@mail.gmail.com
Whole thread Raw
In response to UNABLE TO CONNECT TO A DATABASE IN A WEB SERVER.  (JORGE MALDONADO <jorgemal1960@gmail.com>)
List pgsql-novice
Hi Jorge

I would perhaps try:

type=hostnossl, database=all, user=all, cidr-address=192.168.1.0/24, method=trust

Please keep in mind that I am also very much a novice so this is a case of the "blind trying to lead the blind ..." :-)

Regards, Tony


On Thu, May 27, 2010 at 9:45 AM, JORGE MALDONADO <jorgemal1960@gmail.com> wrote:
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

pgsql-novice by date:

Previous
From: JORGE MALDONADO
Date:
Subject: UNABLE TO CONNECT TO A DATABASE IN A WEB SERVER.
Next
From: Joshua Tolley
Date:
Subject: Re: UNABLE TO CONNECT TO A DATABASE IN A WEB SERVER.