Strange Postgres / Tomcat log on error.

Поиск
Список
Период
Сортировка
От Jason Porter
Тема Strange Postgres / Tomcat log on error.
Дата
Msg-id 1C47F9167B873F489B45243528C5EF03B4A9A7@studentmail.Student.Northface.local
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: David Durham
Дата:
Сообщение: Re: connection pooling with servlets
Следующее
От: "Guy Rouillier"
Дата:
Сообщение: Re: connection pooling with servlets