Received: from polaris.nspco.com (polaris.nspco.com [206.10.243.2]) by hub.org (8.8.8/8.7.5) with ESMTP id QAA09538; Fri, 14 Aug 1998 16:17:28 -0400 (EDT) Received: from polaris.nspco.com (root@localhost) by polaris.nspco.com with ESMTP id PAA28870; Fri, 14 Aug 1998 15:17:26 -0500 (CDT) Received: from mnmail02.nspco.com (mnmail02.nspco.com [151.215.239.42]) by polaris.nspco.com with ESMTP id PAA28845; Fri, 14 Aug 1998 15:17:21 -0500 (CDT) Received: by mnmail02.nspco.com with Internet Mail Service (5.5.1960.3) id ; Fri, 14 Aug 1998 15:17:21 -0500 Message-ID: From: "Kapoor, Nishikant X" To: "'Amos Hayes'" Cc: pgsql-interfaces@postgreSQL.org, "'pgsql-general@postgreSQL.org'" Subject: RE: [GENERAL] No DB connection in Netscape ? Please help. Date: Fri, 14 Aug 1998 15:17:18 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.1960.3) Content-Type: text/plain Thanks so much, Amos. That worked and now I can connect to the database from anywhere in the network using NS/applet. Thanks to Cameron J. Mallory and Kenny Freeman for responding. Keep it up, guys. Nishi > -----Original Message----- > From: Amos Hayes [SMTP:ahayes@ingenia.com] > Sent: Friday, August 14, 1998 2:05 PM > To: Kapoor, Nishikant X > Cc: pgsql-interfaces@postgreSQL.org > Subject: 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 >