Re: [GENERAL] No DB connection in Netscape ? Please help.

On Fri, 14 Aug 1998, Kapoor, Nishikant X wrote:

> Typing "mm01: netscape http://genx/PrfApplet.htm" brings up the applet
> in the NS
> but the database connection is not established. The Java console shows:
>
> openDb(PrfDb):Connecting to Database URL = jdbc:postgresql:prfdb...
> openDb(PrfDb): Could not connect. e= security.Couldn't connect to
> 'localhost' with origin from 'genx'.


> The same problems exits when I start NS from the same machine where the
> PostgreSQL
> server is running i.e. the Linux box(genx).
>
> *** But, when I use "genx: netscape http://127.0.0.1/PrfApplet.htm" on
> genx, the
> *** database connection gets established.


I'm guessing that you have to configure postgress to allow connections
from other hosts. In the fist case, you are comming from another machine
and it won't let you in. In the second case, you are comming from the same
machine but using the machine's hostname. In this case, your IP stack is
telling itself that the connection is comming from your IP address not
your localhost address, so it won't let that in either. The third try
works because postgres is told that the connection is comming from
127.0.0.1 which it is (by default I assume) configured to accept.

This is behaviour that I've seen for all sorts of other access control
situations, so I'm guessing it's the problem here. If I'm not mistaken,
you want to have a look at the pg_access man page and the pg_hba.conf
file.


--
Amos Hayes                      Systems Architect
ahayes@ingenia.com            Ingenia Group - Software Kinetics Ltd.
http://smurf.ingenia.com/~ahayes        http://www.ingenia.com

"Remember: No one can make you feel inferior without your consent."
   - ELEANOR ROOSEVELT