Re: UNABLE TO CONNECT TO A DATABASE IN A WEB SERVER.

the entry should like

host all all 192.168.1.77/32 password

or

host all all 192.168.1.0/24 password

do not forget to reload the server (pg_ctl reload) when making changes
to pg_hba.conf

try connecting to the DB manually from the webserver

psql -h <hostname> <dbname> -U <username>

if you still have problems change the setting password to trust and try
again to make sure the problem is related to the network and not to the
auth mechanism.

regards

andreas

JORGE MALDONADO 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 <http://192.168.1.77/32>, Password=md5.
>
> I have tried changing the IP-Address to 192.168.1.0/24
> <http://192.168.1.0/24> and 192.168.0.0/16 <http://192.168.0.0/16>;
> also I tried Password=Trust and Password=Password.
>
> What else can I check?
>
> Respectfully,
> Jorge Maldonado