Strange Postgres / Tomcat log on error. - Mailing list pgsql-jdbc

From Jason Porter
Subject Strange Postgres / Tomcat log on error.
Date
Msg-id 1C47F9167B873F489B45243528C5EF03B4A9A7@studentmail.Student.Northface.local
Whole thread Raw
List pgsql-jdbc
Here's my situation:  I've installed Postgres 8.1.3 and tomcat 5.5.16
and all the dependencies, I'm on a Win 2k3 box.  I can connect using the
postgres Admin program just find and there are no problems.  I can run
my web app on a different box and everything connects just fine.
However, when I run the web app on the same box that contains the
database I get a connection refused error.

Here's my context.xml:
<?xml version="1.0" encoding="UTF-8"?>
<Context crossContext="true" debug="1" docBase="NeuView" path="/Neuview"
reloadable="true">
  <Resource auth="Container" driverClassName="org.postgresql.Driver"
maxActive="20" maxIdle="10" maxWait="-1" name="jdbc/postgres"
password="..." type="javax.sql.DataSource"
url="jdbc:postgresql://192.168.27.40:5432/neuview" username="..."/>
</Context>

I've tried using 127.0.0.1, localhost and the actual IP (above) in the
url, but that doesn't seem to help.  I've also tried different users and
passwords, still no go.

Here's the postgres.conf file (relating to tcp/ip):
listen_addresses = '*'        # what IP address(es) to listen on;
                    # comma-separated list of
addresses;
                    # defaults to 'localhost', '*' =
all
port = 5432
...

authentication_timeout = 60        # 1-600, in seconds
ssl = off
password_encryption = on
...

tcp_keepalives_idle = 0        # TCP_KEEPIDLE, in seconds;
                    # 0 selects the system default
tcp_keepalives_interval = 0        # TCP_KEEPINTVL, in seconds;
                    # 0 selects the system default
tcp_keepalives_count = 0        # TCP_KEEPCNT;
                    # 0 selects the system default

Here's the pg_hba.conf as well:

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
host    all        all        0.0.0.0/0        md5
# IPv4 local connections:
host    all         all         127.0.0.1/32          md5
# IPv6 local connections:
#host    all         all         ::1/128               md5

This problem really baffles me, and is getting a little frustrating.
Any one have any ideas?

-Jason Porter


pgsql-jdbc by date:

Previous
From: David Durham
Date:
Subject: Re: connection pooling with servlets
Next
From: "Guy Rouillier"
Date:
Subject: Re: connection pooling with servlets