Skip site navigation (1) Skip section navigation (2)

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

From: Andreas Schmitz <mailinglist(at)longimanus(dot)net>
To: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: UNABLE TO CONNECT TO A DATABASE IN A WEB SERVER.
Date: 2010-05-27 07:05:04
Message-ID: 4BFE19A0.5090102@longimanus.net (view raw or flat)
Thread:
Lists: pgsql-novice
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


In response to

pgsql-novice by date

Next:From: Machiel RichardsDate: 2010-05-27 09:28:12
Subject: Setting up postgresql-8.3 on Debian
Previous:From: A. KretschmerDate: 2010-05-27 06:53:07
Subject: Re: UNABLE TO CONNECT TO A DATABASE IN A WEB SERVER.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group