From: Tom Lane <tgl@sss.pgh.pa.us>
To: Anders Svensson <anders@simusoft.dk>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Problem accessing databse via servlets
Date: Mon, 27 Sep 1999 09:57:48 -0400
Message-ID: <26181.938440668@sss.pgh.pa.us> (raw)
In-Reply-To: <v04020a00b41513e1571f@[192.168.1.3]>
Anders Svensson <anders@simusoft.dk> writes:
> I have 2 servlets, with basicly the same code for the database interface.
> My problem is that one works the others doesn't.
> The funny thing ?? is that the trouble program works if it is not run from
> a servlet, but from a command line????????
Strictly a guess, but: I recall a similar complaint which turned out
to be due to some kind of "virtual hosting" setup on the web server.
The net effect was that the applet appeared to be connecting from a
different IP address than the user thought it would be connecting from,
and of course that virtual IP address wasn't listed in pg_hba.conf.
If you are running a recent Postgres release (I think >= 6.5 but maybe
this is in >= 6.5.1) the postmaster log should show the IP address that
it saw the connection as coming from, so you can check this theory by
looking in the logfile.
The same message is echoed back to the client, BTW, but apparently the
jserv code thinks it should protect your innocent eyes by not showing
you the server error message :-(
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, anders@simusoft.dk
Subject: Re: [INTERFACES] Problem accessing databse via servlets
In-Reply-To: <26181.938440668@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox