Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA58257 for ; Mon, 27 Sep 1999 09:58:21 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id JAA26183; Mon, 27 Sep 1999 09:57:48 -0400 (EDT) To: Anders Svensson cc: pgsql-interfaces@postgreSQL.org Subject: Re: [INTERFACES] Problem accessing databse via servlets In-reply-to: Your message of Mon, 27 Sep 1999 14:35:46 +0200 Date: Mon, 27 Sep 1999 09:57:48 -0400 Message-ID: <26181.938440668@sss.pgh.pa.us> From: Tom Lane Anders Svensson 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